[Solved] Which condition must a table satisfy to be in Third Normal Form (3NF)? — Ans: It must be in Second Normal Form and have no transitive dependencies | SQL

SQL - Database Design and Normalization

Which condition must a table satisfy to be in Third Normal Form (3NF)?

AIt must have no repeating groups

BIt must have a primary key

CIt must be in Second Normal Form and have no transitive dependencies

DIt must have only one attribute

Step-by-Step Solution

Solution:

Step 1: Understand 2NF requirement
3NF requires the table to be in 2NF, meaning no partial dependencies on a composite key.
Step 2: Check for transitive dependencies
3NF also requires no transitive dependencies, where non-key attributes depend on other non-key attributes.
Final Answer:
The table must be in Second Normal Form and have no transitive dependencies -> Option C
Quick Check:
3NF = No transitive dependencies [OK]

Quick Trick: 3NF means no transitive dependencies after 2NF [OK]

Common Mistakes:

Master "Database Design and Normalization" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which condition must a table satisfy to be in Third Normal Form (3NF)?