Normalisation

Question 1

How do you get something to 1NF?

Answer 1

• Eliminate duplicate columns
• Create separate tables for each group of related data
• Identify the Primary Key
• Remove duplicate values in a single field

Question 2

How do you get something to 2NF?

Answer 2

• Check data is already in 1NF
• Remove data sets that occur in multiple rows and transfer to new tables
• Create relationships between tables

Question 3

How do you get something to 3NF?

Answer 3

• Check data is in 2NF

- Remove any columns not dependant on the primary key