Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer the following questions based on the following two tables from Happy Cruise Lines' relational database Ship Number Name Year Weight ons 80,000 75,000 90,000
Answer the following questions based on the following two tables from Happy Cruise Lines' relational database Ship Number Name Year Weight ons 80,000 75,000 90,000 80,000 005 009 1999 Ocean IV Prince AI 2004 1999 ueen Shirle (a) SHIP table Sailor Number Name Ship Numbe Coun Sailor Home 00536 John Smith 00732 Ling Chan 06988 Maria Gonzalez 16490 Prashant Kumar 18535 Alan Jones 20254 Jane Adams 23981Rene Lopez 27467 Fred Jones 27941Alain 28184 Susan Moore 31775James Collins 32856 Sarah 009 012 020 005 009 012 020 020 009 009 012 012 USA China Mexico India Purser Engineer Purser Navigator Cruise Director USA Philippines Captain Waiter France Wine Steward USA Ireland Cabin Steward McLachlarn (b) CREW MEMBER table 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. 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. c. 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 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? g. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started