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.
o 800 seats on two floors (500 on top, 300 on bottom, however without seats capacity is 750)
o Stalls D-H = £50
o Stalls K-X = £30
o Circle stage left or right = £50
o Circle A-E = £40
o Circle F-J = £30
o 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.