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

• Frontend: HTML, CSS, Bootstrap, Javascript
• Backend: Python Flask
• Database:
  1. MySQL
  2. MongoDB

Website Preview

Admin Portal Preview

admin.portal.mp4

Customer Portal Preview

customer.portal.mp4

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