~/ learn/ comp-378/ cards/ Associative entities (resolving M:N)
1 of 4

Type the four conditions to convert a relationship to an associative entity.

Type the four conditions to convert a relationship to an associative entity.

Answer

all relationships many + independent meaning (single-attr id) + attributes beyond the id + participates in other relationships

All four signal that a many-to-many relationship carrying its own data should be promoted to an entity. Condition 3 (an attribute on the relationship) is the most common trigger in practice.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/f60c9a7a-44f6-425b-954d-bd2a4d92737f/flashcard utf-8 LF