Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Normal Form
Consider a schema R(A, B, C, D) and following functional dependencies.
A → B
B → C
C → D
D → B
Then decomposition of R into R1(A, B), R2(B, C) and R3(B, D) 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.