For this assignment, complete Minicase 1, parts a - f on pages 134 and 135 of your textbook. This exercise corresponds to Chapter 5 . It is important to review the Power Point slides for Chapter 5 before attempting this assignment. When reviewing this material make sure to note the definitions of primary key, candidate key, foreign key, multi-attribute primary key and intersection data (also on textbook p. 116). Your answers should be typed in MS Word or converted to PDF format and submitted using this assignment link. 1. Consider the following relational database for Happy of the ship Pride of Tampa that leaves on Jume on a particular date. For example, the seven-day journey - Both ship number and ship name are unique in the SHIP Relation. - A ship goes on many cruises over time. A cruise is associated with a single ship. - A port is identified by the combination of port name and country. - As indieated by the VISIT Relation, a cruise includes a. Identify the candidate keys of each relation. visits to several ports, and a port is typically included b. Identify the primary key and any altemate keys of each relation. in several cruises. - Both Passenger Number and Social Security Number c. How many foreign keys does cach relation have? d. Identify the foreign keys of each relation. are unique in the PASSENGER Relation. A particular e. Indicate any instances in which a foreign key serves person has a single Passenger Number that is used for as part of the primary key of the relation in which all of the cruises that she takes. it is a foreign key. Why does each of those relations - The VOYAGE Relation indicates that a person can require a multi-attribute primary key? take many cruises and a cruise, of course, has many f. Identify the relations that support many-to-many. passengers. relationships, the primary keys of those relations, and any intersection data. g. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the record for passenger number 473942 . ii. Retrieve the record for the port of Nassau in the Bahamas. iii. List all of the ships built by General Shipbuilding. Inc. iv. List the port name and number of doeks of every port in Mexico. v. List the name and number of every ship. vi. Who was the cruise director on cruise number 38232 ? vii. What was the gross weight of the ship used for cruise number 39482 ? viii. List the home address of every passenger on cruise number 17543. 2. Super Baseball League Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: - The database keeps track of the history of all of the teams that each player has played on and all of the players who have played on each team. - The database keeps track of only the current team that a coach works for. - Team Number. Team Name, and Player Number are each unique attributes across the league. - Coach Name is unique only within a team (and we assume that a team cannot have two coaches of the same name). For this assignment, complete Minicase 1, parts a - f on pages 134 and 135 of your textbook. This exercise corresponds to Chapter 5 . It is important to review the Power Point slides for Chapter 5 before attempting this assignment. When reviewing this material make sure to note the definitions of primary key, candidate key, foreign key, multi-attribute primary key and intersection data (also on textbook p. 116). Your answers should be typed in MS Word or converted to PDF format and submitted using this assignment link. 1. Consider the following relational database for Happy of the ship Pride of Tampa that leaves on Jume on a particular date. For example, the seven-day journey - Both ship number and ship name are unique in the SHIP Relation. - A ship goes on many cruises over time. A cruise is associated with a single ship. - A port is identified by the combination of port name and country. - As indieated by the VISIT Relation, a cruise includes a. Identify the candidate keys of each relation. visits to several ports, and a port is typically included b. Identify the primary key and any altemate keys of each relation. in several cruises. - Both Passenger Number and Social Security Number c. How many foreign keys does cach relation have? d. Identify the foreign keys of each relation. are unique in the PASSENGER Relation. A particular e. Indicate any instances in which a foreign key serves person has a single Passenger Number that is used for as part of the primary key of the relation in which all of the cruises that she takes. it is a foreign key. Why does each of those relations - The VOYAGE Relation indicates that a person can require a multi-attribute primary key? take many cruises and a cruise, of course, has many f. Identify the relations that support many-to-many. passengers. relationships, the primary keys of those relations, and any intersection data. g. Using the informal relational command language described in this chapter, write commands to: i. Retrieve the record for passenger number 473942 . ii. Retrieve the record for the port of Nassau in the Bahamas. iii. List all of the ships built by General Shipbuilding. Inc. iv. List the port name and number of doeks of every port in Mexico. v. List the name and number of every ship. vi. Who was the cruise director on cruise number 38232 ? vii. What was the gross weight of the ship used for cruise number 39482 ? viii. List the home address of every passenger on cruise number 17543. 2. Super Baseball League Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: - The database keeps track of the history of all of the teams that each player has played on and all of the players who have played on each team. - The database keeps track of only the current team that a coach works for. - Team Number. Team Name, and Player Number are each unique attributes across the league. - Coach Name is unique only within a team (and we assume that a team cannot have two coaches of the same name)