## Room

id | Name | Indoor_Outdoor_Space | Size | Price
--- | --- | --- | --- | ---
1 | Conference Hall | Lobby | 500 | 678.99
2 | Banquet Hall | Lobby | 600 | 830.99
3 | Rooftop Terrace | Terrace | 500 | 1000.99
4 | Garden Patio | Terrace | 400 | 870.99

## Amenities

id | amenityName | available
--- | --- | ---
1 | WiFi | 1
2 | Parking Space | 1
3 | Air Conditioner | 1
4 | Projector | 0

## Booking

bookingID | roomId | customerId | startDate | endDate | totalPrice
--- | --- | --- | --- | --- | ---
| (→ Room.id) | (→ Customer.customerID) |  |  |
1 | 1 | 1 | 2022-01-10 | 2022-01-12 | 2000
2 | 2 | 2 | 2022-01-15 | 2022-01-17 | 3000
3 | 3 | 3 | 2022-01-20 | 2022-01-22 | 4000
4 | 4 | 4 | 2022-01-25 | 2022-01-27 | 5000

## Customer

customerID | firstName | lastName | email | phoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +123456789
2 | Jane | Smith | jane@example.com | +234567890
3 | Michael | Johnson | michael@example.com | +345678901
4 | Emily | Williams | emily@example.com | +45678902