Get the Best Patron Problem
ENTITY-RELATIONSHIP MODELING CASE PROBLEM
The Musical Theatre Department at a local college has asked you to develop a
database for their box office. Each year, the department has three productions
(Spring, Fall, and Winter) that last two weeks apiece. Each production is given a
unique ID number and has a name, start date, end date, and director. Each
production will have one or more performances. Each performance is identified
by a unique ID number and is scheduled at a given date and time. There may be
more than one performance on a given date. For example, there may be a
matinee on 10/26/02 from 2 p.m. to 4 p.m., followed by an evening performance
from 7 p.m. to 9 p.m. The college’s theatre has 300 seats, each identified by a
seat number (i.e., A1, A2, etc.). Patrons are automatically assigned a unique
patron ID number when they are first entered into the database and their first
name, last name, home address, daytime phone number, and e-mail address
are also stored. A patron attending a performance may reserve more than one
seat for that performance. A patron may also return to see another performance
of the same product and it is hoped that they will attend future productions as
1. Use the UML notation discussed in chapter 11 to draw an ER diagram
for this case problem.
Need Help with Problem?
Are you a struggling student who is not able to cope with the pressure is handling in case of taking online tests due to various other activities? Or are you finding it very complicated to finish the given tests promptly with some good grades? Don’t worry, Examshelpers can help you in this situation! The IWantOnlineclasshelp.com service provider is the best quality of services you can avail of today for the betterment of your future and the perfect arrangement of premium-level of test-taking services on your behalf. We have been consistently providing outstanding help to each & every student who is looking for affordable, reliable, and qualitative services promptly. Whether it is about test issues or exam-related issues, you are facing, we can cover all by pay someone to take my online test services on the go. The Online Test Help query is solved here quickly. Just call us or mail us, and we will be there to bring some professional quality exam-taking services with a money-back guarantee, therefore you will have nothing to drop. Pay to do an online exam now.