Normalisation

By | December 10, 2015

A relational database allows you to ‘normalise’ your data. Normalising data means that you only have to store repeated information in one place.

For example, if you are storing invoice data then each invoice for the same Customer does not need to store the address of the customer, this is held in a Customer table and only a reference to the customer’s record in the Customer table is stored in the Invoice table.

This not only cuts down on the amount of data that needs to be stored, but also means that if the customer changes their address then you only need to change the address once, in the Customer table instead of for every record of theirs in the Invoice table.

Normalisation can also cut down on the number of columns that you would otherwise use in a spreadsheet.

Another use of normalization is to alleviate the need for creating endless columns in a table.

For a really good explanation of this goto¬†Allen Browne’s website

Category: Design Principles

About Kent Gorrell

Over twenty years experience as a Business Analyst and Project Manager, then as a Development Manager Database Architect and finally Developer. I specialise in Custom Business Applications written in MS Access and SQL Server because these are the fastest and most cost effective development tools to create applications to run businesses for both Desktop (Local Network) and Cloud.