What is Third Normal Form (3NF)

Third Normal Form (3NF) is a database normalization stage that ensures all the attributes in a table are dependent only on the primary key. A table is in 3NF if:

1. It is in Second Normal Form (2NF).

2. It has no transitive dependencies, meaning no non-key attribute depends on another non-key attribute.

This eliminates redundancy and ensures that the data is stored efficiently, minimizing the potential for anomalies during data operations such as insert, update, and delete.