I need to build a database for a theatre booking system
Im not sure how many tables I will need to have for the seating etc.
The theatreSeating Numbers are as follows.
• 800 seats on two floors (500 on top, 300 on bottom, however without seats capacity is 750)
• 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
Currently run Two shows per day, morning and afternoon. I need to ensure that there are no double bookings.
Any help would be greatly appreciated.