e. explain why the ship number field is in the crew member file.

f. explain why ship number 012 appears three times in the crew member file.

g. how, many files must be accessed to find: the year that ship number 012 was built? the home country of sailor number 27941? the name of the ship on which sailor number 18535 is employed?

(a) Ship table Shi Year Built Number Name 005 009 012 020 Sea Joy Ocean IV Prince A Queen Shirley 1999 2003 2004 1999 Weight Tons) 80,000 75,000 90,000 80,000 (b) Crew Member toble Sailor Shi Sailo Wumber Name Number County 00536 John Smith 00732 Ling Chang 012 China Engineer 06988Maria Gonzalez 020 Mexico Purser 16490 Prashant Kumar 005 India Navigator 18535 Alan Jones Home Job Title 009 USA Purser 009 UK Cruise Director Captain 020 Philippines Captain 20254 Jane Adams 012 USA 25981 Rene Lopez 27467 Fred Jones Waiter 27941 Alain DuMont 009 France Captain Waiter 020 UK 184 Susan Moore 009 Canada Wine Steward 31775 James Collins 012 USA 32856 Sarah McLachlan 012 Ireland Cabin Steward