Study resource
Database design and normalisation techniques common mistakes
Study Database design and normalisation techniques with curriculum-aligned Common Mistakes resources, practice links, and exam-focused support.
At a glance
common mistakes
Resource type
Topic
Database design and normalisation techniques
AqaA LevelComputer ScienceFundamentals of databases
Common mistakes
Confusing no duplicate rows with 3NF
Assuming that a relation is in 3NF simply because every row is unique.
Fix itCheck the dependencies between attributes. A 3NF relation must be in second normal form and must not contain a dependency of one non-key attribute on another non-key attribute.
Related topics