Online Shop

Created by: Abhinav Sharma, Himanshu Raj, Rohit Makkar, Jaspreet Saka and Ritik Garg

Build an Online Shop which can be used by Customer, Supplier, Manager, Employee and Owner of the Shop. It is a CLI based project with many features. Made as a part of project in Database Management System course at IIIT-Delhi.

Features-

1. Multiple User Support.
2. ID and Password Authentication at Sign-In.
3. Heirarchy of Shop is maintained. Owner is at the highest level and Manager under him and Employees are under Manager.
4. Different Stats Display for Owner and Manager.
5. Prediction of Sales feature to assist Manager and Owner with the stocks.
6. Repeat/show Previous Order option to Customer.
7. Option to add discount on an item.
8. Optimized search implementation for all the users.

Tools and Technologies Used-

1. MySQL for database.
2. Python for CLI based interaction.
3. Python mysql.connector module to connect with database.
4. Python SVM module used to predict the sales.

How to use-

1. Run Scripts/src/mysqldump.sql to upload the database on your system.
2. Run OnlineShop.py

Note- You must have python modules mysql.connector and numpy installed before running this project.