Menus

menu_idnamedescriptionappetizersbuffet
1SomeMenuDescription for Some Menu.SaladHilton
2AnotherMenuDescription for Another Menu.SaladNot Hilton
3YetAnotherMenuDescription for Yet Another Menu.SoupHilton
4FourthMenuDescription for Fourth Menu.SoupNot Hilton

Customers

customer_idnamephone
1John Doe1234567890
2Jane Smith9876543210
3Bob Johnson1112223330
4Alice Brown2223334440

Orders

order_idcustomer_idmenu_idtotal_price
(→ Customers.customer_id)(→ Menus.menu_id)
11130.99
22225.5
33340.75
44435.45

FoodItems

item_idfood_typenamepricemenu_id
(→ Menus.menu_id)
1StarterGarden Salad7.991
2Main CourseGrilled Chicken15.992
3DessertTiramisu6.992
4StarterTomato Soup4.993
5Main CourseBeef Steak20.993
6Side DishMashed Potatoes3.994
7DessertCheesecake5.994