Explains multivalued dependency and fourth normal form

K-558 · Knowledge knobit · Activity: Derive the logical data model · Competence: Data modelling

Independent multi-valued facts of one thing belong in separate entities.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: Independent multi-valued facts of one thing belong in separate entities

How it is assessed: Classifies sample entities as in or not in 4NF and names the independent multivalued dependencies

Related knobits

Builds on

• K-557 Explains Boyce-Codd normal form

Needed for

• K-512 Recognises independent multi-valued facts in one entity
• K-559 Explains join dependency and fifth normal form

All 56 knobits of Derive the logical data model.

Source: Normalisation theory and relational design (Codd, Fagin, Date), as used by the stage 5 reference and review checklist