Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. at any given point in time, a sailor may sail on o

At any given point in time, a sailor may sail on one ship, but a...

90.2K

Verified Solution

Question

Accounting

image

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students