Geervanireddy16 / online-bookstore-management

DBMS Project for College
https://onlinebookstoree.herokuapp.com/
MIT License
9 stars 4 forks source link
bootstrap css flask html javascript mongodb mongodb-atlas mysql python

Online BookStore Management Application

An application with two portals - admin and customer.

Admins can add book ,delete book and update book. Admins can view the book Inventory(total and sold book stocks), all accounts and orders placed by customers in the application.

Customers can buy only one book at a time and with a quantity of 1 to 5 only. Customers have to register to purchase/view more books.

Customers and admin have a home page where all books by genre is displayed and details of book will be displayed on clicking a particular book. They can search a book by title, genre or author name.

Using MySQL and MongoDB are two separate projects

Technology Stack

Website Preview

Admin Portal Preview

!Demo

Customer Portal Preview

!Demo

Project Structure

.
├── Using MySQL
|   └── static
|       └── bootstrap
|       └── css
|       └── images
|       └── js 
|   └── templates                   # html files 
|   └── utils                       # code files
|   └── app.py              
|   └── onlinebookstore db.sql      # tables and queries used for this project
|   └── .gitignore
|   └── .env
|   └── requirements.txt
|
├── Using NoSQL - MongoDB
|   └── static
|       └── bootstrap
|       └── css
|       └── images
|       └── js 
|   └── templates                   # html files 
|   └── utils                       # code files
|   └── app.py              
|   └── mongoqueries.txt      # queries and triggers code
|   └── .gitignore
|   └── .env
|   └── Procfile              # tells Heroku how to startup your application on it's server
|   └── requirements.txt
|
├── LICENSE
└── README.md