Information regarding Assignment: This assignment concerns database conceptual modeling (enhanced ER

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.

Looking for a similar assignment? Get help from our qualified experts!

"Our Prices Start at $9.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Order a Similar Paper Order a Different Paper