第三范式实力

最新推荐文章于 2025-11-11 08:33:35 发布

转载最新推荐文章于 2025-11-11 08:33:35 发布 · 808 阅读

文章标签：

#database

Database 专栏收录该内容

4 篇文章

订阅专栏

3rd Normal Form Definition

A database is in third normal form if it satisfies the following conditions:

It is in second normal form
There is no transitive functional dependency

By transitive functional dependency, we mean we have the following relationships in the table: A is functionally dependent on B, and B is functionally dependent on C. In this case, C is transitively dependent on A via B.

3rd Normal Form Example

Consider the following example:

Example Not In Third Normal Form

In the table able, [Book ID] determines [Genre ID], and [Genre ID] determines [Genre Type]. Therefore, [Book ID] determines [Genre Type] via [Genre ID] and we have transitive functional dependency, and this structure does not satisfy third normal form.

To bring this table to third normal form, we split the table into two as follows:

3rd Normal Form Example

Now all non-key attributes are fully functional dependent only on the primary key. In [TABLE_BOOK], both [Genre ID] and [Price] are only dependent on [Book ID]. In [TABLE_GENRE], [Genre Type] is only dependent on [Genre ID].