The set of attributes X will be fully functionally dependent on the set of…
2018
The set of attributes X will be fully functionally dependent on the set of attributes Y if the following conditions are satisfied.
- A.
X is functionally dependent on Y
- B.
X is not functionally dependent on any proper subset of Y
- C.
Both (a) and (b)
- D.
None of these
Attempted by 585 students.
Show answer & explanation
Correct answer: C
If X is fully functionally dependent on Y, then two conditions must be true.
1. X is functionally dependent on Y. This means Y → X, i.e. Y determines X.
2. X is not functionally dependent on any proper subset of Y. In other words, if any attribute is removed from Y, the remaining subset should not be able to determine X.
Therefore, both (a) and (b) are required. Hence, option C is correct.
A video solution is available for this question — log in and enroll to watch it.