Consider a schema R (A, B, C, D) and functional dependencies A → B, C → D.…

RPSC Programmer · 2024 · Paper I

Consider a schema R (A, B, C, D) and functional dependencies A → B, C → D. Then, the decomposition of R into R1 (AB) and R2 (CD), is –

  1. A.

    Dependency preserving but not lossless join

  2. B.

    Not dependency preserving and not lossless join

  3. C.

    Lossless join but not dependency preserving

  4. D.

    Dependency preserving and lossless join

  5. E.

    Question not attempted

Attempted by 594 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…