WBJECA 2025 — Computer PYQ
WBJECA | Computer | 2025A functional dependency of the form X→Y is trivial if
Choose the correct answer:
- A.
Y⊆X
(Correct Answer) - B.
Y⊂X
- C.
X⊆Y
- D.
X⊂Y and Y⊂X
Y⊆X
Explanation
In Database Management Systems (DBMS), a functional dependency X→Y is considered trivial if all the attributes present in Y are also present in X. This means that the dependency is naturally satisfied by the definition of X itself, providing no additional information about the relationship between data.
Mathematically, we define this condition using set notation as:
Y⊆X
Explanation
In Database Management Systems (DBMS), a functional dependency X→Y is considered trivial if all the attributes present in Y are also present in X. This means that the dependency is naturally satisfied by the definition of X itself, providing no additional information about the relationship between data.
Mathematically, we define this condition using set notation as:
Y⊆X