Consider the following relational schema (P,Q, R, S, T) with FD set (P->QR,…

Consider the following relational schema (P,Q, R, S, T) with FD set (P->QR, RS->T, Q->S, T->P) if the relation decomposed into R1(P,Q,R) and R2(P, S, T), which of the following is true for given decomposition?

  1. A.

    Lossless join and dependency preserving

  2. B.

    Lossless but not dependency preserving

  3. C.

    Lossy and dependency preserving

  4. D.

    Lossy but not dependency preserving

Attempted by 174 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…