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