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 |