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) :
- A.
lossless and dependency preserving
- B.
not lossless but dependency preserving
- C.
lossless but not dependency preserving
- D.
none of the above
Attempted by 145 students.
Sign up free to check your answer
Sign up freeLoading lesson…

