data normalisation NF Flashcards
1
Q
1NF (first normal form)
A
- all data val are atomic (single cell holds single value)
- no repeating columns (thr are multiple sets of (column_name) :. columns are duplicated. taken from 2020 alvl p1 6a, whr thr are repeated rows..)
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
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
4
Q
disadvantages of NOT using 3NF
A
less space available, anomalies in data
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)
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
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)