Question: At any given point in time, a sailor may sail on one ship, but a ship may have many sailors. A ship must have at

 At any given point in time, a sailor may sail on

At any given point in time, a sailor may sail on one ship, but a ship may have many sailors. A ship must have at least one sailor. From this description, choose the most correct entity-relationship diagram below. (Only maximum cardinalities have been included.) A) Sailor Ship PK SSN PK ShipID ShipName LName FName B) Sailor Ship PK SSN PK LName ShipID ShipName SSN FName FK Sailor C) PK SSN + Sailor-Ship PK/EK SSN PK/EK ShipID PK Ship ShipID ShipName SSN LName FName FK Sailor Ship D) PK SSN PK ShipID ShipName LName FName EK ShipID (A) (B) (C) (D) (A) and (B) are both legitimate ERDs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!