Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Normal Form
Consider a relation R= {ABCDE} with the following set of dependencies:
AB → C
C → D
B → E
Next consider the following set of decompositions for the relation schema R:
D1= {R1, R2}: R1= {ABC}, R2= {CD}
D2= {R1, R2, R3}: R1={ABC}, R2= {CD}, R3= {BE}
Which of the above decomposition has/ have lossless join property?1
Only D1
2
Only D2
3
Both D1 and D2
4
None of these