# Trivial and non trivial functional dependency examples

#####
*2020-02-19 11:13*

A, B B is a trivial functional dependency because B is a subset of A, B. Since A, B B includes B, the value of B can be determined. It's a trivial functional dependency because determining B is satisfied by its relationship to A, B. Since the values of B are determined by the values of A, any other sequence that shares the values of A will have the exact same values as B.If a functional dependency XY holds true where Y is not a subset of X then this dependency is called non trivial Functional dependency. For example: An employee table with three attributes: empid, empname, empaddress. The following functional dependencies are nontrivial: empid empname (empname is not a subset of empid) trivial and non trivial functional dependency examples

Non trivial functional dependency in DBMS Functional dependency which also known as a nontrivial dependency occurs when AB holds true where B is not a subset of A. In a relationship, if attribute B is not a subset of attribute A, then it is considered as a nontrivial dependency.

May 13, 2015 Non trivial& Trivial Functional Dependency DBMS Databases Video lecture for gate exam preparation iit Hindi, Trivial functional dependency vs. nontrivial functional dependency Trivial If a Jan 31, 2017 16 Trivial and Non Trivial Functional Dependencies Fully Functional Dependency, Partial FD, Transitive FD and Trivial FD**trivial and non trivial functional dependency examples** May 13, 2015 Non Trivial functional dependency Example DBMS Databases Video lecture for gate exam preparation From the following instance of a relation scheme R (A, B, C), we can conclude that: A B C 1 1 1 1