-
Given the following relation instance
X Y Z 1 4 2 1 5 3 1 6 3 3 2 2
Which of the following functional dependencies are satisfied by the instance?
-
- XY → Z and Z → Y
- YZ → X and Y → Z
- YZ → X and X → Z
- XZ → Y and Y → X
- XY → Z and Z → Y
Correct Option: B
From the table given above, the B functional dependency is satisfied by the instance. We can say this by the following: Y is functionally dependent on Z. → YZ is functionally dependent on X. This is referred to as multivalued independency.
