Patron Problem – Guaranteed Perfect Score.

Lab Price = $16
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.
Problem Statement

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, a daytime phone number, and an 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 production and it is hoped that they will attend future productions as
well.
1. Use the UML notation discussed in chapter 11 to draw an ER diagram
for this case problem.
IS515 07A

Relevant Material
Screenshots

screenshot_ERD

Instructions
* Please click on “Buy Now” button to complete the purchase.Please note that the payment is done through PayPal.
* If you have any issues with the payment method, please let us know at support@iqrajavaid.com and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.

******************************************** Good Luck ***************************************************

Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Payment Details
Lab Price = $16
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.

Leave a Reply