Restaurants

idNameTypeYear_of_Establishment
1Fine SteaksSteakhouse1980
2The Rib HouseSteakhouse2005
3Surfside SeafoodSeafood Restaurant1980
4Coastal CatchSeafood Restaurant2010

Staff

idFirstNameLastNamePositionRestaurantId
(→ Restaurants.id)
1JohnDoeManager1
2JaneSmithWaiter1
3BobJohnsonChef2
4AliceWilliamsHostess3

MenuItems

idItemNameDescriptionPriceRestaurantId
(→ Restaurants.id)
1T-bone SteakA delicious T-bone steak with garlic butter.35.991
2Shrimp ScampiGrilled shrimps sauteed with white wine, garlic and parsley.20.993
3Garlic BreadCrusty bread baked with lots of freshly minced garlic.6.994
4Mixed Greens SaladA refreshing salad with a variety of mixed greens, cherry tomatoes, cucumber and feta cheese.8.992

Reservations

idCustomerNameContactNumberNumInPartyDateTimeRestaurantId
(→ Restaurants.id)
1Alex Johnson+123456789042022-06-1519:00:001
2Emily Smith+123456789122022-06-1720:00:002
3Chris Brown+123456789262022-06-1818:00:003
4Kelly Clarkson+123456789382022-06-1917:00:004