Assignment 4: the new plays repertory theater would like to
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.