Normal Forms Flashcards
1
Q
1NF
A
Column should contain (single) Atomic Values
Columns should have the same data type
Columns must have unique name
Order where you store your data should not matter
2
Q
2NF
A
No Partial Relationships + 1NF
3
Q
3NF
A
2NF + Transitive Dependency
4
Q
BCNF
A
(Boyce Codd Normal Form)
3NF + A ——-> B then A is a super key