What Is Trivial Functional Dependency?

1.	What Is Trivial Functional Dependency?
Answer» A trivial FUNCTIONAL DEPENDENCY is the situation, which shows a RELATION between an attribute with a superset of itself such that the attribute is dependent on the superset. CONSIDER an attribute of the DRESS entity, say length. If the length attribute is dependent on the dress code attribute of the dress entity, then it is a non-trivial dependency; however, if the length attribute is dependent on the color and length attributes of the dress entity, then it is a trivial dependency. A trivial functional dependency is the situation, which shows a relation between an attribute with a superset of itself such that the attribute is dependent on the superset. Consider an attribute of the dress entity, say length. If the length attribute is dependent on the dress code attribute of the dress entity, then it is a non-trivial dependency; however, if the length attribute is dependent on the color and length attributes of the dress entity, then it is a trivial dependency.

Answer»

A trivial FUNCTIONAL DEPENDENCY is the situation, which shows a RELATION between an attribute with a superset of itself such that the attribute is dependent on the superset.
CONSIDER an attribute of the DRESS entity, say length. If the length attribute is dependent on the dress code attribute of the dress entity, then it is a non-trivial dependency; however, if the length attribute is dependent on the color and length attributes of the dress entity, then it is a trivial dependency.

A trivial functional dependency is the situation, which shows a relation between an attribute with a superset of itself such that the attribute is dependent on the superset.
Consider an attribute of the dress entity, say length. If the length attribute is dependent on the dress code attribute of the dress entity, then it is a non-trivial dependency; however, if the length attribute is dependent on the color and length attributes of the dress entity, then it is a trivial dependency.

What Is Trivial Functional Dependency?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment