Desired characteristics of a database include it being efficient in terms of storage and easy to maintain.
The first point, of storage, means redundant data should be avoided and the second point, of maintenance, means that a good design will logically separate data into tables.
Normalisation is a design method that can be used to achieve this.
Normalisation is a technique for designing relational database tables to minimize duplication of information and, in so doing, to safeguard the database against certain types of logical or structural problems.
Normalisation provides rules that help:
- Organise the data efficiently.
- Eliminate redundant data.
- Ensure that only related data are stored in a table.
This section will describe this process and the terms you need to understand.
Challenge see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: What is normalisation