Banquet_Halls

IDHall_NameCapacityPrice_Per_PersonAmenities
1Grand Ballroom20069.99Projector, Sound System
2Ocean View Hall15074.99Sea view, Dance Floor
3Crystal Hall25089.99Chandeliers, Stage
4Royal Hall300119.99Balcony, Private Bar

Conference_Rooms

IDRoom_NameCapacityPrice_Per_DayEquipment
1Boardroom200599.99Whiteboard, Projector, Microphone
2Multipurpose Room150499.99Flat Screen TV, Podium, Sound System
3Executive Suite250699.99Stage, Piano, Artwork
4Meeting Room300899.99Video Conferencing Facilities, Whiteboard, Flat Screen TV

Guests

IDNameEmailPhone_NumberPreferences
1John Doejohn@example.com+1234567890Vegan Meal
2Jane Smithjane@example.com+0987654321Nut Free Option
3Michael Johnsonmichael@example.com+1112223334Gluten Free Option
4Emma Brownemma@example.com+44556677889Kosher Meal
5David Wilsondavid@example.com+2223334455Halal Meal

Bookings

IDBanquet_Hall_IDConference_Room_IDDateNumber_of_Guests
(→ Banquet_Halls.ID)(→ Conference_Rooms.ID)
1112022-01-01 10:00:00150
2222022-01-02 10:00:00200
3332022-01-03 10:00:00250
4442022-01-04 10:00:00300
51None2022-01-05 10:00:00225

Feedback

IDGuest_IDRatingCommentsTimestamp
(→ Guests.ID)
115Great experience! Will come back.2022-01-01 15:00:00
224Good service but food could have been better.2022-01-02 15:00:00
335Excellent venue, would recommend it to anyone.2022-01-03 15:00:00
443Not what I expected. Need improvement.2022-01-04 15:00:00
555Fantastic event, thanks for making this happen.2022-01-05 15:00:00