Consider a schema R(P,Q,R,S) and the following functional dependencies P → Q, Q → R, R → S, S → Q. Then decomposition of R1 (P, Q), R2 (Q, R) and R3 (Q, S) is :
1
Dependency Preserving and lossless join
2
Lossless Join but not dependency preserving
3
Dependency preserving but not lossless Join
4
Not dependency preserving and not lossless join