Recognises independently changing histories in one entity
In an entity that keeps history, attributes that change independently share one row and one validity period, so a change to any one repeats all the others and "when did X change?" needs consecutive rows compared.
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 attributes that change independently and share one validity period
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Account Version (Account, valid from, account status, interest rate, servicing branch) Acceptable: One history per group of attributes that change together: Account Status History, Account Interest Rate History, each with its own validity
Also known as: Independent histories in one entity (6NF) (logical model)
Related knobits
Builds on
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 20; DDL 2014