Category Archives for "Normalization"

Database Third Normal Form Explained in Simple English

Second Normal Form

This is the fourth in a series of posts teaching normalization.  The third post focused on the second normal form, its definition, and examples to hammer it home. Once a table is in second normal form, we are guaranteed that every column is dependent on the primary key, or as I like to say, the table serves […]

Continue reading

Learn about the First Normal Form and Database Design

First Normal Form

This is the second in a series of posts teaching normalization. The first post introduced database normalization, its importance, and the types of issues it solves. In this article we’ll explore the first normal form. For the examples, we’ll use the Sales Staff Information shown below as a starting point.  As we pointed out in the […]

Continue reading

Database Normalization Explained in Simple English

Database Normalization Explained

Introduction Database normalization is process used to organize a database into tables and columns.  The idea is that a table should be about a specific topic and that only those columns which support that topic are included. For example, a spreadsheet containing information about sales people and customers serves several purposes: Identify sales people in […]

Continue reading