Which type of dependency is eliminated when a relation is converted from 2NF to 3NF?
Options
-
A.
Partial dependency
-
B.
Transitive dependency
-
C.
Multivalued dependency
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
Transitive dependency
Detailed Explanation
- 3NF: Eliminates transitive dependencies of non-prime attributes on candidate keys.
- A transitive dependency occurs when a non-key attribute depends on another non-key attribute.
- 3NF also requires the relation to satisfy 2NF.
OOps! You are currently offline.