Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML)Class diagram.The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors 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 Cash Disbursements as a foreign key in Vendors.
B)Post the primary key of Vendors as a foreign key in Cash Disbursements.
C)Create a linking table.
D)None of these choices are correct.

Question

Quizplus · Accepted Answer

The multiplicities indicate that each instance of Cash Disbursements can be associated with zero or more instances of Vendors, while each instance of Vendors can be associated with only one instance of Cash Disbursements. This suggests that the foreign key should be placed in the Cash Disbursements table, since each record in that table may reference multiple vendors, but each vendor can only be associated with one Cash Disbursement. Therefore, the primary key of Vendors should be posted as a foreign key in the Cash Disbursements table. Option A is incorrect because it suggests the opposite, with the primary key of Cash Disbursements being posted as a foreign key in Vendors. Option C is not necessary in this case since there is a one-to-many relationship between Cash Disbursements and Vendors. Option D is incorrect because one of the given options must be correct.

Consider an Association Between a Cash Disbursements Class and a Vendors