O'Reilly logo

Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition by Michael J. Hernandez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Normal Forms

Before You Begin ...

So, you've identified your tables and populated them with the fields you believe are most appropriate at this time, and you've even gone so far as to identify relationships between some of the tables. Now you're ready to take them through the Normalization process. Or are you?

There are a couple of things you need to check before you start the Normalization process.

  1. Each table must have a primary key.

  2. A table cannot contain repeating groups of data.

Each of your tables must be in this state in order for the Normalization process to be effective. Otherwise, you could run into problems that might easily have been avoided.

Figure 9 shows a non-normalized Orders table. Although it's in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required