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 |