The New Plays Repertory

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:
 

A listing of available seats
A listing of all plays and the actors in the plays
A listing of customers
Labels printed for all customers
A listing of season ticket holders
Plan an RDBMS for this problem. Include the following forms:
 

1. List of Reports
 

2. Report Layout Form
 

3. Schema
 

4. Table Characteristics
 

5. Query Design Form