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

The relation schemas R₁ and R₂ form a Lossless join decomposition of R if and only if:
(a) R₁ ∩ R₂ ↠ (R₁ – R₂)
(b) R₁ → R₂
(c) R₁ ∩ R₂ ↠ (R₂ – R₁ )
(d)(R₂ → R₁) ∩ R₂
(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 R₁ and R₂ form a Lossless join decomposition of R if and only if:
1 – R₁ ∩ R₂ ↠ (R₁ – R₂)
2 – R₁ ∩ R₂ ↠ (R₂ – R₁ )
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

Save