RDMS

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. Include the following forms:

1.       List of Reports

2.       Report Layout Form

3.       Schema

4.       Table Characteristics

5.       Query Design Form