Knobit of Data modelling · K-512 · Skill

Recognises independent multi-valued facts in one entity

What it means

One entity records two or more independent lists about the same thing, so each new item in one list needs a row for every item in the other.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: Branch Capability (Branch, Product, Language), where the products a branch may sell and the languages its staff serve in are unrelated Acceptable: Branch Product Authorisation (Branch, Product) and Branch Service Language (Branch, Language)

Builds on

Explains multivalued dependency and fourth normal formK-558 · Knowledge

Needed by

None