| hotelID | name | address | city |
|---|---|---|---|
| 1 | The Ritz | 123 Main St. | New York |
| 2 | Hilton Garden Inn | 456 Elm St. | Chicago |
| roomID | hotelID | type | price |
|---|---|---|---|
| (→ Hotel.hotelID) | |||
| 1 | 1 | Luxury Suite | 300.0 |
| 2 | 1 | Standard Room | 150.0 |
| 3 | 2 | Deluxe Room | 200.0 |
| 4 | 2 | Economy Room | 100.0 |
| amenityID | description |
|---|---|
| 1 | Swimming pool with sun loungers |
| 2 | Fitness center with sauna and steam rooms |
| featureID | amenityID | Leisure_Features | City |
|---|---|---|---|
| (→ Amenity.amenityID) | |||
| 1 | 1 | Swimming Pool | Miami |
| 2 | 2 | Swimming Pool | Los Angeles |
| 3 | 1 | Hot Tub | Miami |
| 4 | 2 | Hot Tub | Dallas |
| bookingID | customerName | checkInDate | checkOutDate | roomID |
|---|---|---|---|---|
| (→ Room.roomID) | ||||
| 1 | John Doe | 2022-09-01 | 2022-09-07 | 1 |
| 2 | Jane Smith | 2022-08-15 | 2022-08-21 | 2 |