The third article in our series on normalization from Tom Thomson continues with an explanation on what constitutes third normal form.  Read more...

When we apply normalization rules to our database models, we're looking to preserve data integrity. Normalization reduces the duplication of data in a data model and seeks to ensure that data in a table is properly related to other data in that table.  Read more...

In this article Tom Thomson takes a look at what second normal form means, how it is violated, and how you can fix it. This is part of our normalization series.  Read more...

Learn the basics of first normal form and what that means to a database designer from Tom Thomson.  Read more...

A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.  Read more...

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.  Read more...

Techniques for finding values in a denormalized table.  Read more...

Explains how to normalize a table without breaking the application or doing any application code changes.  Read more...