Third Normal Form (3NF)

Third normal form (3NF) requires a table to already be in 2NF and to have no transitive dependency, so no non-key column depends on another non-key column. Every non-key column must depend directly on the primary key; a violation is usually fixed by moving the indirectly dependent columns into their own table.

4 min read

Third Normal Form (3NF) builds on Second Normal Form and adds a further requirement: no non-key attribute should depend on another non-key attribute. Every non-key column must depend directly, and only, on the primary key, not transitively through some other column.

The rule, precisely

A table is in 3NF if it's already in 2NF, and it has no transitive functional dependency: there's no non-key column B such that the key determines B, and B (itself not a key) determines some other non-key column C.

A worked example, violation and fix

Consider an employees table:

employee_idemployee_namedepartment_iddepartment_name
1Meera10Engineering
2Karan10Engineering
3Divya20Sales

This table is in 2NF (its key, employee_id, is a single column, so there's no possible partial dependency). But it's not in 3NF. Here's why: employee_id -> department_id, and separately, department_id -> department_name. That means employee_id determines department_name only transitively, through department_id as the middle step, not directly. department_name isn't really a fact about an employee at all, it's a fact about a department.

This causes the same kind of redundancy problem 2NF fixes, just through a different mechanism: "Engineering" is stored twice, once per employee in that department, and if the department is ever renamed, every row for every employee in it needs updating.

Fix: split off the transitively-dependent part.

employees

employee_idemployee_namedepartment_id
1Meera10
2Karan10
3Divya20

departments

department_iddepartment_name
10Engineering
20Sales

Now department_name lives in exactly one place, departments, where it depends directly on department_id. employees only holds facts that are directly, non-transitively true about an employee: their name and which department they belong to. Renaming a department now means updating exactly one row.

Distinguishing 2NF from 3NF

2NF is about a value depending on only part of a composite key (irrelevant if the key is a single column). 3NF is about a value depending on another non-key column instead of the key directly, which can happen even with a single-column primary key, exactly as in the employees example above, where employee_id is a single-column key but department_name still transitively depends on it through department_id.

Where this matters in real systems

3NF is the practical target most production relational schemas aim for. It eliminates the overwhelming majority of real redundancy and anomaly problems while keeping the schema reasonably simple (not fragmented into an excessive number of tiny tables the way pushing to BCNF or beyond sometimes requires). Recognizing a transitive dependency, "this column is really describing something else, not the row's own key", is one of the most valuable instincts a backend engineer or DBA develops with experience.

What interviewers actually ask about 3NF

  • "What does Third Normal Form require, beyond 2NF?" No transitive dependency: every non-key column must depend directly on the key, not through another non-key column.
  • "Identify the transitive dependency in this table." A very common practical question, given a table like the employees example, spotting that a column depends on another non-key column rather than the key directly.
  • "What's the difference between 2NF and 3NF?" 2NF concerns dependency on part of a composite key; 3NF concerns dependency through another non-key column, which can happen even with a single-column key.
  • "Why is 3NF often considered the practical target for real schemas?" It eliminates most real-world redundancy and anomaly problems without fragmenting the schema as aggressively as BCNF sometimes requires.

Key takeaways

  • 3NF requires 2NF plus no transitive dependency: non-key columns must depend directly on the key, never through another non-key column.
  • A transitive dependency means a column is really describing some other entity (like a department), not the row's own primary subject (like an employee).
  • The fix is splitting the transitively-dependent column into its own table, keyed on the column it actually depends on.
  • 3NF is the common practical normalization target for most real-world production schemas.
All 174 DBMS interview questions

Log in to save which topics you've read across every subject.

Frequently asked questions

What does Third Normal Form require, beyond 2NF?

No transitive dependency: every non-key column must depend directly on the key, not through another non-key column.

Identify the transitive dependency in this table.

A very common practical question, given a table like the `employees` example, spotting that a column depends on another non-key column rather than the key directly.

What's the difference between 2NF and 3NF?

2NF concerns dependency on part of a composite key; 3NF concerns dependency through another non-key column, which can happen even with a single-column key.

Why is 3NF often considered the practical target for real schemas?

It eliminates most real-world redundancy and anomaly problems without fragmenting the schema as aggressively as BCNF sometimes requires.