Details of this Paper

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

Description

solution


Question

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.

 

Paper#70859 | Written in 18-Jul-2015

Price : $27
SiteLock