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

Question

Quizplus · Accepted Answer

The notation "1..1" next to the Customers class in the UML Class diagram indicates that every Sale is associated with exactly one Customer. The notation "0..*" next to the Sale class indicates that a Customer may have zero or more Sales. To implement this association in a database, you would need to add a foreign key column to the Sales table that references the primary key of the Customers table. This foreign key column would ensure that every Sale is associated with a valid Customer, while still allowing for Customers to have zero or more Sales. Therefore, option A (Post the primary key of Customers as a foreign key in Sales) is the best choice.

Consider an Association Between a Customers Class and a Sale