If a relation with a schema R is decomposed into two relations R1 and R2 such…
PYQ UGC NET 2012Modified — slightly modified from the official paper; see the solution
If a relation with a schema R is decomposed into two relations R1 and R2 such that (R1 ∪ R2) = R, then which one of the following is to be satisfied for a lossless join decomposition (→ indicates functional dependency)?
- A.
R1 ∩ R2 → R1 or R1 ∩ R2 → R2
- B.
R1 ∩ R2 → R1
- C.
R1 ∩ R2 → R2
- D.
R1 ∩ R2 → R1 and R1 ∩ R2 → R2
Attempted by 188 students.
Sign up free to check your answer
Sign up freeLoading lesson…

