## SpecialOccasions

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

## Locations

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

## Customers

Id | FirstName | LastName | Email | 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

## Bookings

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

## Staff

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

## Menus

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