Imagine a single poorly-designed table, r(R), with attributes A, B, C, D, E, F, G, H, I, J, K, L, M.

Youve looked over the naughty designers work and come up with the following logical functional dependencies. A > {B, D, F}? B > {G, H, I}? {A, C} > {E, J, K}? {J, K} > {L, M}

H is a composite attribute group with 3 attributes; H1, H2, H3. H3 is a multivalued attribute. L is a multivalued attribute.

1. Draw the functional dependency diagram for r(R).

2. What is the key of the original r(R)?

3. Resolve r(R) into 1NF

4. Resolve 1NF into 2NF

5. Resolve 2NF into 3NF