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

Question

Quizplus · Accepted Answer

Since the multiplicities are indicating that each accountant can be licensed in multiple states and each state can have multiple licensed accountants, a linking table will be required to implement this association. This table will have foreign keys of both the Accountants and States tables to establish the many-to-many relationship between the two entities. Option A and B will not allow for the multiple relationships between the two classes to be represented in the database. Option D is incorrect as one of the options provided is correct.

Consider an Association Indicating Professional Licensing Status Between an Accountant