Notes on Normalisation
Rules
1NF
- Each cell can only have 1 value
- Each row is unque
2NF
- No col can depend on a col within PK
3NF
- No transitive dependencies
BCNF
- Cannot have more than one candidate key
4NF
- When you have two independent cols, so it does that thing where you have the value of one col come up for each of values for the other col... NOT ALLOWED
5NF
- Cannot compress into smaller tables without data loss