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 |