Normalization Flashcards
1
Q
1NF
A
All columns have atomic values -> there are no repeating groups
2
Q
2 NF
A
1NF + no partial dependency (where a non-key column depends on part of the PK)
3
Q
3 NF
A
2 NF + no transitive dependency (non-key depends on another non-key)