Executive_chef

chef_idfirst_namelast_name
1JohnDoe
2JaneSmith
3MichaelJohnson

Sous_chef

sous_idfirst_namelast_nameexecutive_chef_id
(→ Executive_chef.chef_id)
1AliceBrown1
2BobWhite2
3CharlieGreen3

Restaurant

restaurant_idnameaddressexecutive_chef_idSOUS_CHEF_ID
(→ Executive_chef.chef_id)(→ Sous_chef.sous_id)
1The RitzMain Street11
2Le GrandeEast Side22
3Ocean ViewBeach Road33

Menu_items

menu_item_iditem_namedescriptionprice
1SteakGrilled Steak with Veggies30.99
2SalmonGrilled Salmon with Rice25.8
3PastaSpaghetti Bolognese15.6
4PizzaMargherita Pizza12.5
5BurgerCheeseburger and Fries10.8

Orders

order_idcustomer_namedatetotal_amountrestaurant_id
(→ Restaurant.restaurant_id)
1Customer A2021-08-1060.21
2Customer B2021-08-1145.52
3Customer C2021-08-1275.33
4Customer D2021-08-1380.51
5Customer E2021-08-1455.22

Order_details

detail_idquantitymenu_item_idorder_id
(→ Menu_items.menu_item_id)(→ Orders.order_id)
1211
2122
3133
4114
5145