Online Retail System

• A Cross Platform Online Retail System App Built Using Python and Flutter for our Fundamentals of Database Management System (CSE202) Course at IIITD
• Built using Python and Flutter 🎉
• Backend is Flask APIs returning data from a MySQL Database 🧑‍💻
• Frontend is a cross-platform application built using Flutter 🔍

Some Cool Features 🕵️:

• Fully functional ordering, cancelling, cart system and coupons.
• Over 150 Products in diverse categories
• Choice of shipper depending on choice of shipper speed
• Supports multiple brands
• Allows searching based on multiple parameters such as brand names, category names and product names
• Ranks products based on best selling (quantity and cost wise) in the app homepage
• Gives admins a separate dashboard to modify the app
• Admins can add, remove and update products with the click of a button
• Admins can also add new brands, categories and shippers
• Admins also reserve the power to remove users with some constraints
• Proper care has been taken to use views to hide confidential information away from users and admins

Setup Instructions:

To create database 📅:

• Run Data/createDB.sql to create the database retaildb
• Run Data/DataDump.sql to create all tables and populate data inside retaildb

To run backend 👈:

• Install the following python dependencies:
  • flask
  • mysql-connector
• Replace with your MySQL Server credentials here in backend.py
• Run backend.py

To run frontend 👉:

• Build the app located in FrontEnd/ by following instructions here
• An APK Version is also located here
• Run it after starting backend and viola enjoy 🎇

Notes:

• The project scope and proposal along with relational schemas can be found here
• The Entity Relation Diagram used to design this project:

Made by Faizan, Aflah, Shivaansh & Aryaman