Answer the following questions based on the following two tables from Happy Cruise Lines relational database....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Answer the following questions based on the following two tables from Happy Cruise Lines relational database. Sailor Number 00536 00732 06988 16490 18535 20254 23981 27467 27941 28184 31775 32856 Ship Number 005 009 012 020 Ship Name Alan Jones Jane Adams Rene Lopez Fred Jones Sailor Name John Smith Ling Chang Maria Gonzalez Prashant Kumar Sea Joy 1999 Ocean IV 2003 Prince Al 2004 Queen Shirley 1999 (a) SHIP table. Ship Number Alain DuMont Susan Moore James Collins Sarah McLachlan 009 012 020 005 009 012 020 Year Built 020 009 009 012 012 Weight (Tons) Home Country USA China Mexico India UK USA Philippines UK France Canada USA Ireland (b) CREW MEMBER table. 80,000 75,000 90,000 80,000 Job Title Purser Engineer Purser Navigator Cruise Director Captain Captain Waiter Captain Wine Steward Waiter Cabin Steward b. Assume that the records of the Crew Member file are physically stored in the order shown. i. Retrieve all of the records of the file physically sequentially. ii. Retrieve all of the records of the file logically sequentially based on the Sailor Name field. iii. Retrieve all of the records of the file logically sequentially based on the Sailor Number field. iv. Retrieve all of the records of the file logically sequentially based on the Ship Number field. v. Perform a direct retrieval of the records with a Sailor Number field value of 27467. vi. Perform a direct retrieval of the records with a Ship Number field value of 020. vii. Perform a direct retrieval of the records with a Job Title field value of Captain. c. The value 009 appears as a ship number once in the SHIP table and four times in the CREW MEMBER table. Does this constitute data redundancy? Explain. d. Merge the SHIP and CREW MEMBER tables based on the common ship number field (in a manner similar to Figure 3.8 for the General Hardware database.) Is the merged table an improvement over the two separate tables in terms of: i. Data redundancy? Explain. ii. Data integration? Explain. e. Explain why the Ship Number field is in the CREW MEMBER table. f. Explain why ship number 012 appears three times in the CREW MEMBER table. g. How many tables must be accessed to find: i. The year that ship number 012 was built? ii. The home country of sailor number 27941? iii. The name of the ship on which sailor number 18535 is employed? h. Describe the procedure for finding the weight of the ship on which sailor number 00536 is employed. i. What is the mechanism for recording the one-to-many relationship between crew members and ships in the Happy Cruise Lines database, above? Answer the following questions based on the following two tables from Happy Cruise Lines relational database. Sailor Number 00536 00732 06988 16490 18535 20254 23981 27467 27941 28184 31775 32856 Ship Number 005 009 012 020 Ship Name Alan Jones Jane Adams Rene Lopez Fred Jones Sailor Name John Smith Ling Chang Maria Gonzalez Prashant Kumar Sea Joy 1999 Ocean IV 2003 Prince Al 2004 Queen Shirley 1999 (a) SHIP table. Ship Number Alain DuMont Susan Moore James Collins Sarah McLachlan 009 012 020 005 009 012 020 Year Built 020 009 009 012 012 Weight (Tons) Home Country USA China Mexico India UK USA Philippines UK France Canada USA Ireland (b) CREW MEMBER table. 80,000 75,000 90,000 80,000 Job Title Purser Engineer Purser Navigator Cruise Director Captain Captain Waiter Captain Wine Steward Waiter Cabin Steward b. Assume that the records of the Crew Member file are physically stored in the order shown. i. Retrieve all of the records of the file physically sequentially. ii. Retrieve all of the records of the file logically sequentially based on the Sailor Name field. iii. Retrieve all of the records of the file logically sequentially based on the Sailor Number field. iv. Retrieve all of the records of the file logically sequentially based on the Ship Number field. v. Perform a direct retrieval of the records with a Sailor Number field value of 27467. vi. Perform a direct retrieval of the records with a Ship Number field value of 020. vii. Perform a direct retrieval of the records with a Job Title field value of Captain. c. The value 009 appears as a ship number once in the SHIP table and four times in the CREW MEMBER table. Does this constitute data redundancy? Explain. d. Merge the SHIP and CREW MEMBER tables based on the common ship number field (in a manner similar to Figure 3.8 for the General Hardware database.) Is the merged table an improvement over the two separate tables in terms of: i. Data redundancy? Explain. ii. Data integration? Explain. e. Explain why the Ship Number field is in the CREW MEMBER table. f. Explain why ship number 012 appears three times in the CREW MEMBER table. g. How many tables must be accessed to find: i. The year that ship number 012 was built? ii. The home country of sailor number 27941? iii. The name of the ship on which sailor number 18535 is employed? h. Describe the procedure for finding the weight of the ship on which sailor number 00536 is employed. i. What is the mechanism for recording the one-to-many relationship between crew members and ships in the Happy Cruise Lines database, above?
Expert Answer:
Answer rating: 100% (QA)
b i Retrieve all of the records of the file physically sequentially When retrieving records from the Crew Member file physically sequentially the records are retrieved in the order in which they are s... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
Answer the following questions based on the information presented for Cloud 9 in Appendix B of this book and in the current and earlier chapters. You should also consider your answers to the case...
-
Answer the following questions based on the following hypothetical. On Monday, Daniel decided to go to tour the State Capital in Connecticut for extra credit for his Business Law Class. While on the...
-
Assume you desire maximum duration to take advantage of anticipated interest rate declines. Answer the following questions based on information taken from Tables 186 and 187 on page 474. a. Would you...
-
Use the Chain Rule to evaluate the partial derivative at the point specified. /u and /v at (u, v) = (1,1), where f(x, y, z) = x + yz, x = u + v, y = u + v, z , Z = uv
-
During July, Roy Co. produced 10,000 units. Costs incurred by Roy during the month were as follows: Direct materials ........................................................................$10,000...
-
The pressure of sulfur dioxide (SO2) is 2.12 104 Pa. There are 421 moles of this gas in a volume of 50.0 m3. Find the translational rms speed of the sulfur dioxide molecules.
-
If the chief executive insists on a vote on the board, what questions should the board ask before making the decision?
-
The diagram shows a conical section fabricated from pure aluminum. It is of circular cross section having diameter D = ax , where a = 0.5 m . The small end is located at X 1 = 25 mm and the large...
-
Question: Please include or post your reply, your personal experience or comment on this unexpected events :) q. 1. As someone who recently moved to Canada, I was excited to attend a social gathering...
-
A job shop consists of 6 different machines and 4 different jobs are to be processed through these machines. The job interarrival time follows Exp(15) mins. Each job is processed on a series of...
-
Write code to find all numbers between 1 and 10000 (inclusive) that are multiples of 5 or multiples of 7, but not both. Write the code three ways; all answers should be identical: a. Write this code...
-
There is a temperature where the Fahrenheit scale and the Kelvin scale are numerically equal (hint: it is close to 500). Calculate this exact temperature using temperature conversions and the fact...
-
Let's switch gears now and take a look at current market conditions for grain and cattle markets. The latest release of the Grain Stocks report was last Friday, September 29. You can go to the...
-
Write a MATLAB program that reads a 1x8 vector A, sorts its elements in descending order, then prints the vector after sorting. Inputs: Outputs: Algorithm: Start
-
How can value engineering be used to reduce cost and improve the value of a product or service?
-
Gradually raise Social Security's full retirement age to 70. The age at which workers can become eligible for full Social Security benefits depends on when they were born. For people born before...
-
What are some benefits of the unwritten rules in corporate culture? And are they always bad? Thank you. Good answer will receive thumbs up
-
Q:1 Take any product or service offered in Pakistan and apply all determinents of customer Perceived value ?
-
Connie is the recently appointed engagement partner of the audit of Camel Ltd. She has just taken over the audit from Kar-Ming Leo, who rotated off the audit after a seven-year period as the...
-
Securimax Limited (Securimax) has been an audit client of KFP Partners (KFP) for the past 15 years. Securimax is based in Waterloo, Ontario, where it manufactures high-tech armor-plated personnel...
-
Explain the system of reviewing the quality of audits performed by listed company auditors.
-
Which of the following is not a characteristic of oligopoly? a. A few firms control most of the production and sale of a product. b. Firms in the industry make price and output decisions with an eye...
-
How can existing firms deter potential entrants?
-
Over the past 20 years, Dominator, Inc., a large firm in an oligopolistic industry, has changed prices several times. Each time it does so, the other firms in the industry follow suit. Dominator,...
Study smarter with the SolutionInn App