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.