Normalisation

Question 1

Normalizing to 1NF

Answer 1

• 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

Question 2

Normalizing to 2NF

Answer 2

• 1NF
• If the primary key is a
composite of attributes (contains multiple columns), the non-key attributes (columns) must depend
on the whole key.

Question 3

Normalizing to 3NF

Answer 3

• 1NF
• 2NF
• There are no non-key attributes that depend on other non-key attributes