## City

ID | Name
--- | ---
1 | Miami
2 | Los Angeles

## Hotel

ID | Name | Address | PhoneNumber | PriceRange
--- | --- | --- | --- | ---
(→ City.ID) |  |  |  |
1 | Palm Beach | 200 Palm St. | +1234567890 | 150.0
2 | Sunrise Inn | 300 Sun Rise Ave. | +1345678901 | 100.0

## Amenities

ID | Description
--- | ---
1 | Free WiFi
2 | Gym

## HotelAmenities

HotelID | AmenityID | Available
--- | --- | ---
(→ Hotel.ID) | (→ Amenities.ID) |
1 | 1 | 1
2 | 2 | 0

## SwimmingPool

ID | PoolType | Size | MaintenanceFrequency
--- | --- | --- | ---
(→ Hotel.ID) |  |  |
1 | Outdoor | Medium | Daily
2 | Indoor | Small | Weekly

## HotTub

ID | Capacity | HeatingMethod
--- | --- | ---
(→ Hotel.ID) |  |
1 | 5 | Electric
2 | 8 | Gas