| ID | Name |
|---|---|
| 1 | Miami |
| 2 | Los Angeles |
| 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 |
| ID | Description |
|---|---|
| 1 | Free WiFi |
| 2 | Gym |
| HotelID | AmenityID | Available |
|---|---|---|
| (→ Hotel.ID) | (→ Amenities.ID) | |
| 1 | 1 | 1 |
| 2 | 2 | 0 |
| ID | PoolType | Size | MaintenanceFrequency |
|---|---|---|---|
| (→ Hotel.ID) | |||
| 1 | Outdoor | Medium | Daily |
| 2 | Indoor | Small | Weekly |
| ID | Capacity | HeatingMethod |
|---|---|---|
| (→ Hotel.ID) | ||
| 1 | 5 | Electric |
| 2 | 8 | Gas |