Consider a schema R(P,Q,R,S) and the following functional dependencies P→Q,…
2024
Consider a schema R(P,Q,R,S) and the following functional dependencies P→Q, Q→R, R→S, S→Q. Then decomposition of R into R1(P,Q), R2(Q,R) and R3(Q,S) is:
- A.
Dependency Preserving and lossless join
- B.
Lossless Join but not dependency preserving
- C.
Dependency preserving but not lossless Join
- D.
Not dependency preserving and not lossless join
Attempted by 249 students.
Show answer & explanation
Correct answer: A
A video solution is available for this question — log in and enroll to watch it.