A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
A. Multivalued Dependencies
B. Join Dependency
C. Trivial Functional Dependency
D. Transitive Dependencies
Answer:A
A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
A. Multivalued Dependencies B. Join Dependency C. Trivial Functional Dependency D. Transitive Dependencies
Explanation: Third Normal Form deals with something called ‘transitive’ dependencies. This means if we have a primary key A and a non-key domain B and C where C is more dependent on B than A and B is directly dependent on A, then C can be considered transitively dependent on A.