ID | Name |
---|---|
1 | Buffet |
2 | Coffee Shop |
ID | OpeningTime | ClosingTime |
---|---|---|
1 | 7:30 AM | 4 PM |
2 | 9:00 AM | 6:00 PM |
ID | ServiceFormatID | HourID |
---|---|---|
(→ Service_Formats.ID) | (→ Hours.ID) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 1 | 2 |
4 | 2 | 1 |
ID | FirstName | LastName | PositionInChargeOf | ServiceFormatID |
---|---|---|---|---|
(→ Service_Formats.ID) | ||||
1 | John | Doe | Manager of Buffet | 1 |
2 | Jane | Smith | Manager of Coffee Shop | 2 |
3 | Alice | Brown | Assistant Manager of Buffet | 1 |
4 | Bob | White | Assistant Manager of Coffee Shop | 2 |
5 | Mike | Green | Waiter at Buffet | 1 |
6 | Anna | Black | Waiter at Coffee Shop | 2 |