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:
Answer rating: 100% (QA)
Task 1 EERD ground Po e ServiceDocks dockID name offers Tour tourCode name cost type H by O Cruises ... View the full answer
Related Book For
Posted Date:
Students also viewed these computer engineering 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...
-
THE iterative software development method. Just read the case thoroughly and answer the below-mentioned 3 questions. Here are the three questions to be answered: 1. What are the two choices Lalonde...
-
Jack and Jane are married and own a home insured for $150,000 under an unendorsed HO-3 policy. The replacement cost of the home is $250,000. Personal property is insured for $75,000. Jane has jewelry...
-
It was past 4 pm and Purushottam Kshirsagar was still at his shopfloor office. The small but elegant office was a perk he was entitled to after he had been nominated to the board of Horizon...
-
In a 1975 contract, Eureka was given the exclusive right to sell spring water and other products under the Ozarka trade name in 60 Oklahoma counties in exchange for \($9,000\) paid to Arrowhead,...
-
Horizon Cellular manufactures cell phones for exclusive use in its communication network. Management must select a circuit board supplier for a new phone soon to be introduced to the market. The...
-
Find a big-O estimate (in terms of n) for the run-time of the code given below. m+0 for i1 to n forji i to n * n m+i+j (b) i1 while i n j <1 while j i jj+1 i+i+1 Activate Go to Setti
-
The general ledger of Zips Storage at January 1, 2024, includes the following account balances: Accounts Debits Credits Cash $26,300 17,100 Accounts Receivable Prepaid Insurance Land 15,400 165,000...
-
33) Consider the uniform distribution shown below. Find the probability that x is greater than 6. Discuss the relationship between area under a density curve and probability. 0 125
-
(2) - Agt! Predict products and write balanced FUE and NIE equations for the following precipitation reactions. i) silver(I) nitrate with sodium nitrate Ag No3 + Na No3 - Ag No3 + NaNO3 No3 Not, Nos...
-
Agriculture accounted for 3/8 of greenhouse gas emissions in 1980 and 2/11 in 2000. What's the relative change in greenhouse emissions from agriculture between 1980 and 2000? 20.1% 19.3% 51.5% 48.3%...
-
The type of reaction accompanied by release of energy is called O exothermic. O extrothermic. O introthermic. O endothermic
-
Calcium carbonate decomposes at high temperatures to form carbon dioxide and calcium oxide: 2 CaCO3(s) CO2(g) + CaO(s) How many grams of calcium carbonate will I need to form 3.45 liters of carbon...
-
Currently, the primary source of sulfur dioxide emissions into the atmosphere is a . diesel trucks. b . plastic manufacturing. c . coal burning power plants. d . gasoline - powered lawnmowers.
-
Consider the following information and prepare a bank reconciliation, along with any resulting journal entries, for TJ Company, an online retailer that specializes in digital device accessories, at...
-
If your school has a subscription to the FASB Codification, go to aaahq.org/ ascLogin.cfm to log in and prepare responses to the following. (a) What is the stock dividend? (b) What is a stock split?...
-
Let T be the total number of T-shirts (in thousands) a hip-hop group sells at C concerts per year. A group sells a total of 29.4 thousand T-shirts at 98 concerts in a year. Describe the situation...
-
Some ordered pairs of four relations are listed in Table 48. a. Which of the relations could be functions? Explain. b. Which could be linear functions? Explain. Table 48 Which Relations Could Be...
-
4x + 3 9x = 22
-
Cruz Manufacturing Ltds sales slumped badly in 2019. For the first time in its history, it operated at a loss. The companys income statement showed the following results from selling 600 000 units of...
-
The following are emails from various students to Dr. Destiny Sands, who is a professor in the English Department. These students are wondering if Dr. Sands would let them register for her...
-
What are some flawed assumptions about workplace communication? What is the reality for each myth?
Study smarter with the SolutionInn App