Normalization is a key aspect of relational modeling, and an important one for you to get a grasp of before we go into the details of building a model. The simplest way to think of normalization is that normalization is the process of organizing data to reduce redundancy. While normalization can become complex, the rules for normalizing data elements can be boiled down to a single sentence:

Make sure every data element is single-valued and provides a fact completely and only about its primary key.

The underlined terms require more of an explanation.Single-valued means a data element must contain only one piece of information. If Consumer Name contains Consumer First Name and Consumer Last Name, for example, we must split

Get Data Modeling Made Simple with CA ERwin Data Modeler r8 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.