We aimed to build a near-realistic E-Commerce database platform. Almost all functionality mentioned in the requirements doc in phase 1 has been implemented, and the CLI is in a near-perfect state.
We have implemented several command-line features that include
- Creating a user that can be a Customer, Supplier, or Delivery Agent.
- Login for each of these users to access functionality that corresponds to them.
Features for the Customer :
- Search from a range of items sorted by categories, which themselves are sorted by super-categories.
- Search for Product by Product Brand or Product Name or by category name.
- Add to Cart option.
- Place an order, choosing the desired Delivery Agent, the Warranty of 2-years, and Delivery within two days of ordering.
- See all the pending deliveries by bill number.
Features for the Supplier :
- Add new products to the database with the price.
- Update the prices of products.
Queries
- Search by product name.
- Search by category.
- Show pending deliveries.
- Show purchase.
- Show payment mode (while making payment).
- Search USER details for authentication and deciding user type (in login). And some more.
Updating/Modification
- Update the price of products.
- Add to and Delete from the cart.
- Create a User account.
- Place an order (multiple additions and updates to the database).
- main.py
- Dump.sql
- MISC_SQL\Final.sql
- MISC_SQL\Input.sql
- README.md
2019111031
2019111015
2019101105
Made with ❤️ by our team