Decomposition rules is

2011

Decomposition rules is

  1. A.

    XZ → YZ, X → Y

  2. B.

    X → Y, Y → Z | X → YZ

  3. C.

    X → YZ | X → Y, X → Z

  4. D.

    X → Y, WY → Z | WX → Z

Attempted by 396 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.

Explore the full course: Mppsc Assistant Professor