Weddings

idVenueLocationCapacityPricePerHead
1Grand BallroomDowntown30089.75
2Ceremony HallBeachside25069.5
3Rooftop TerraceUptown15079.25
4Garden OasisForest10059.75
5Banquet RoomCity Center20075.0

CorporateEvents

idSpaceLocationAvailabilitySeatingCapacity
1Conference RoomDowntown150
2BoardroomBeachside020
3Seminar HallUptown180
4Meeting RoomForest130
5Training RoomCity Center060

Guests

idFirstNameLastNameEmailPhoneNumber
1JohnSmithjohnsmith@email.com+123456789
2JaneDoejanedoe@email.com+098765432
3MichaelJohnsonmichaeljohnson@email.com+111222333
4EmilyWilliamsemilywilliams@email.com+445566778
5DavidMartinezdavidmartinez@email.com+987654321

EventBookings

BookingIdEventTypeDateStartTimeEndTimeNumberOfGuestsClientNameContactEmailContactPhoneNumber
(→ Guests.FirstName)(→ Guests.Email)(→ Guests.PhoneNumber)
1Wedding2023-01-1418:00:0022:00:00150John Smithjohnsmith@email.com+123456789
2Corporate Event2023-02-0509:00:0017:00:0050Jane Doejanedoe@email.com+098765432
3Wedding2023-03-2116:00:0020:00:00200Michael Johnsonmichaeljohnson@email.com+111222333
4Corporate Event2023-04-1010:00:0016:00:0060Emily Williamsemilywilliams@email.com+445566778
5Wedding2023-05-0218:00:0022:00:00120David Martinezdavidmartinez@email.com+987654321

MenuOptions

IdItemNameDescriptionPrice
1Filet MignonTender beef steak with garlic butter29.99
2Seafood PlatterAssorted seafood including shrimp, scallops, and salmon34.99
3Chicken AlfredoPasta with creamy garlic chicken sauce16.99
4Quinoa SaladFresh quinoa salad with mixed vegetables9.99
5Lemon TartDelicious lemon tart dessert6.99

FoodOrders

OrderIdBookingIdMenuItemIdQuantityTotalPrice
(→ EventBookings.BookingId)(→ MenuOptions.Id)
1114119.96
2123104.97
323584.95
4316179.94
544213.98