SQL Transactions Exercises

Perform the test for the non-additive join property (lossless join) for the relation R(A₁, A₂, A₃, A₄, A₅), and the decompositions D_a, D_b, D_c, D_d and set of functional dependencies F given below. Ignore attributes that are not mentioned in each subsection (e.g., you can ignore absence of A₄ in D_d, test the join between R₁ and R₂):

D_a = { R₁(A₁, A₂) , R₂(A₃, A₄, A₅) }

D_b = { R₁(A₃, A₄) , R₂(A₄, A₅) }

D_c = { R₁(A₁, A₅) , R₂(A₄, A₅) }

D_d = { R₁(A₁, A₂, A₃) , R₂(A₁, A₂, A₅) }

F = { A₁ ->A₄ , A₄->A₅   , A₃->A₄ }

Does the decomposition D_a have the non-additive join property? Explain why or why not.

Does the decomposition D_b have the non-additive join property? Explain why or why not.

Does the decomposition D_c have the non-additive join property? Explain why or why not.

Does the decomposition D_d have the non-additive join property? Explain why or why not