1. Show the functional dependencies that hold on each of R₁=ABCD and R₂=BCEG. You do not need to show trivial functional dependencies, or those implied by others in the same set, but you must show all others.
2. Is the decomposition of R above into R₁=ABCD and R₂=BCEG dependency preserving? Why or why not?

Answer rating: 100% (QA)

To determine the functional dependencies for each relation and check if the decomposition is ... View the full answer