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 :-
season single ticket holders
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 :-
C. How are they related ?
C.1 A Dancer can appear in zero, one or many Performances.
5th. August 2004