I need to design a database system for a theatre booking system.
The venue has a total of 800 seats on two floors (500 on the top, 300 on bottom. however, the lower seats can be removed, for standing at certain concerts, leaving a total of 750 on the ground and 500 on top)
The prices vary for each of the seats.
• Stalls D-H = £50
• Stalls K-X = £30
• Circle stage left or right = £50
• Circle A-E = £40
• Circle F-J = £30
• Standing tickets = £15
There will be two shows a day, 365 days a year and there will be many different types of shows.
I need to be able to ensure no seats are double booked for a particular event, keep track of unsold seats.
My main problem is the seats and interlinking shows, I think i'm going about it all wrong.
I will be building my database in Access for the time being.
It sounds like you have configurations containing sections containing seats. Do tables for reusable general configurations as well as specific show configurations, then copy the selected configuration to the show when recording it.