Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012

    Theatre Booking System Design

    Hi All,

    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.

    Any help would be greatly appreciated.


  2. #2
    Join Date
    Feb 2012
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts