-
R(A, B, C, D) is a relation. Which of the following does not have a lossless join, dependency preserving BCNF decomposition?
-
- A → B, B → CD
- A → B, B → C, C → D
- AB → C, C → AD
- A → BCD
- A → B, B → CD
Correct Option: C
The solution exhibits as another case of multivalued dependency.
Here, the given relation is R(A, B, C, D).
This means all are dependent on each other.
Now, A → B and B → C This implies, A → C or we can say the AB → C Similarly, C → AD