Third normal form

normalizing a database design to reduce the duplication of data and ensure referential integrity From Wikipedia, the free encyclopedia

Third normal form is a property of a relational model, specifically tables that is a criterion of database normalization.

The first criterion of being third normal form is that the table be second normal form.

Within a table that is in third normal form, the data in each column in each row are dependent only on columns that are part of the primary key. A primary key is one or more columns in a row that is used to identify and index that row of the table. Columns that are not related to any column in the primary key are removed.

Loading related searches...

Wikiwand - on

Seamless Wikipedia browsing. On steroids.