Staff
ID | Name | Position | LanguageID |
| | | (→ Languages.ID) |
1 | John Doe | Chef | 1 |
2 | Mike Smith | Chef | 3 |
3 | Emily Johnson | Server | 1 |
4 | David Brown | Server | 4 |
5 | Anna Davis | Manager | 2 |
6 | Peter Miller | Bartender | 5 |
Rooms
ID | RoomNumber |
1 | 101 |
2 | 102 |
3 | 103 |
4 | 104 |
5 | 105 |
Bookings
ID | GuestName | CheckInDate | CheckOutDate | RoomID |
| | | | (→ Rooms.ID) |
1 | Alice Cooper | 2023-06-01 | 2023-06-07 | 101 |
2 | Bob Marley | 2023-06-08 | 2023-06-14 | 102 |
3 | Carol King | 2023-06-15 | 2023-06-21 | 103 |
4 | Daniel Ricciardo | 2023-06-22 | 2023-06-29 | 104 |
5 | Eva Mendes | 2023-06-30 | 2023-07-07 | 105 |
StaffRooms
StaffID | RoomID | WorkDays |
(→ Staff.ID) | (→ Rooms.ID) | |
5 | 101 | Monday,Wednesday |
6 | 102 | Tuesday,Thursday |
Languages
ID | Language |
1 | Spanish |
2 | French |
3 | German |
4 | Italian |
5 | Japanese |