Question

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

I had been asked this question in examination.

The query is from Normalization topic in section Planning Oracle Applications of Oracle

Answer 1

The correct choice is (d) Transitive Dependencies

To explain I would say: 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.