UGC-NET | UGC NET CS 2015 Jun – III | Question 11

The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if:
(a) R1 ∩ R2 ↠ (R1 – R2)
(b) R1 → R2
(c) R1 ∩ R2 ↠ (R2 – R1 )
(d)(R2 → R1) ∩ R2
(A) (a) and (b) happens
(B) (a) and (d) happens
(C) (a) and (c) happens
(D) (b) and (c) happens


Answer: (C)

Explanation: The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if:
1 – R1 ∩ R2 ↠ (R1 – R2)
2 – R1 ∩ R2 ↠ (R2 – R1 )
For more information on Lossless Decomposition Refer:Database Management System | Lossless Decomposition
option (C) is correct.

Quiz of this Question



My Personal Notes arrow_drop_up


Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.