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...
-
What is the difference between a job analysis and a job description?
-
The Lynn Company uses a normal job-costing system at its Minneapolis plant. The plant has a machining department and an assembly department. Its job-costing system has two direct-cost categories...
-
A well-known insurance company offers a policy known as the Estate Creator Six Pay. Typically the policy is bought by a parent or grandparent for a child at the childs birth.The details of the policy...
-
You have recently accepted a position with Vitex, Inc., the manufacturer of a popular consumer product. During your first week on the job, the vice president has been favorably impressed with your...
-
10. Bond listings and yield spreads The following bond list is from the business section of a newspaper on January 1, 2016. Notice that each bond shown matures on January 1 in 5, 10, or 30 years....
-
Henrietta is the president and sole shareholder of Clutter Corporation. In 2018, Henrietta transferred ownership of her personal residence to the corporation. As part of the transfer, Clutter...
-
Pronghorn Corporation has a cumulative temporary differencerelated to depreciation of $610,000 at December 31, 2021. Thisdifference will reverse as follows: 2022, $36,000; 2023, $247,000;and 2024,...
-
Garrett Augustus Morgan, Lewis Howard Latimore, and George Washington Carver are partners in a business called NventionsMLC. In 2017, Sterling Archer and Lana Kane were hired to develop and procure...
-
Q1. (5 points) A stock's price-earnings (P/E) ratio is the per-share price of its stock divided by the company's annual profit per share. The P/E ratio for the stock market as a whole is used by some...
-
You have been asked by your company to evaluate the proposed acquisition of new equipment. The equipment's price is $140,000, and It will cost another $30,000 to modify it for special use by the...
-
Ceiling Stars, Inc., manufactures light bulbs. Its purchasing policy requires that the purchasing agents place each quarter's purchasing requirements out for bid. This is because the Purchasing...
-
Why is test anxiety a good thing? What are the three fears that cause anxiety? How do overcome these fears? What are some activities you can do to reduce test anxiety? Should you entirely deal with...
-
The Wrongway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its cars from a dealer and then sold the cars after three years of use. The company's present...
-
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...
-
List the three parts which normally comprise a code of professional conduct, and state the purpose of each.
-
Explain the need for a code of professional ethics for public accountants. In which ways should the public accoun tants' code of ethics be similar to and different from that of other professional...
-
What are the four facets of independence discussed in the chapter? Explain why each is a necessary component of a public accountant's independence.
Study smarter with the SolutionInn App