Languages
LanguageID | LanguageName |
1 | English |
2 | French |
3 | German |
4 | Italian |
5 | Japanese |
Chefs
ChefID | FirstName | LastName | LanguageID |
| | | (→ Languages.LanguageID) |
1 | John | Doe | 1 |
2 | Mary | Smith | 2 |
3 | Alice | Brown | 3 |
4 | Bob | White | 4 |
5 | Charlie | Black | 5 |
Servers
ServerID | FirstName | LastName | LanguageID |
| | | (→ Languages.LanguageID) |
1 | Jack | Green | 1 |
2 | Emma | Blue | 2 |
3 | David | Yellow | 3 |
4 | Lucy | Red | 4 |
5 | Oliver | Orange | 5 |
Restaurants
RestaurantID | Name | Address | PhoneNumber | OpeningHours |
1 | Le Jardin | 123 Main St | 555-1234 | 9am - 10pm |
2 | La Maison | 456 Elm St | 555-5678 | 10am - 11pm |
3 | Der Biergarten | 789 Oak St | 555-9012 | 11am - midnight |
4 | Il Ristorante | 999 Pine St | 555-1357 | Noon - 11pm |
5 | The Sushi Bar | 321 Maple Ave | 555-1415 | Lunch & dinner only |
ChefRestaurants
ChefID | RestaurantID | HireDate |
(→ Chefs.ChefID) | (→ Restaurants.RestaurantID) | |
1 | 1 | 2020-01-01 |
2 | 2 | 2021-02-01 |
3 | 3 | 2020-06-01 |
4 | 4 | 2021-08-01 |
5 | 5 | 2020-09-01 |
ServerRestaurants
ServerID | RestaurantID | HireDate |
(→ Servers.ServerID) | (→ Restaurants.RestaurantID) | |
1 | 1 | 2020-02-01 |
2 | 2 | 2021-03-01 |
3 | 3 | 2020-07-01 |
4 | 4 | 2021-09-01 |
5 | 5 | 2020-10-01 |