Equivalence of Two Sets of FD’s

In DBMS, For the equivalence of two sets of FDs,

  • Two different sets of FDs for a given table may or may not be equivalent.
  • If A and B are the two sets of FDs, then the following cases are possible

Case 01: A covers B (A ⊇ B)

Case-02: B covers A (B ⊇ A)

In Case 03: Both A and B cover each other (A = B)

Note: When both A and B cover each other, then it is known that A and B are equivalent; otherwise, both are not equivalent..


A  =  B