Question

Which normal form removes transitive dependencies?

• A. 1NF
• B. 2NF
• C. 3NF
• D. BCNF

Hint:

A simple way to remember the progression of normal forms: 1NF: Fixes repeating groups. 2NF: Fixes partial dependencies. 3NF: Fixes transitive dependencies.

Answer 1

The Correct Option is C

Normalization is the process of organizing columns and tables in a relational database to minimize data redundancy. The normal forms are a series of guidelines.
First Normal Form (1NF): Ensures that all attributes contain atomic (indivisible) values and each record is unique. Second Normal Form (2NF): A table must be in 1NF and all non-key attributes must be fully functionally dependent on the entire primary key. This removes partial dependencies. Third Normal Form (3NF): A table must be in 2NF and all attributes must be dependent only on the primary key, not on other non-key attributes. This removes transitive dependencies. A transitive dependency exists when a non-key attribute is dependent on another non-key attribute.
Therefore, the Third Normal Form (3NF) is the one that removes transitive dependencies.