Hotel

hotelIDnameaddresscity
1The Ritz123 Main St.New York
2Hilton Garden Inn456 Elm St.Chicago

Room

roomIDhotelIDtypeprice
(→ Hotel.hotelID)
11Luxury Suite300.0
21Standard Room150.0
32Deluxe Room200.0
42Economy Room100.0

Amenity

amenityIDdescription
1Swimming pool with sun loungers
2Fitness center with sauna and steam rooms

Feature

featureIDamenityIDLeisure_FeaturesCity
(→ Amenity.amenityID)
11Swimming PoolMiami
22Swimming PoolLos Angeles
31Hot TubMiami
42Hot TubDallas

Booking

bookingIDcustomerNamecheckInDatecheckOutDateroomID
(→ Room.roomID)
1John Doe2022-09-012022-09-071
2Jane Smith2022-08-152022-08-212