Which cardinalities are possible in a Clarity data model relationship, and how are they typically implemented?

• A. One-to-one, one-to-many, and many-to-many; 1:M uses foreign keys, M:N uses a junction table.
• B. Only one-to-many; implemented with join tables.
• C. All relationships are many-to-many; implemented with junction tables.
• D. Only one-to-one; implemented with foreign keys.

Answer: (A)

In a Clarity data model, you can have one-to-one, one-to-many, or many-to-many relationships. The implementation follows standard relational patterns: a one-to-many relationship uses a foreign key on the many side that references the one side; a one-to-one relationship also uses a foreign key (typically with a uniqueness constraint or a shared primary key) to ensure a single match on the other side; a many-to-many relationship requires a junction (association) table that holds pairs of foreign keys, one from each side, to link the records together.

So the best answer recognizes that all three cardinalities are possible and that 1:M is implemented with foreign keys, while M:N uses a junction table. The other options are incomplete or inaccurate because they restrict to a single cardinality or claim all relationships are many-to-many.