## Banquet_Halls

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

## Conference_Rooms

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

## Guests

ID | Name | Email | 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

## Bookings

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

## Feedback

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