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

Question

Quizplus · Accepted Answer

The multiplicity 1..1 next to Cities and 1..* next to Neighborhoods indicates that each city can have one or more neighborhoods, but each neighborhood is associated with exactly one city. The best way to represent this relationship in a database is to post the primary key of the Cities table as a foreign key in the Neighborhoods table, allowing many neighborhoods to be linked to one city.

Consider an Association Between a Cities Class and a Neighborhoods