Hey all,

I have to create a database to record bookings of future shows. The database must be able to record customer bookings of seats for shows, allocate customers to unallocated seats and allow for discounts to groups/concessions.

I also must be able to generate reports or queries that:

Calculates how much revenue each show has produced, calculates how much revenue a future production (one instance of a show) has taken so far, states which shows each customer has been to, and spent, calculates the average amount spent by each customer and allow the user to select a start and end date which generates a report that gives the amount of money grossed by each show within the period.


So far i have came up with the following entities-


But im unsure if i should include an entity for Groups/Concessions or if i need both production and show...