Databases technologies

3. Perform the test for the non-additive join property (lossless join) for the relation R(Ai, A2, A3, A4, As), and the decompositions Da, Db, De, Dd and set of functional dependencies F givern below. You can ignore attributes that are not mentioned in each particular subsection (e.g., you can ignore absence of A4 in Da, just test the join between Ri and R2): D, = { Ri(Ai, Az) , R2(A, A4, As) } D, = { Ri(Al, As) , R2(A4, As) } Da = { Ri(Ai, Az, A3) , R2(Ai, A2, As) } a. Does the decomposition D, have the non-additive join property? Explain why or why not. b. Does the decomposition Db have the non-additive join property? Explain why or why not c. Does the decomposition De have the non-additive join property? Explain why or why not. d. Does the decomposition Da have the non-additive join property? Explain why or why not