Normalisation

Question 1

What is Normalisation?

Answer 1

Normalisation is the formal process involved in the design of an efficient database; this is a multi-staged process where tables are created to cause a reduction in data dependency and data redundancy.

Question 2

What is first normal form?

Answer 2

First normal form is where tables contain no repeating attributes or groups of attributes.

Question 3

What is second normal form?

Answer 3

Second normal form is where tables contain no partial key dependencies.

Question 4

What is third normal form?

Answer 4

Third normal form is where tables contain no non-key dependencies.