15.00 - Moving From an Entity-Relationship Analysis to Normalization - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.”