| ID | Hall_Name | Capacity | Price_Per_Person | Amenities |
|---|---|---|---|---|
| 1 | Grand Ballroom | 200 | 69.99 | Projector, Sound System |
| 2 | Ocean View Hall | 150 | 74.99 | Sea view, Dance Floor |
| 3 | Crystal Hall | 250 | 89.99 | Chandeliers, Stage |
| 4 | Royal Hall | 300 | 119.99 | Balcony, Private Bar |
| ID | Room_Name | Capacity | Price_Per_Day | Equipment |
|---|---|---|---|---|
| 1 | Boardroom | 200 | 599.99 | Whiteboard, Projector, Microphone |
| 2 | Multipurpose Room | 150 | 499.99 | Flat Screen TV, Podium, Sound System |
| 3 | Executive Suite | 250 | 699.99 | Stage, Piano, Artwork |
| 4 | Meeting Room | 300 | 899.99 | Video Conferencing Facilities, Whiteboard, Flat Screen TV |
| ID | Name | Phone_Number | Preferences | |
|---|---|---|---|---|
| 1 | John Doe | john@example.com | +1234567890 | Vegan Meal |
| 2 | Jane Smith | jane@example.com | +0987654321 | Nut Free Option |
| 3 | Michael Johnson | michael@example.com | +1112223334 | Gluten Free Option |
| 4 | Emma Brown | emma@example.com | +44556677889 | Kosher Meal |
| 5 | David Wilson | david@example.com | +2223334455 | Halal Meal |
| ID | Banquet_Hall_ID | Conference_Room_ID | Date | Number_of_Guests |
|---|---|---|---|---|
| (→ Banquet_Halls.ID) | (→ Conference_Rooms.ID) | |||
| 1 | 1 | 1 | 2022-01-01 10:00:00 | 150 |
| 2 | 2 | 2 | 2022-01-02 10:00:00 | 200 |
| 3 | 3 | 3 | 2022-01-03 10:00:00 | 250 |
| 4 | 4 | 4 | 2022-01-04 10:00:00 | 300 |
| 5 | 1 | None | 2022-01-05 10:00:00 | 225 |
| ID | Guest_ID | Rating | Comments | Timestamp |
|---|---|---|---|---|
| (→ Guests.ID) | ||||
| 1 | 1 | 5 | Great experience! Will come back. | 2022-01-01 15:00:00 |
| 2 | 2 | 4 | Good service but food could have been better. | 2022-01-02 15:00:00 |
| 3 | 3 | 5 | Excellent venue, would recommend it to anyone. | 2022-01-03 15:00:00 |
| 4 | 4 | 3 | Not what I expected. Need improvement. | 2022-01-04 15:00:00 |
| 5 | 5 | 5 | Fantastic event, thanks for making this happen. | 2022-01-05 15:00:00 |