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

Be sure to show the new functional dependency diagrams for the 1NF relations.

Follow the rules for normalizing shown in your book and in class.

4. Resolve 1NF into 2NF

Be sure to show the new functional dependency diagrams for the 2NF relations.

Follow the rules for normalizing shown in your book and in class.

5. Resolve 2NF into 3NF

Be sure to show the new functional dependency diagrams for the 3NF relations.

Follow the rules for normalizing shown in your book and in class.

Is there someone to help me on this problem ?