University : Macquarie University UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : COMP1350
Assignment Task:

Case Background

Remote Island Resort, Fiji has been in the hospitality business for the last 80 years. They started storing data in a file-based system and then transitioned into using spreadsheets. As years progressed, their business has grown exponentially leading to an increase in the number of customers and volume of data. You are employed to develop a database model to replace the current spreadsheets.

Task Description

Task 1- EER Diagram

Based on the business rules, you are expected to construct an Enhanced-ER (EER) diagram. The EER diagram should include entities, attributes, and identifiers. You are also expected to show the relationships among entities using cardinality and associative entities (if any). You may choose to add attributes on the relationships (if there are any) or create an associative entity with these attributes. Your diagram should also specify the complete (total) and disjoint (mutuallyexclusive) constraints on the generalization/specialization.

Task 2- Logical Transformation

Based on your EER, for the “Dinner reservations” excerpt from your case study, perform a logical transformation. Any entities mentioned in the excerpt must be used in the transformation. You will have to use Step 8a for conversion. Also, use 8b, 8c and 8d and show the process of transformation for these steps. You do not have to repeat steps 2-7 for these.


This IT Assignment has been solved by our IT Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : admin
  • Posted on : September 09th, 2018
  • Downloads : 0

Whatsapp Tap to ChatGet instant assistance