This project presents a data-driven food delivery management system designed to simulate real-world platforms like Uber Eats or DoorDash.
The system integrates:
- Relational Database (MySQL)
- NoSQL Database (MongoDB)
- Python-based analytics for insights and visualization
This project demonstrates an end-to-end data pipeline from database design to analytics and visualization.
- Designed an end-to-end database system for food delivery operations
- Implemented MySQL schema with 3NF normalization
- Developed analytical SQL queries for business insights
- Built a Python analytics pipeline using Pandas and Matplotlib
- Implemented MongoDB NoSQL model with aggregation queries
- Generated visual dashboards for decision-making
Includes:
- Customers
- Restaurants
- Menu & Menu Items
- Orders & Order Items
- Payments
- Drivers & Deliveries
- Promotions & Reviews
Ensures:
- Data integrity
- Reduced redundancy
- Efficient querying
- Collections: customers, restaurants, drivers, orders
- Embedded documents for:
- order items
- payment
- delivery
Advantages:
- Flexible schema
- Reduced joins
- Faster nested queries
Insight: This chart compares total order volume across restaurants and helps identify high-demand partners.
Insight: This chart highlights the most frequently ordered menu items, which can support menu optimization and inventory planning.
Insight: This visualization shows how revenue is distributed across restaurants and helps identify the strongest revenue contributors.
Insight: This chart tracks daily order activity and helps detect demand patterns and peak ordering periods.
Insight: This chart shows customer payment preferences and can support checkout strategy and digital payment promotion.
Insight: This visualization compares restaurant ratings and helps evaluate service quality across partners.
- Identified top-performing restaurants
- Analyzed payment behavior
- Detected peak order trends
- Evaluated ratings vs performance
- Compared revenue distribution
- Customer places order
- Order linked to restaurant
- Payment processed
- Driver assigned
- Delivery completed
- Feedback recorded
smart-food-delivery-management-system/
β
βββ app/
βββ sql/
βββ nosql/
βββ diagrams/
βββ charts/
βββ docs/
β
βββ requirements.txt
βββ README.md
Running the application will:
- connect to the MySQL database
- execute analytical SQL queries
- generate visualization charts
- save all output charts in the
charts/folder
git clone https://github.com/devp2611/smart-food-delivery-management-system.git
cd smart-food-delivery-management-systempip install -r requirements.txtRun the SQL script in MySQL Workbench or terminal:
mysql -u root -p < sql/schema_and_seed.sqlOpen:
app/db_config.pyUpdate:
password="your_password_here"python app/app.py- Web dashboard (Flask/Streamlit)
- Real-time tracking
- API integration
- ML-based predictions
Dev Patel





