Normalization Flashcards

1
Q

1NF

A

All columns have atomic values -> there are no repeating groups

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

2 NF

A

1NF + no partial dependency (where a non-key column depends on part of the PK)

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

3 NF

A

2 NF + no transitive dependency (non-key depends on another non-key)

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