Let the set of attributes of R be U, with ∣U∣=n=4.
A functional dependency X→Y is useful if X⊆U, Y⊆U, Xe∅, Ye∅, and X∩Y=∅.
For any two disjoint subsets X and Y of U, every attribute A∈U has 3 mutually exclusive possibilities:
A∈/X and A∈/Y
Thus, the total number of disjoint pairs (X,Y) is 3n=34=81.
From these, we must subtract the cases where X=∅ or Y=∅:
Cases where X=∅: Y can be any subset of U (24=16 pairs).
Cases where Y=∅: X can be any subset of U (24=16 pairs).
Case where X=∅ and Y=∅: counted in both, so 1 pair.
By the Principle of Inclusion-Exclusion:
Total useful FDs=34−24−24+1=81−16−16+1=50 Thus, the total number of possible useful functional dependencies is 50.