Recognises independent multi-valued facts in one entity
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.
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: The two independent lists and the entity that combines them
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)
Also known as: Independent multi-valued facts in one entity (4NF) (logical model)
Related knobits
Builds on
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 12; Fagin 1977; Kent 1983; S&W 13.4