## Executive_chef

chef_id | first_name | last_name
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Johnson

## Sous_chef

sous_id | first_name | last_name | executive_chef_id
--- | --- | --- | ---
|  |  | (→ Executive_chef.chef_id)
1 | Alice | Brown | 1
2 | Bob | White | 2
3 | Charlie | Green | 3

## Restaurant

restaurant_id | name | address | executive_chef_id | SOUS_CHEF_ID
--- | --- | --- | --- | ---
|  |  | (→ Executive_chef.chef_id) | (→ Sous_chef.sous_id)
1 | The Ritz | Main Street | 1 | 1
2 | Le Grande | East Side | 2 | 2
3 | Ocean View | Beach Road | 3 | 3

## Menu_items

menu_item_id | item_name | description | price
--- | --- | --- | ---
1 | Steak | Grilled Steak with Veggies | 30.99
2 | Salmon | Grilled Salmon with Rice | 25.8
3 | Pasta | Spaghetti Bolognese | 15.6
4 | Pizza | Margherita Pizza | 12.5
5 | Burger | Cheeseburger and Fries | 10.8

## Orders

order_id | customer_name | date | total_amount | restaurant_id
--- | --- | --- | --- | ---
|  |  |  | (→ Restaurant.restaurant_id)
1 | Customer A | 2021-08-10 | 60.2 | 1
2 | Customer B | 2021-08-11 | 45.5 | 2
3 | Customer C | 2021-08-12 | 75.3 | 3
4 | Customer D | 2021-08-13 | 80.5 | 1
5 | Customer E | 2021-08-14 | 55.2 | 2

## Order_details

detail_id | quantity | menu_item_id | order_id
--- | --- | --- | ---
|  | (→ Menu_items.menu_item_id) | (→ Orders.order_id)
1 | 2 | 1 | 1
2 | 1 | 2 | 2
3 | 1 | 3 | 3
4 | 1 | 1 | 4
5 | 1 | 4 | 5