Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started