There are various cinemas across Winterfell

Information regarding Assignment:

This assignment concerns database conceptual modeling (enhanced ER modeling). It will be marked out of 10 and will contribute 10% towards your final grade. The description of the Problem domain is given below.

Please note that no late submission is permitted. For any medical reason that you cannot submit on time, you can apply for special consideration beforehand.

page1image12552.png ¬page1image12712.png ¬page1image12872.png ¬page1image13032.png ¬page1image13192.png ¬page1image13352.png ¬page1image13512.png ¬

1) Problem Specifications

The City of Winterfell (in Kingdom of North) ruled by Ned Stark is in trouble. Cersei Lannister, the evil queen of Seven Kindoms cast a spell (I know this is not Harry Potter-Just go with the flow) that erased all the information that was stored in the servers across Winterfell. After casting a protective spell on Winterfell, Ned Stark has decided to reconstruct the databases and he hires a team of database designers and developers and – Guess what? You’re hired.

You are involved with a project that involves designing and constructing a database for all the cinemas in Winterfell. Although all the data was lost, Ned Stark’s son (Rob Stark) who owns a cinema himself manages to provide you a set of information regarding the working of Cinemas across Winterfell. This is what is given to you:

WORKING OF CINEMAS

. 1) There are various cinemas across Winterfell. The Cinemas could be contacted using Email and Phone number provided on their website
(Think about Event Cinemas, Hoyts Cinemas, etc and relate to those as you go along).

. 2) These Cinemas have different branches which screen the movies (Think about how Event Cinemas has a cinema at MQ Shopping Centre)

. 3) The Cinema usually provides the following information about Movies: Name, Year Released, Language, Classification (PG/MA etc)

. 4) Every Cinema has specific number of screens and there is a particular seating capacity for every screen

. 5) The screen is usually added to a roster and that’s how a schedule of which screens display what movies are recorded.
BOOKINGS BY CUSTOMERS

. 1) Customers can go online or make a booking in-queue in the cinemas

. 2) Whilst making a booking(online and in-queue), the information about the customer
(Name, Address, Phone Number) are saved for any future reference

. 3) If Customer decides to obtain a membership, other information like email address,
credit card details are also saved

. 4) All cinemas offer memberships- every membership incurs a monthly fee and offers a
discount for every booking

. 5) Customers can book a more than one seat while making a booking.

. 6) If a customer decides to make an in-queue booking, employee id gets recorded in the
booking details.

. 7) Employee details are recorded too by the Cinemas (Name, Address, Contact number,
etc)

After giving the above information, Rob Stark left to fight a battle leaving you with options to make your own assumptions (he is a network-free battlefield). If you are making assumptions, list them down in an Appendix Section.

page2image23888.png ¬page2image24048.png ¬

2) Task Specifications

1) Task one (8 marks)

Construct an Enhanced E-R model for the above case using any drawing tools. Also, justify the use of generalization/specialisation, weak entity types, and attributes on relationships. List each entity and explain why you have designed it that way. Also specify the key and participation constraints for each relationship set. (Around 300 words-you could use a table if you want)

2) Task two (2 marks)

Each Customer can utmost make 3 bookings a day. How would you express this constraint in the EERdiagram? If you cannot express it, explain briefly. (Around 100 words)

3) Instructions on what to Submit

You are required to submit bothan electronic copy as well as a hard copy of your assignment by the due date.

1) Coversheet

Please include a coversheet with the following information in both submissions.

. 1) Student ID, First Name, Last Name

. 2) Tutorial No, Tutorial Time (Eg: Thu 5pm), Name of your tutor (Full Name please) [Check
ilearn page for details about your tutorials]

2) Electronic Submission

You must submit all the work in a single WORD document namedAssignment1.doc.The electronic submission site is on ilearn https://ilearn.mq.edu.au/ under Assignment1 — >Assignment1 Submission.

With the EER diagram, you need to use Snipping tool and take a snap of the EER diagram, paste it in the word document (use Landscape mode if your image doesn’t fit in the page). NO POWERDESIGNER FILES PLEASE.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.