Let us assume that a relation R (A, B, C, D, E, F, G, H) with set of functional dependencies F = {AB → E, C → D, D → E, FG → A} is decomposed into relations R1(ABE), R2(CD), R3(FGA) and R4(BCFGH). The decomposition _____.
A. is resulted in all BCNF relations
B. is dependency preserving decomposition
C. is not a dependency preserving decomposition
D. is lossless decomposition
Answer:A
Let us assume that a relation R (A, B, C, D, E, F, G, H) with set of functional dependencies F = {AB → E, C → D, D → E, FG → A} is decomposed into relations R1(ABE), R2(CD), R3(FGA) and R4(BCFGH). The decomposition _____.
A. is resulted in all BCNF relations B. is dependency preserving decomposition C. is not a dependency preserving decomposition D. is lossless decomposition