## Weddings

id | Venue | Location | Capacity | PricePerHead
--- | --- | --- | --- | ---
1 | Grand Ballroom | Downtown | 300 | 89.75
2 | Ceremony Hall | Beachside | 250 | 69.5
3 | Rooftop Terrace | Uptown | 150 | 79.25
4 | Garden Oasis | Forest | 100 | 59.75
5 | Banquet Room | City Center | 200 | 75.0

## CorporateEvents

id | Space | Location | Availability | SeatingCapacity
--- | --- | --- | --- | ---
1 | Conference Room | Downtown | 1 | 50
2 | Boardroom | Beachside | 0 | 20
3 | Seminar Hall | Uptown | 1 | 80
4 | Meeting Room | Forest | 1 | 30
5 | Training Room | City Center | 0 | 60

## Guests

id | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | +123456789
2 | Jane | Doe | janedoe@email.com | +098765432
3 | Michael | Johnson | michaeljohnson@email.com | +111222333
4 | Emily | Williams | emilywilliams@email.com | +445566778
5 | David | Martinez | davidmartinez@email.com | +987654321

## EventBookings

BookingId | EventType | Date | StartTime | EndTime | NumberOfGuests | ClientName | ContactEmail | ContactPhoneNumber
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Guests.FirstName) | (→ Guests.Email) | (→ Guests.PhoneNumber)
1 | Wedding | 2023-01-14 | 18:00:00 | 22:00:00 | 150 | John Smith | johnsmith@email.com | +123456789
2 | Corporate Event | 2023-02-05 | 09:00:00 | 17:00:00 | 50 | Jane Doe | janedoe@email.com | +098765432
3 | Wedding | 2023-03-21 | 16:00:00 | 20:00:00 | 200 | Michael Johnson | michaeljohnson@email.com | +111222333
4 | Corporate Event | 2023-04-10 | 10:00:00 | 16:00:00 | 60 | Emily Williams | emilywilliams@email.com | +445566778
5 | Wedding | 2023-05-02 | 18:00:00 | 22:00:00 | 120 | David Martinez | davidmartinez@email.com | +987654321

## MenuOptions

Id | ItemName | Description | Price
--- | --- | --- | ---
1 | Filet Mignon | Tender beef steak with garlic butter | 29.99
2 | Seafood Platter | Assorted seafood including shrimp, scallops, and salmon | 34.99
3 | Chicken Alfredo | Pasta with creamy garlic chicken sauce | 16.99
4 | Quinoa Salad | Fresh quinoa salad with mixed vegetables | 9.99
5 | Lemon Tart | Delicious lemon tart dessert | 6.99

## FoodOrders

OrderId | BookingId | MenuItemId | Quantity | TotalPrice
--- | --- | --- | --- | ---
(→ EventBookings.BookingId) |  | (→ MenuOptions.Id) |  |
1 | 1 | 1 | 4 | 119.96
2 | 1 | 2 | 3 | 104.97
3 | 2 | 3 | 5 | 84.95
4 | 3 | 1 | 6 | 179.94
5 | 4 | 4 | 2 | 13.98