SpecialOccasions

IdNameNumberOfGuestsDateLocationId
(→ Locations.Id)
1Wedding Venue1002023-01-151
2Wedding Venue502023-02-162
3Corporate Event Space2002023-03-171
4Corporate Event Space1502023-04-182
5Party752023-05-193

Locations

IdAddressType
11 High StreetVenue
22 Low StreetVenue
33 Middle RoadVenue
44 East AvenueVenue
55 West BoulevardVenue

Customers

IdFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321
3AliceBrownalice.brown@example.com+1122334455
4BobWhitebob.white@example.com+2233445566
5CharlieBlackcharlie.black@example.com+3344556677

Bookings

IdCustomerIdOccasionDateSpecialOccasionIdTotalCost
(→ Customers.Id)(→ SpecialOccasions.Id)
112023-01-1511500
222023-02-1621200
332023-03-1712500
442023-04-1822000
552023-05-1931800

Staff

IdFirstNameLastNameRoleSalary
1MikeJohnsonChef45000
2AnnaWilliamsWaitress30000
3TomBakerManager50000
4EmilyJonesHostess25000
5DavidMartinBusser20000

Menus

IdMenuNamePrice
1Appetizer Platter15.99
2Main Course - Steak25.99
3Side Dish - Garlic Mashed Potatoes5.99
4Dessert - Chocolate Cake7.99
5Drink - Wine10.99