Data integrity, data quality and normalisation to 3NF

What this note covers

1. Three kinds of data integrity
2. Integrity constraints in action
3. Factors influencing the quality of data
4. Normalisation: purpose and rules
5. Worked normalisation: from unnormalised data to a relation
6. Worked normalisation: 1NF, 2NF and 3NF
7. Exam technique for integrity and normalisation

7 sections · 12 key terms & formulas · 6 common mistakes