[Solved]Given Relation Schema R B C D E Following Functional Dependencies Set F D B Ac C E C Ae Ho Q37025705

Given the relation schema R(A,B,C,D,E) with the followingfunctional dependencies set F = { A→D ,B→AC, C→E, C→AE} which holdon R. If R is decomposed to the following R1 and R2 R1 = (A ,B, E)and R2 = (B, C, D)

a.Is the decomposition lossless-join? Explain your answer.

b. Is the decomposition dependency-preserving? Explain youranswer.

Expert Answer

---

Answer to Given the relation schema R(A,B,C,D,E) with the following functional dependencies set F = { A→D ,B→AC, C→E, C→AE… . . .