Staff

IDNamePositionLanguageID
(→ Languages.ID)
1John DoeChef1
2Mike SmithChef3
3Emily JohnsonServer1
4David BrownServer4
5Anna DavisManager2
6Peter MillerBartender5

Rooms

IDRoomNumber
1101
2102
3103
4104
5105

Bookings

IDGuestNameCheckInDateCheckOutDateRoomID
(→ Rooms.ID)
1Alice Cooper2023-06-012023-06-07101
2Bob Marley2023-06-082023-06-14102
3Carol King2023-06-152023-06-21103
4Daniel Ricciardo2023-06-222023-06-29104
5Eva Mendes2023-06-302023-07-07105

StaffRooms

StaffIDRoomIDWorkDays
(→ Staff.ID)(→ Rooms.ID)
5101Monday,Wednesday
6102Tuesday,Thursday

Languages

IDLanguage
1Spanish
2French
3German
4Italian
5Japanese