Explains second normal form

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

No non-prime attribute depends on part of a candidate key.

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: No non-prime attribute depends on part of a candidate key

How it is assessed: Classifies sample entities with composite keys as in or not in 2NF and names the partial dependency

Related knobits

Builds on

• K-552 Explains candidate key and prime attribute

Needed for

• K-508 Recognises a partial dependency on a composite key

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