restaurant_SQL_Project

ABOUT THIS PROJECT

Design a restaurant database with 5 tables :

1. Employee
2. Menu
3. order_tx
4. order_tx_item
5. customer

ER Diagram

Create queries for

1. Sorting menu items by descending order of popularity
2. Calculating revenue, profit, and cost for each transaction
3. Identifying the employee responsible for each transaction
4. Tracking customer spending
5. Summarizing daily revenue, cost, and profit."