Chefs

chef_idnamelanguageexperience_years
1JuanSpanish10
2MichaelEnglish8
3PeterFrench6
4EmmaGerman7
5DavidItalian9

Servers

server_idnamelanguageyears_of_service
1LuisSpanish3
2TomEnglish2
3RachelFrench1
4LucasGerman4
5IsabellaItalian5

Customers

customer_idnamephone_numberpreferred_server_id
(→ Servers.server_id)
1Alice123-456-78901
2Bob987-654-32102
3Charlie555-555-55553
4Diana111-222-33334
5Eva444-444-44445

Restaurants

restaurant_idnameaddresscuisine
1La Tapatia123 Main StMexican
2Le Petit Bistro456 Elm StFrench
3Il Ristorante789 Oak StItalian
4The Curry House135 Pine StIndian
5El Sultan246 Maple AveMiddle Eastern

Menus

menu_idrestaurant_iddishprice
(→ Restaurants.restaurant_id)
11Tacos10.99
21Enchiladas12.99
32Coq au Vin24.99
42Croissant3.99
53Spaghetti Carbonara15.99

Orders

order_idcustomer_idrestaurant_idtotal_price
(→ Customers.customer_id)(→ Restaurants.restaurant_id)
11125.97
22132.98
33240.96
44248.95
55355.94