Normalisation Flashcards
1
Q
Define Normalisation
A
Technique used to reduce data duplication and improve data integrity
2
Q
Define 1NF
A
The Key
- Atomic
- Primary Key
- No repeats
3
Q
Define 2NF
A
No partial dependencies
4
Q
Define 3NF
A
Nothing but the key
No Non Key dependencies