Case Background Hiraeth Cruises has been in the cruise business for the last 30 years. They...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case Background Hiraeth Cruises has been in the cruise business for the last 30 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 cruises and volume of data. You have been recently employed a database model to replace the current spreadsheets. You have been provided with the following business rules about Hiraeth Cruises. This is only a section of their business rules. Vessels: Every vessel is uniquely identified using a primary identifier. Other details of a vessel include the name, and the year it was purchased. Every vessel is of a particular model. Every model is identified with a unique identifier. The name of the model and the passenger capacity for the model are recorded. The vessels are serviced in service docks. Every service dock is identified using a primary identifier. The name of the dock is also recorded. A vessel could get serviced in multiple docks. Every time the vessel is serviced, the service date, and multiple comments about the service are stored. There are three types of vessels: small, medium, and large vessels. Cruises: Every cruise is uniquely identified using a primary identifier. Other details of a cruise include the name, and the number of days the cruise goes for. There are two types of cruises: short and long cruises. A vessel gets booked by the cruise for a few months which are also recorded. The short cruises use small vessels, whereas the long cruises use either a medium or a large vessel. The cruises are created along a particular route. Every route is identified using an identifier. The description of the route is also stored. A route will have a source location, a destination location and multiple stopover locations. Each location is identified by a location code. The name of the location is also stored. Tours: Every cruise offers a unique set of tours for their customers. A tour code is used to identify a tour within every cruise. Other details of the tour such as the name, cost, and type are stored. A tour could be made up of other tours (a package). A tour could be a part of multiple packages. A tour will belong to a particular location. A location could have multiple tours. Staffing: Every Hiraeth staff member is provided with a unique staff number. The company also needs to keep track of other details about their staff members like their name, position, and their salary. There are two types of staff that need to be tracked in the system: crew staff and tour staff. For crew staff, their qualifications need to be recorded. For tour staff, their tour preferences need to be recorded. There are three types of tour staff - drivers, our guides, and assistants. The license number is recorded for the driver and the tour certification number is recorded for the tour guide. In certain instances, the drivers will need to be tour guides as well. Tour staff work for a particular location. Scheduling: A schedule gets created when the cruise is ready to handle bookings. The start date and the max capacity that can be booked are recorded. Every schedule has a detailed roster of the staff involved in the cruise including the crew and the tour staff. The start and end time for every staff will be stored in the roster. Task Description Task 1- EER Diagram (60 marks) 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 constraints. You may choose to add attributes on the relationships (if there are any) or create an associative entity, when necessary. Your diagram should also specify the complete (total) and disjoint (mutually exclusive) constraints on the EER. Task 2-Logical Transformation (40 marks) Based on your EER, perform a logical transformation. Please use 8a for your step 8 to keep the process simple. Please note, if there are errors in the EER diagram, this will impact your marks in the transformation. However, the correctness of the process will be taken into account. Case Background Hiraeth Cruises has been in the cruise business for the last 30 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 cruises and volume of data. You have been recently employed a database model to replace the current spreadsheets. You have been provided with the following business rules about Hiraeth Cruises. This is only a section of their business rules. Vessels: Every vessel is uniquely identified using a primary identifier. Other details of a vessel include the name, and the year it was purchased. Every vessel is of a particular model. Every model is identified with a unique identifier. The name of the model and the passenger capacity for the model are recorded. The vessels are serviced in service docks. Every service dock is identified using a primary identifier. The name of the dock is also recorded. A vessel could get serviced in multiple docks. Every time the vessel is serviced, the service date, and multiple comments about the service are stored. There are three types of vessels: small, medium, and large vessels. Cruises: Every cruise is uniquely identified using a primary identifier. Other details of a cruise include the name, and the number of days the cruise goes for. There are two types of cruises: short and long cruises. A vessel gets booked by the cruise for a few months which are also recorded. The short cruises use small vessels, whereas the long cruises use either a medium or a large vessel. The cruises are created along a particular route. Every route is identified using an identifier. The description of the route is also stored. A route will have a source location, a destination location and multiple stopover locations. Each location is identified by a location code. The name of the location is also stored. Tours: Every cruise offers a unique set of tours for their customers. A tour code is used to identify a tour within every cruise. Other details of the tour such as the name, cost, and type are stored. A tour could be made up of other tours (a package). A tour could be a part of multiple packages. A tour will belong to a particular location. A location could have multiple tours. Staffing: Every Hiraeth staff member is provided with a unique staff number. The company also needs to keep track of other details about their staff members like their name, position, and their salary. There are two types of staff that need to be tracked in the system: crew staff and tour staff. For crew staff, their qualifications need to be recorded. For tour staff, their tour preferences need to be recorded. There are three types of tour staff - drivers, our guides, and assistants. The license number is recorded for the driver and the tour certification number is recorded for the tour guide. In certain instances, the drivers will need to be tour guides as well. Tour staff work for a particular location. Scheduling: A schedule gets created when the cruise is ready to handle bookings. The start date and the max capacity that can be booked are recorded. Every schedule has a detailed roster of the staff involved in the cruise including the crew and the tour staff. The start and end time for every staff will be stored in the roster. Task Description Task 1- EER Diagram (60 marks) 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 constraints. You may choose to add attributes on the relationships (if there are any) or create an associative entity, when necessary. Your diagram should also specify the complete (total) and disjoint (mutually exclusive) constraints on the EER. Task 2-Logical Transformation (40 marks) Based on your EER, perform a logical transformation. Please use 8a for your step 8 to keep the process simple. Please note, if there are errors in the EER diagram, this will impact your marks in the transformation. However, the correctness of the process will be taken into account.
Expert Answer:
Related Book For
Introduction To Federal Income Taxation In Canada
ISBN: 9781554965021
33rd Edition
Authors: Robert E. Beam, Stanley N. Laiken, James J. Barnett
Posted Date:
Students also viewed these computer network questions
-
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...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
- You have identified several risks on your project for which purchasing insurance is a possibility. The insurance company your firm uses has quoted reasonable rates, and your analysis shows that...
-
How many grams of water at 20C are necessary to change 800 g of water at 90C to 50C.
-
Since the brace shown must remain in position even when the magnitude of P is very small, a single safety spring is attached at D and E. The spring DE has a constant of 50 lb/in. and an unstretched...
-
Stock splits a. Decrease par value per share b. Increase the number of shares of stock issued c. Both a and b d. None of the above
-
Using the payroll register from 6-2A for Charles' Cleaners, complete the General Journal entry for the employees' pay for the July 12 pay date. Paychecks will be issued in the future.
-
The construction industry has experienced significant expansion, making construction materials and labour more costly than originally estimated. Carla Vista finds it extremely difficult to estimate...
-
Referring to Problem 18, suppose the airline wants to determine how many checkpoints to operate to minimize operating costs and delay costs over a 10-year period. Assume that the cost of delaying a...
-
On January 1, 2019 Wind Inc. acquired some of Rambler Co.'s outstanding common stock and categorizes the investment as an available-for-sale security. Information related to this acquisition and to...
-
Isolation Traders paid an insurance premium of R 1 0 8 2 4 on 1 March 2 0 1 9 for 1 2 months. Upon the inspection of the pre - adjustment trial balance for the year ended 3 1 May 2 0 1 9 , the...
-
Poverty in Paradise The so-called "Paradise papers" revealed the vast scope of some small tropical nations roll in international money laundering and tax evasion. The impact of these tax havens...
-
You need cash of $15,100 to be received in 3 years, discounted at 7% compounded annually. Indicate the inputs to be entered into the financial calculator keys. What is the present value of the amount...
-
An industrial robotic cooker has a paddle which efficiently mixes during the cooking process. In order to maintain a uniform temperature throughout, the mixer creates turbulence, which enhances the...
-
a company knows that it will need to pay $750,000 each year for the next 10 years to clean up toxic pollution at a farmer plant site. Management wants to set aside a lump sum now that will be enough...
-
Based on the Budgetary Planning What is the first step you will take to successfully complete a budget for yourself? What are some of the challenges in creating a budget for a company?
-
What are the two methods used to translate financial statements and how does the functional currency play a role in determining which method is used?
-
For each of the following items, identify the appropriate provision of the Act which deals with the item listed. Be as specific as possible in citing the reference to the Act, i.e., Part, Division,...
-
Mia Gibbons is a vice president of Pump You Up Ltd., a private corporation she started and currently owns with three of her university colleagues. Mia has recently signed a lease for an upscale...
-
Coco Hardy is an apprentice with Sepp, a design house in Toronto. In her spare time, during some evenings and on weekends, she operates a sewing service for clothing manufacturers. She has set aside...
-
Determine the slope at \(A\) and the maximum deflection. \(E I\) is constant. 20 kip.ft 6 ft A 12 ft- B 6 ft 20 kip-ft
-
Determine the slope of the 50 -mm-diameter A-36 steel shaft at the journal bearings at \(A\) and \(B\). The bearings exert only vertical reactions on the shaft. A 500 mm 800 mm 300 N 1200 mm D 300 N...
-
Determine the slope at \(A\) of the simply supported beam. EI is constant. B - d --
Study smarter with the SolutionInn App