Third normal form

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.

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.