If D = {R1, R2} is a decomposition of R, and F is the set of functional…
2017
If D = {R1, R2} is a decomposition of R, and F is the set of functional dependencies on R, then which of the following ensures that the decomposition D is lossless (nonadditive)?
- A.
((R1 ∩ R2) → (R1 − R2)) ∈ F⁺
- B.
((R1 ∩ R2) → (R1 − R2)) ∉ F⁺
- C.
((R1 ∪ R2) → (R1 − R2)) ∈ F⁺
- D.
((R1 ∩ R2) → R1) ∈ F⁺
Attempted by 268 students.
Show answer & explanation
Correct answer: A
