Consider a relation R(P,Q,R,S,T) with the following functional dependencies:…

Consider a relation R(P,Q,R,S,T) with the following functional dependencies:
FD: {P→QT, RS→Q, T→S, S→P}
Which of the following is true for decomposition of R into R1:(P,Q,S),R2:(R,S,T) :

  1. A.

    lossless and dependency preserving

  2. B.

    not lossless but dependency preserving

  3. C.

    lossless but not dependency preserving

  4. D.

    none of the above

Attempted by 145 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…