Look at the Happy Cruise Lines database, for this question, consider only the following SHIP, PORT, and PASSENGER relations. The company wants to keep track of which passengers visited which ports on which ships on which dates. Construct this relationship, add additional relation(s) if needed to store this information. (Hint: the problem describes a ternary relationship among these three relations. An additional relation is needed for representing the ternary relationship. Construct that new relation (give it a name) with its necessary attributes/Primary/foreign keys). Ship Number Ship Name Ship Builder Launch Date Gross Weight

SHIP Relation

Port Name Country Number of Docks Port Manager

PORT Relation

Passenger Number Passenger Name Social Security Number Home Address Telephone Number

PASSENGER Relation