Wednesday, October 26, 2005

Database Normalisation

Normalisation is an important part of the analytical and development process. A properly normalised database is easier to maintain and operates more efficiently.

Normalisation is the process of structuring and relating data tables so as to avoid unnecessary repetition of the recording of data and allow it to be retrieved efficiently.

I have often had to modify systems that were never properly normalised or documented and because of this the amount of work required, for modification, is almost equal to that of the original effort. If the clients of those systems had employed someone who knew how to properly structure databases, in the first place, they would have saved themselves a lot of time and money.


posted by Michael Holberton @ 2:10 pm