Search for question
Question

4. Decomposition Consider the relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = {{A, B} → {C}, {A} → {D, E}, {B} → {F}, {C} → {B}, {F} → {G, H}, {D} → {I,J}} a. Decompose R to 2NF, then 3NF? b. Is your decomposition lossless for 3NF? Please provide the steps to argue that why you decomposition is lossless or not. c. Is it dependency preserving for 3NF? Please provide the steps to argue that why your decomposition is dependency preserving or not.

Fig: 1