Knobit of Data modelling · K-534 · Skill

Resolves a many-to-many relationship into an associative entity

What it means

Turns a many-to-many relationship into an entity of its own so that its facts (roles, dates, shares) have a place.

How it is assessed

The facts of the relationship live on the associative entity, its cardinality is stated both ways, and attributes duplicated elsewhere to stand in for it are removed

Builds on

Explains relationship cardinality and optionalityK-567 · Knowledge
Explains identifying and non-identifying relationshipsK-904 · Knowledge

Needed by

None