A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. If a relation with a Schema R is decomposed into two relations R1 and R2 such that (R1 ∪ R2) = R1 then which one of the following is to be satisfied for a lossless joint 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
Answer:(R1 ∩ R2) --> R1 or R1 ∩ R2 ---> R2
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: