Skip to content

About

Data-driven food delivery management system using MySQL, MongoDB, and Python analytics

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

Β 

History

33 Commits

Folders and files

NameName
Last commit message
Last commit date
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🍽️ Smart Food Delivery & Marketplace Management System

Python MySQL MongoDB Status


πŸ“Œ Overview

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.


πŸš€ Key Highlights

  • 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

🧱 System Architecture

πŸ”Ή Relational Model (MySQL)

Includes:

  • Customers
  • Restaurants
  • Menu & Menu Items
  • Orders & Order Items
  • Payments
  • Drivers & Deliveries
  • Promotions & Reviews

Ensures:

  • Data integrity
  • Reduced redundancy
  • Efficient querying

πŸ”Ή NoSQL Model (MongoDB)

  • Collections: customers, restaurants, drivers, orders
  • Embedded documents for:
    • order items
    • payment
    • delivery

Advantages:

  • Flexible schema
  • Reduced joins
  • Faster nested queries

πŸ“Š Analytics & Visualizations

Orders per Restaurant

Orders

Insight: This chart compares total order volume across restaurants and helps identify high-demand partners.

Top Selling Items

Items

Insight: This chart highlights the most frequently ordered menu items, which can support menu optimization and inventory planning.

Revenue Distribution

Revenue

Insight: This visualization shows how revenue is distributed across restaurants and helps identify the strongest revenue contributors.

Daily Orders Trend

Trend

Insight: This chart tracks daily order activity and helps detect demand patterns and peak ordering periods.

Payment Methods

Payments

Insight: This chart shows customer payment preferences and can support checkout strategy and digital payment promotion.

Ratings vs Orders

Ratings

Insight: This visualization compares restaurant ratings and helps evaluate service quality across partners.


πŸ“Š Business Insights

  • Identified top-performing restaurants
  • Analyzed payment behavior
  • Detected peak order trends
  • Evaluated ratings vs performance
  • Compared revenue distribution

πŸ”„ System Workflow

  1. Customer places order
  2. Order linked to restaurant
  3. Payment processed
  4. Driver assigned
  5. Delivery completed
  6. Feedback recorded

πŸ“‚ Project Structure

smart-food-delivery-management-system/
β”‚
β”œβ”€β”€ app/
β”œβ”€β”€ sql/
β”œβ”€β”€ nosql/
β”œβ”€β”€ diagrams/
β”œβ”€β”€ charts/
β”œβ”€β”€ docs/
β”‚
β”œβ”€β”€ requirements.txt
└── README.md

▢️ How It Works

Running the application will:

  • connect to the MySQL database
  • execute analytical SQL queries
  • generate visualization charts
  • save all output charts in the charts/ folder

βš™οΈ Setup Instructions

1. Clone Repository

git clone https://github.com/devp2611/smart-food-delivery-management-system.git
cd smart-food-delivery-management-system

2. Install Requirements

pip install -r requirements.txt

3. Setup Database

Run the SQL script in MySQL Workbench or terminal:

mysql -u root -p < sql/schema_and_seed.sql

4. Configure Database

Open:

app/db_config.py

Update:

password="your_password_here"

5. Run Application

python app/app.py

Future Improvements

  • Web dashboard (Flask/Streamlit)
  • Real-time tracking
  • API integration
  • ML-based predictions

Author

Dev Patel

About

Data-driven food delivery management system using MySQL, MongoDB, and Python analytics

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages