Activity Content

Instructions

$($Chapter $5,$ Minicase $1)$ Happy Cruise Lines

Look at the Happy Cruise Lines database of Chapter $5,$ Minicase $1,$ but 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. Reconstruct 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 such as VISIT relation, with its necessary attributes$/$Primary$/$foreign keys$).(10$ pts$)$

SHIP Relation

PORT Relation

PASSENGER Relation

VISIT Relation

less

Evaluation Criteria

Out of: $10$ points

Submission Details

Submission type

File submission

Files allowed per

Unlimited

submission

Allowed files

No Restrictions

Number of submissions

All submissions are kept