Subject: Theater Bookings
Note that Entities are shown in Bold.

1. Read Question:
Subject: Theater Bookings
Question: The ABC Theatre is a family theatre situated in a small town.
The theatre stages plays, dance, and musical productions.
It is also used for presentations associated with various local youth cricket, football, and rugby teams.

The theatre treats presentations as a type of production.
The theatre has made a healthy profit over the last five years and is now in a
position to finance the development of a computerised booking system.

The proposed booking system will manage seat bookings including the printing of
tickets and production schedules as required.

The proposed booking system should be operational by the end of September 2013.
Information Required :-
Each production (see Figure 1 in the Appendix) may have one or more performances.
A production is classified by one of the following types �
Dance, Music, Play, and Presentation.

Seating in the theatre (see Figure 2 in the Appendix) is arranged into three groups
of seats as follows:
Front block Rows A � J Seats 1 � 40
Middle block Rows A � L Seats 1 � 50
Back block Rows A � N Seats 1 � 60

The price classifications for seats in the theatre are:
Back block Rows H � N b Back block Rows A � G c
Middle block Rows A � L d
Front block Rows A � J

For any particular production the price of a seat is the same for all performances.
A customer can book tickets (see Figure 3 in the Appendix) either by telephone, in
person or by post.

If a customer books tickets in person, they will obviously collect their tickets at
the time of booking.

Customers who book by phone or post can either have the tickets sent to them or can
collect them from the booking office.
Before each performance, the theatre staff will need to print the tickets for those
customers who opted to collect their tickets at the performance.

After each production, the theatre manager will need a summary of ticket sales detailing
the income from ticket sales, the value of concessions and the number of unsold seats.

Regular customers can benefit by applying for membership of the theatre (see Figure 4 in
the Appendix).

Appendix Saturday October 5th to Saturday October 12th 2013 (Dance)
7:30pm Swan Lake Tchaikovsky�s well known ballet performed by the touring section of the
English National Ballet
Tickets � a: �30.00, b: �35.00, c: �40.00, d: �60.00

************************************************************************
Thursday November 7th 2013(Presentation) 5:00pm Fleet Under 12 Football Team Presentations
7:00pm Fleet Under 14 Football Team Presentation 9:00pm Fleet Under 16 Football Team Presentations
Tickets � a: �25.00, b: �30.00, c: �35.00, d: �405.00

************************************************************************
Wednesday December 4th to Thursday December 5th 2013 (Music) 8:00pm (Wednesday) 9:00pm (Thursday)
The Human League Tickets � a: �70.00, b: �90.00, c: �110.00, d: �130.00
************************************************************************
Monday December 16th 2013 (Play) 5:00pm
The Woman in Black A terrifying live theatre experience
Tickets � a: �35.00, b: �40.00, c: �50.00, d: �60.00
Figure 1 Sample Production Schedule
Figure 2

Theatre Seating Plan Tickets for performances described in the production schedule may be reserved:
By telephone we accept all major credit cards.
In person At the Box Office By post
Please provide � Your name � Your address � Your daytime telephone number
� The production(s) and the date and time of the performance(s)
� The number of tickets
� The price of the tickets
� Reason for concession (if applicable)
� Payment (cheque made payable to JJLP Theatre, or credit card number and expiry date)
Concessions Senior citizens and students: a discount of �5 off the price Members:
a discount of �15 off the price Figure 3 Booking Details The Players: Application for Membership

You do not have to be a member to enjoy performances at the Theatre, but benefits include
discounted tickets and priority bookings.

The subscription fee for the 2013 season is �60.00.
Name: Address: Postcode: Daytime Telephone No: Mobile Phone No: Email Address: Figure 4 Membership Application Form



 © DataBase Answers Ltd. 2013