0

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)

Seating Prices.

• 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.

Thankyou.