Consider the universal relation R (A, B, C, D, E, F, G, H, I, J) with...

Transcribed Image Text:

Consider the universal relation R (A, B, C, D, E, F, G, H, I, J) with the functional dependencies as specified below: A, B, C -> D, E D -> E A -> H, I, J G-> F B -> F, G H -> J 1. What normal form this relation is in and why? 2. Decompose R into 2NF and then 3NF. (show both the 2NF and 3NF) Consider the universal relation R (A, B, C, D, E, F, G, H, I, J) with the functional dependencies as specified below: A, B, C -> D, E D -> E A -> H, I, J G-> F B -> F, G H -> J 1. What normal form this relation is in and why? 2. Decompose R into 2NF and then 3NF. (show both the 2NF and 3NF)