| chef_id | first_name | last_name |
|---|---|---|
| 1 | John | Doe |
| 2 | Jane | Smith |
| 3 | Michael | Johnson |
| 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_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_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 |
| 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 |
| 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 |