Service_Formats

IDName
1Buffet
2Coffee Shop

Hours

IDOpeningTimeClosingTime
17:30 AM4 PM
29:00 AM6:00 PM

Services

IDServiceFormatIDHourID
(→ Service_Formats.ID)(→ Hours.ID)
111
222
312
421

Employees

IDFirstNameLastNamePositionInChargeOfServiceFormatID
(→ Service_Formats.ID)
1JohnDoeManager of Buffet1
2JaneSmithManager of Coffee Shop2
3AliceBrownAssistant Manager of Buffet1
4BobWhiteAssistant Manager of Coffee Shop2
5MikeGreenWaiter at Buffet1
6AnnaBlackWaiter at Coffee Shop2