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
-
Multiple Choice Questions Select the best answer for each of the following questions. Explain the reasons for your selection: a. In an integrated audit, which of the following must the auditors...
-
A series RLC circuit consists of \(R=10 \Omega, L=0.6 \mathrm{H}\), and \(C=10 \mu \mathrm{F}\). Determine the impedance at resonant frequency, \(10 \mathrm{~Hz}\) below resonant frequency, and \(10...
-
An incompressible fluid oscillates harmonically \(\left(V=V_{0} ight.\) \(\sin \omega t\), where \(V\) is the velocity) with a frequency of \(10 \mathrm{rad} / \mathrm{s}\) in a 4-in.-diameter pipe....
-
Your friend, Dean McChesney, requested that you advise him on the effects that certain transactions will have on his business, A-Plus Travel Planners. Time is short, so you cannot journalize the...
-
Cash Cow International paid a regular dividend of $0.75 a share. a. Connect each of he following dates to the correct term: i. May 7-Record Date ii. June 6 Payment Date iii. June 7-Ex Dividend Date...
-
A 12.75-year maturity zero-coupon bond selling at a yield to maturity of 8% (effective annual yield) has convexity of 150.3 and modified duration of 11.81 years. A 30-year maturity 6% coupon bond...
-
Consider the following equation. u =(2i + v5i) f(x, y) = y/x, P(1, 3), (a) Find the gradient of f. Vf(x, y) (b) Evaluate the gradient at the point P. Vf(1, 3) = (c) Find the rate of change of f at P...
-
Which best describes Six Sigma? a. It reduces errors throughout the production process. b. It improves customer satisfaction. c. It identifies potential errors. d. It obtains near perfection through...
-
Which marketing era reflects the marketing philosophy of companies that give away a product to someone in need for every product purchased? a. Production concept era b. Sales concept era c. Societal...
-
Define: Young modulus, elastic limit, proportional limit, yield point, ultimate point, breaking point, modulus of rigidity, bulk modulus, and Poissons ratio.
-
Forecasting is the process that determines the future demand for employees. a) True b) False
-
Not-for-profit companies do not need marketing campaigns. a) True b) False
-
Can there be an agreement between a company and the employers of the workers on the job that the employer of the workers is an independent contractor and therefore, the company is not responsible for...
-
Why is inventory management important for merchandising and manufacturing firms and what are the main tradeoffs for firms in managing their inventory?
-
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.
-
A positively charged particle creates the electric field shown in Figure 30. 20. When the kinks in the electric field lines reach the rod, what is the direction of the current induced in the rod?...
-
Suppose the current shown in Figure 30. 19 discharges the capacitor. What are the directions of \(\vec{E}\), \(\Delta \vec{E}\), and \(\vec{B}\) between the plates of the discharging capacitor? Data...
-
For the oscillating dipole of Figure 30. 14, sketch the electric field pattern at \(t=\frac{5}{4} T\). Data from Figure 30.14 0=1 t = T t=T 1=T O O D
Study smarter with the SolutionInn App