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

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.