Moving From an Entity-Relationship Analysis to Normalization
The goal of an E-R analysis is to generate a reasonable set of entities and to map the relationships among them.
The next step in the process of achieving a logical data model for your database is to translate those entities into a set of fully normalized tables. The principal task of this translation is to cluster attributes with entities, or relations, in such a way that they uniquely describe the primary keys of those relations. Attributes that do not describe the primary key of a relation must be migrated to a relation whose primary key they do describe uniquely.
The topics of normal forms and the normalization process are described in Chapter 5: “The Normalization Process.”