1.

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 DependenciesI had been asked this question in examination.The query is from Normalization topic in section Planning Oracle Applications of Oracle

Answer» <html><body><p>The correct choice is (d) Transitive <a href="https://interviewquestions.tuteehub.com/tag/dependencies-948486" style="font-weight:bold;" target="_blank" title="Click to know more about DEPENDENCIES">DEPENDENCIES</a><br/><br/>To explain I would say: Third Normal Form <a href="https://interviewquestions.tuteehub.com/tag/deals-945317" style="font-weight:bold;" target="_blank" title="Click to know more about DEALS">DEALS</a> with something called ‘transitive’ dependencies. This <a href="https://interviewquestions.tuteehub.com/tag/means-1091780" style="font-weight:bold;" target="_blank" title="Click to know more about MEANS">MEANS</a> if we have a primary key A and a non-key domain <a href="https://interviewquestions.tuteehub.com/tag/b-387190" style="font-weight:bold;" target="_blank" title="Click to know more about B">B</a> 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.</p></body></html>


Discussion

No Comment Found

Related InterviewSolutions