Why We Need to Compare Functional Dependencies?
Suppose in the designing process we convert the ER diagram to a relational model and this task is given to two different engineers. Now those two engineers give two different sets of functional dependencies. So, being an administrator we need to ensure that we must have a good set of Functional Dependencies. To ensure this we require to study the equivalence of Functional Dependencies.
Equivalence of Functional Dependencies
Pre-Requisite: Functional Dependency, Finding Attribute Closure, and Candidate Keys using Functional Dependency
For understanding the equivalence of Functional Dependencies Sets (FD sets), the basic idea about Attribute Closure is given in this article Given a Relation with different FD sets for that relation, we have to find out whether one FD set is a subset of another or both are equal.