Explains sixth normal form for temporal data

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

Attributes that change independently over time get their own validity periods.

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: Attributes that change independently over time get their own validity periods

How it is assessed: Groups the attributes of a sample history entity by when they change and justifies the split

Related knobits

Builds on

• K-559 Explains join dependency and fifth normal form

Needed for

• K-520 Recognises independently changing histories in one entity
• K-908 Explains time-based modelling schemes

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