How to Find Non Trivial Functional Dependencies
Ive probably watched most of the material available but still fail to understand what a non trivial FD is. If there is a dependency in a database such that attribute B is dependent upon attribute A you would write this as. Trivial And Non Trivial Dependency Lecture96 Dbms Youtube We can define Non-trivial functional dependency in two ways. . To distinguish trivial and non-trivial functional dependencies first check if the dependent is subset of determinant or not if dependent is subsetnot necessary a proper subset then it is trivial dependency otherwise the functional dependency is non-trivialsuccessively you can count the number of functional dependencies whether trivial or non-trivialFor example- A functional. Find number of candidate keys given non-trivial functional dependency X-Y where X is some set of attributes and Y is some prime attribute 0 Figuring out the equivalence between two definitions of transitive functional dependencies ...