Decomposition rules is
2011
Decomposition rules is
Answer: C. X → YZ | X → Y, X → Z — The Decomposition Rule in database theory states that if a functional dependency exists from X to YZ, it implies separate dependencies from X to Y and X to Z.…
- A.
XZ → YZ, X → Y
- B.
X → Y, Y → Z | X → YZ
- C.
X → YZ | X → Y, X → Z
- D.
X → Y, WY → Z | WX → Z
Attempted by 751 students.
Show answer & explanation
Correct answer: C
The Decomposition Rule in database theory states that if a functional dependency exists from X to YZ, it implies separate dependencies from X to Y and X to Z. This rule allows breaking down a dependency with multiple attributes on the right-hand side into individual dependencies.
A video solution is available for this question — log in and enroll to watch it.
Loading lesson…