Amenities

amenity_idamenity_name
1Air Conditioning
2WiFi
3Parking
4Pool
5Gym

Rooms

room_idroom_typeguestroom_amenitiessuite_amenities
(→ Amenities.amenity_name)
1DeluxeAir Conditioning, WiFiAir Conditioning
2StandardParkingParking, Pool
3Luxury SuiteGymGym, Air Conditioning
4Executive SuiteAir Conditioning, WiFiPool
5Family RoomWiFi, ParkingWiFi, Gym

Guests

guest_idfirst_namelast_name
1JohnDoe
2JaneSmith
3MichaelJohnson
4EmilyWilliams
5DavidBrown

Reservations

reservation_idcheckin_datecheckout_dateroom_idguest_id
(→ Rooms.room_id)(→ Guests.guest_id)
12023-01-012023-01-0711
22023-01-152023-01-2122
32023-02-012023-02-0733
42023-02-152023-02-2144
52023-03-012023-03-0755