Remote Island Resort - Case Study - EER Diagram - Logical Transformation - IT/Computer Science Assignment Help

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.

You have been provided with the following business rules about Remote Island Resort. Customers: Every customer needs to be uniquely identified in the system. Other details which the system needs to store about a customer include their name, address and phone number. Villas: Every Villa is provided with a unique identifier. Other details of a villa include the name of the villa, the type of the villa, and its size (in sqm). Some villas could be interconnected. If villas are interconnected, they can be connected to one other villa. Villas are of a particular Villa Type. Every Villa Type is provided with a unique identifier Description and features are stored for each villa type. Villa Reservation: Every reservation has a unique code. A reservation also has other information to be captured such as the date the reservation was made, the customer it is reserved for, the villas included in the reservation (A customer can make a reservation for multiple villas), dates each of the villas are reserved for, names of the guests staying in each of the villas, and its corresponding cost is stored. The total cost is stored with the rest of the reservation data. The total cost would include the cost of villa reservations, the cost of all activities from the activities booking, and the cost of the dining from all the dinner bookings. Payment for the reservation can be made as split payments. A unique ID is generated for every payment made. The reservation the payment is made for, date of the payment and payment amount is stored. Activities: Every activity is provided with a unique identifier. Other details of activity include the name of the activity, description, and its cost. There are two types of activities- Indoor and Outdoor activities. Indoor activities have difficulty level stored. Some activities are made up of sub-activities (Think of something like a day tour- which could include two half-day tours; A halfday tour could be made up of Yoga and Kayaking. This means that some activities could be both indoor and outdoor at the same time). Outdoor activities use different types of equipment. Every equipment is provided with a unique identifier. Other details of the equipment include details like the name of the equipment, the supplier that supplied the equipment, and quantity on hand. Equipment is supplied by a supplier. Every supplier is provided with a unique identifier. Other details of a supplier include the name of the supplier, the name of the contact person, and a contact number. A supplier may supply multiple types of equipment. On arrival at the resort, customers can register to a variety of experiences (activities) that they would be interested to partake. The date of the activity, the number of persons, and any special requirements are also stored.

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 My Uni Paper. 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.