A table is in 3NF when it is in 2NF and it contains no transitive dependencies.

A table is in 3rd Normal Form (3NF) when it meets the following criteria:

  1. It is in 2nd Normal Form (2NF)
  2. There are no transitive dependencies in the table, which means that non-primary key columns are not dependent on other non-primary key columns.

A table in 3NF is considered to be free of transitive dependencies, and all the data in the table is directly tied to the primary key.

Bijay Satyal
Oct 23, 2021
More related questions

Questions Bank

View all Questions

Top