## Service_Formats

ID | Name
--- | ---
1 | Buffet
2 | Coffee Shop

## Hours

ID | OpeningTime | ClosingTime
--- | --- | ---
1 | 7:30 AM | 4 PM
2 | 9:00 AM | 6:00 PM

## Services

ID | ServiceFormatID | HourID
--- | --- | ---
| (→ Service_Formats.ID) | (→ Hours.ID)
1 | 1 | 1
2 | 2 | 2
3 | 1 | 2
4 | 2 | 1

## Employees

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