Amenities
| amenity_id | amenity_name |
| 1 | Air Conditioning |
| 2 | WiFi |
| 3 | Parking |
| 4 | Pool |
| 5 | Gym |
Rooms
| room_id | room_type | guestroom_amenities | suite_amenities |
| | | (→ Amenities.amenity_name) |
| 1 | Deluxe | Air Conditioning, WiFi | Air Conditioning |
| 2 | Standard | Parking | Parking, Pool |
| 3 | Luxury Suite | Gym | Gym, Air Conditioning |
| 4 | Executive Suite | Air Conditioning, WiFi | Pool |
| 5 | Family Room | WiFi, Parking | WiFi, Gym |
Guests
| guest_id | first_name | last_name |
| 1 | John | Doe |
| 2 | Jane | Smith |
| 3 | Michael | Johnson |
| 4 | Emily | Williams |
| 5 | David | Brown |
Reservations
| reservation_id | checkin_date | checkout_date | room_id | guest_id |
| | | (→ Rooms.room_id) | (→ Guests.guest_id) |
| 1 | 2023-01-01 | 2023-01-07 | 1 | 1 |
| 2 | 2023-01-15 | 2023-01-21 | 2 | 2 |
| 3 | 2023-02-01 | 2023-02-07 | 3 | 3 |
| 4 | 2023-02-15 | 2023-02-21 | 4 | 4 |
| 5 | 2023-03-01 | 2023-03-07 | 5 | 5 |