| 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 |