Home | Previous Page | Next Page   Basics of Database Design and Implementation > Building a Relational Data Model > Normalizing a Data Model >

Third Normal Form

An entity is in the third normal form if it is in the second normal form and all of its attributes are not transitively dependent on the primary key. Transitive dependence means that descriptor key attributes depend not only on the whole primary key, but also on other descriptor key attributes that, in turn, depend on the primary key. In SQL terms, the third normal form means that no column within a table is dependent on a descriptor column that, in turn, depends on the primary key.

To convert to third normal form, remove attributes that depend on other descriptor key attributes.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]