data normalisation NF Flashcards

1
Q

1NF (first normal form)

A
  • all data val are atomic (single cell holds single value)
  • no repeating columns (if there are multiple columns used for the same purpose, eg math score, science score, columns are repeatedly used for scores, not 1NF)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

2NF (second normal form)

A
  • non-key fields must be fully dependent on the (composite) PK (no partial dependency)
  • since (field) do not depend on the complete PK, only on (one PK), it thus violates 2NF
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

3NF (third normal form)

A
  • (column) is transitively dependent on PK thru (other column). since transitive dependence violates 3NF, table is not in 3NF
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

disadvantages of NOT using 3NF

A

less space available, anomalies in data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

advantages of using 3NF

A

takes up less space, changes only need to be made in one place vs multiple places in NOT 3NF (:. less error-prone)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

why not 3NF ? (when table not even in 1NF)

A
  • 3NF req table to be in 2NF which req table to be in 1NF. 1NF req data vals to be atomic. since (column) contains multiple vals, data vals are not atomic. table is not in 3NF
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

tips to read raw data (normalisation, NF)

A
  • identify repeating datas (signals not normalised data, and should be placed in a separate table instead)
  • identify combinations of data that seems unique to every row (these datas are all PKs, can have many PKs)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly