| Id | Name | NumberOfGuests | Date | LocationId |
|---|---|---|---|---|
| (→ Locations.Id) | ||||
| 1 | Wedding Venue | 100 | 2023-01-15 | 1 |
| 2 | Wedding Venue | 50 | 2023-02-16 | 2 |
| 3 | Corporate Event Space | 200 | 2023-03-17 | 1 |
| 4 | Corporate Event Space | 150 | 2023-04-18 | 2 |
| 5 | Party | 75 | 2023-05-19 | 3 |
| Id | Address | Type |
|---|---|---|
| 1 | 1 High Street | Venue |
| 2 | 2 Low Street | Venue |
| 3 | 3 Middle Road | Venue |
| 4 | 4 East Avenue | Venue |
| 5 | 5 West Boulevard | Venue |
| Id | FirstName | LastName | PhoneNumber | |
|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | +1234567890 |
| 2 | Jane | Smith | jane.smith@example.com | +0987654321 |
| 3 | Alice | Brown | alice.brown@example.com | +1122334455 |
| 4 | Bob | White | bob.white@example.com | +2233445566 |
| 5 | Charlie | Black | charlie.black@example.com | +3344556677 |
| Id | CustomerId | OccasionDate | SpecialOccasionId | TotalCost |
|---|---|---|---|---|
| (→ Customers.Id) | (→ SpecialOccasions.Id) | |||
| 1 | 1 | 2023-01-15 | 1 | 1500 |
| 2 | 2 | 2023-02-16 | 2 | 1200 |
| 3 | 3 | 2023-03-17 | 1 | 2500 |
| 4 | 4 | 2023-04-18 | 2 | 2000 |
| 5 | 5 | 2023-05-19 | 3 | 1800 |
| Id | FirstName | LastName | Role | Salary |
|---|---|---|---|---|
| 1 | Mike | Johnson | Chef | 45000 |
| 2 | Anna | Williams | Waitress | 30000 |
| 3 | Tom | Baker | Manager | 50000 |
| 4 | Emily | Jones | Hostess | 25000 |
| 5 | David | Martin | Busser | 20000 |
| Id | MenuName | Price |
|---|---|---|
| 1 | Appetizer Platter | 15.99 |
| 2 | Main Course - Steak | 25.99 |
| 3 | Side Dish - Garlic Mashed Potatoes | 5.99 |
| 4 | Dessert - Chocolate Cake | 7.99 |
| 5 | Drink - Wine | 10.99 |