Consider the statements about decomposition of a relation R is decomposed into R1, R2, R3, R4, .... Rn with functional dependencies F1, F2, F3, ..., Fn of functional dependency F. Which of the following option is correct regarding conditions of adequate decomposition? (Assume R1∪R2∪R3∪ .... Rn ≡ R).
A. R1⋈R2⋈R3⋈ .... Rn ≡ R, and F1∪F2∪F3∪ ...∪ Fn ⊂ F respectively
B. R1⋈R2⋈R3⋈ .... Rn ⊃ R and F1∪F2∪F3∪ ...∪Fn ≡ F respectively
C. R1⋈R2⋈R3⋈ .... Rn ≡ R and F1∪F2∪F3∪ ...∪Fn ⊃ F respectively
D. None of the above
