Languages

LanguageIDLanguageName
1English
2French
3German
4Italian
5Japanese

Chefs

ChefIDFirstNameLastNameLanguageID
(→ Languages.LanguageID)
1JohnDoe1
2MarySmith2
3AliceBrown3
4BobWhite4
5CharlieBlack5

Servers

ServerIDFirstNameLastNameLanguageID
(→ Languages.LanguageID)
1JackGreen1
2EmmaBlue2
3DavidYellow3
4LucyRed4
5OliverOrange5

Restaurants

RestaurantIDNameAddressPhoneNumberOpeningHours
1Le Jardin123 Main St555-12349am - 10pm
2La Maison456 Elm St555-567810am - 11pm
3Der Biergarten789 Oak St555-901211am - midnight
4Il Ristorante999 Pine St555-1357Noon - 11pm
5The Sushi Bar321 Maple Ave555-1415Lunch & dinner only

ChefRestaurants

ChefIDRestaurantIDHireDate
(→ Chefs.ChefID)(→ Restaurants.RestaurantID)
112020-01-01
222021-02-01
332020-06-01
442021-08-01
552020-09-01

ServerRestaurants

ServerIDRestaurantIDHireDate
(→ Servers.ServerID)(→ Restaurants.RestaurantID)
112020-02-01
222021-03-01
332020-07-01
442021-09-01
552020-10-01