Normalisation Flashcards
(6 cards)
1
Q
1nf =
A
A relation
2
Q
2nf =
A
No partial dependencies
3
Q
3nf =
A
No transitive dependencies
4
Q
Bcnf =
A
Boyce codd, no anomalies in functional dependencies. Ie attributes can tell part of primary key
5
Q
4nf =
A
No multi valued dependencies
6
Q
5 steps to 2nf
A
1) find candidate key
2) break candidate key apart and find dependencies
3) draw functional dependency diagram
4) map to relations
5) redraw tables
