Database normalisation techniques Flashcards
1
Q
What is normalisation?
A
Structuring a database in a way designed to reduce data redundancy and improve integrity
2
Q
What are the advantages of database normalisation?
A
Reduce repetition
Reduce redundancy
Reduce inconsistency
3
Q
What is does atomic mean?
A
Cannot be split down into further parts
4
Q
What is does it mean if a database is in the
third normal form?
A
An atomic database with no partial key dependencies and no non key dependencies
