## Hotel

hotelID | name | address | city
--- | --- | --- | ---
1 | The Ritz | 123 Main St. | New York
2 | Hilton Garden Inn | 456 Elm St. | Chicago

## Room

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

## Amenity

amenityID | description
--- | ---
1 | Swimming pool with sun loungers
2 | Fitness center with sauna and steam rooms

## Feature

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

## Booking

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