City

IDName
1Miami
2Los Angeles

Hotel

IDNameAddressPhoneNumberPriceRange
(→ City.ID)
1Palm Beach200 Palm St.+1234567890150.0
2Sunrise Inn300 Sun Rise Ave.+1345678901100.0

Amenities

IDDescription
1Free WiFi
2Gym

HotelAmenities

HotelIDAmenityIDAvailable
(→ Hotel.ID)(→ Amenities.ID)
111
220

SwimmingPool

IDPoolTypeSizeMaintenanceFrequency
(→ Hotel.ID)
1OutdoorMediumDaily
2IndoorSmallWeekly

HotTub

IDCapacityHeatingMethod
(→ Hotel.ID)
15Electric
28Gas