| ID | Name | Lobby | Terrace |
|---|---|---|---|
| 1 | Single | Yes | No |
| 2 | Double | No | Yes |
| 3 | Suite | Yes | Yes |
| ID | TypeID | Size |
|---|---|---|
| (→ RoomTypes.ID) | ||
| 1 | 1 | 500.0 |
| 2 | 1 | 600.0 |
| 3 | 2 | 700.0 |
| 4 | 3 | 800.0 |
| ID | FirstName | LastName | |
|---|---|---|---|
| 1 | John | Doe | john@example.com |
| 2 | Jane | Smith | jane@example.com |
| 3 | Alice | Brown | alice@example.com |
| 4 | Bob | White | bob@example.com |
| ID | RoomID | CheckInDate | CheckOutDate | GuestID |
|---|---|---|---|---|
| (→ Rooms.ID) | (→ Guests.ID) | |||
| 1 | 1 | 2022-01-01 | 2022-01-05 | 1 |
| 2 | 2 | 2022-01-06 | 2022-01-10 | 2 |
| 3 | 3 | 2022-01-11 | 2022-01-15 | 3 |
| 4 | 4 | 2022-01-16 | 2022-01-20 | 4 |