Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1.Which of the following is the best way to implement that association in your database?
A)Post the primary key of Deliveries as a foreign key in Shipping Companies.
B)Post the primary key of Shipping Companies as a foreign key in Deliveries.
C)Create a linking table.
D)None of these choices are correct.

Question

Quizplus · Accepted Answer

A foreign key of Shipping Companies in Deliveries will ensure that each delivery is associated with a valid Shipping Company, as per the multiplicities specified in the UML diagram. The association does not require multiple deliveries from a single Shipping Company, so the foreign key should not be placed in Shipping Companies. A linking table would be necessary if the association allowed for a many-to-many relationship, but that is not the case here.

Consider an Association Between a Deliveries Class and a Shipping