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 |