Doordash Database Project

This project represents a basic data model of Doordash implemented using Python and PostgreSQL.

Requirements

It is required to have PostgreSQL installed as well as the psycopg2 python module installed.

pip install psycopg2

(OR) pip install psycopg2-binary

This database realizes these following user pain points:

As a Customer, I want to place order online and get it delivered to my door
As a Customer, I wish to add a restaurant to my favorite list
As a Customer, I want to rate the restaurant I ordered from
As a Customer, I want to browse all restaurants in my current zip code with 4+ average rating
As a Dasher, I want to see my average rating
As a Dasher, I want to see what are the most popular areas (in terms of number of orders)
As a Dasher, I want to check my weekly total tips for the past month
As a Merchant, I want to add items on my menu
As a Merchant, I want to see the most popular dishes being ordered
As a Merchant, I want to offer coupons for customers who have ordered at my restaurant over a certain number of times

Data entities for Doordash's data model can be visualized in the following ERD:

Run initialize.sql (This file creates all tables, relationships, and loads example seed data from the seeds folder)
Run python3 queries.py (This will show a menu on cmd where directions are provided)

create.sql -> file creating PostgreSQL table structure and relationships queries.py -> file containing SQL queries