teach-ict.com logo

THE education site for computer science and ICT

Normalisation

A database term. Normalisation is the process of arranging data in such a way that it does not occur more than once within the database.

Sometimes this is not practical because it leads to many tables having to be made, so a compromise is often made.

There are three main levels of normalisation.

1st Normal form. This is the least efficient form, with the most repetition of data. However, it often has the simplest set of tables.

2nd Normal Form. Bit more efficient, but redundant data is still allowed

3rd Normal Form. The most efficient, as there is no repetition of data, however it may lead to many tables having to be made.

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Normalisation

2020-10