## 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