Assignment 4: The New Plays Repertory Theater would like to computerize its ticket sales 58986

profileAdvanced Tutor
 (Not rated)
 (Not rated)

The theater seats 500 people, offers seven plays each year, and sells season tickets and single-night tickets. The season tickets are all for performances at the same time during the week. Each play has 20 performances. The theater keeps a customer list of those people who buy tickets in order to send play information for advertising purposes.

The reports they would like to create are:

1. A listing of available seats

2. A listing of all plays and the actors in the plays

3. A listing of customers

4. Labels printed for all customers

5. A listing of season ticket holders

Plan an RDBMS for this problem.

    • 6 years ago