Normalisation Flashcards by Theo Crowley

Q

How do you get something to 1NF?

A

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

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

How do you get something to 2NF?

A

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

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

How do you get something to 3NF?

A

Check data is in 2NF

- Remove any columns not dependant on the primary key

How well did you know this?

1

Not at all

2

3

4

5

Perfectly