Normalisation Flashcards
1
Q
why do we limit to 3NF
A
becomes to fragmented
causing performance issues
2
Q
what is BCNF
A
boyce codd normal form
3
Q
what does normalisation prevent
A
update anomolies
4
Q
what are the pros of normalisation (3)
A
reduce redundancy
eliminate anomalies
produce controlled redundancy to create links
5
Q
what is redundancy
A
details repeated too much
6
Q
what is UNF
A
lacks atomic attributes e.g. a table within a table
7
Q
what is 1NF
A
atomic attributes
8
Q
how do we get from UNF to 1NF
A
remove repeating attributes into a separate relation that has a compound key from old and new
9
Q
what is 2NF
A
no partial dependency
10
Q
what is 3NF
A
no transitive dependency
