Relational Database Design and Modeling for Software Engineers
Ask Author
Back to course home

0% completed

Vote For New Content
Third Normal Form (3NF)
On this page

The Third Normal Form (3NF) is a further step in the normalization process that eliminates transitive dependencies in a table. 3NF ensures that non-key attributes are directly dependent on the primary key and not indirectly dependent through another non-key attribute. By achieving 3NF, we reduce redundancy even further, making the database more efficient and consistent.

Note: For a table to be in 3NF, it must first be in 2NF.

Requirements of 3NF

To satisfy the requirements of 3NF:

  1. The table must already be in 2NF. 2

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page