Consider the relation R(V, W, X, Y, Z) with functional dependencies {Z→Y, Y→Z,…

Consider the relation R(V, W, X, Y, Z) with functional dependencies {Z→Y, Y→Z, X→Y, X→V, VW→X}.

Suppose that relation R is decomposed into two relations, R1(V, W, X) and R2(X, Y, Z). Is this decomposition a lossless decomposition?

  1. A.

    Lossless due to X → Y,Z.

  2. B.

    Lossless due to VW → X.

  3. C.

    Lossy because X is insufficient.

  4. D.

    Lossy due to dependency break.

Attempted by 172 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…