Back to the Data Model
Requirement is a Database for a Ballet Company.
The Statement of Requirements defined by the User is as follows ...
The Database is required keep track of :-
donations
gifts
pledges
season subscribers
season single ticket holders
seating assignments
a host of other information.
Major questions are :-
how to track season subscribers (typically 2 tickets per subscription) that can attend 3 shows,
where one show has a choice of an afternoon or an evening performance…and
then they have to purchase individual tickets for the annual Nutcrackerperformance.
Subscribers typically want the same seats from year to year, but all bets are off when it
comes to individual ticket purchases.
B. Things of Interest :-
B.1 Dancers
B.2 Performances
C. How are they related ?
C.1 A Dancer can appear in zero, one or many Performances.
Barry Williams
5th. August 2004
Principal Consultant
Database Answers