Which normal form addresses transitive dependencies in a relational database?

Correct option is C

Third Normal Form (3NF) is specifically designed to eliminate transitive dependencies in a relational database. A relation is in 3NF if it is in Second Normal Form (2NF) and all non-key attributes are non-transitively dependent on the primary key.
Important Key Points:
1. Transitive Dependency:
· Occurs when a non-key attribute depends on another non-key attribute, which in turn depends on the primary key.
· Example: In a table with columns A (primary key), B, and C, if A→B and B→C, then A→C is a transitive dependency.
2. Third Normal Form (3NF):
· Ensures that all attributes are functionally dependent only on the primary key.
· Removes transitive dependencies to enhance data integrity and reduce redundancy.
Knowledge Booster:
· First Normal Form (1NF): Ensures that the values in each column of a table are atomic (indivisible).
· Second Normal Form (2NF): Ensures that the table is in 1NF and that all non-key attributes are fully functionally dependent on the primary key.
· Boyce-Codd Normal Form (BCNF): A stricter version of 3NF, where every determinant must be a candidate key.
· Fourth Normal Form (4NF): Ensures that a table is in BCNF and that it has no multi-valued dependencies.