Normalisation Flashcards
1
Q
Normalizing to 1NF
A
• Each row is unique - it has a primary key • Each column has a unique name • No columns with similar or repeated data (i.e. choice1, choice2 etc.) • Each data item cannot be broken up any further - no commas in the data
2
Q
Normalizing to 2NF
A
• 1NF
• If the primary key is a
composite of attributes (contains multiple columns), the non-key attributes (columns) must depend
on the whole key.
3
Q
Normalizing to 3NF
A
- 1NF
- 2NF
- There are no non-key attributes that depend on other non-key attributes