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 |