| Summary: |
In this week, we will cover the following topics:
Anomalies that can occur when modifying a database.
The process of data optimisation (a.k.a data normalisation).
Basic data normalisation steps. hat 0NF, 1NF, 2NF, 3NF.
An example of data normalisation, from first to third normal form.
… and will result in the following learning outcomes:
An understanding of some different kinds of anomalies, and therefore why structuring data in a specific way to help avoid these anomalies is important.
An understanding of normalisation as a sequential process.
A practical knowledge of what to do when normalising a relational database. |
Loading previews...
