Database normalisation techniques

Question 1

What is normalisation?

Answer 1

Structuring a database in a way designed to reduce data redundancy and improve integrity

Question 2

What are the advantages of database normalisation?

Answer 2

Reduce repetition
Reduce redundancy
Reduce inconsistency

Question 3

What is does atomic mean?

Answer 3

Cannot be split down into further parts

Question 4

What is does it mean if a database is in the

third normal form?

Answer 4

An atomic database with no partial key dependencies and no non key dependencies