| 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 |
| 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 |
| id | FirstName | LastName | 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 |
| 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 |
| 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 |
| 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 |