Question

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

You’ve looked over the naughty designer’s 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

Answer 1

7 A C nc may he in all Play Key AC mul valud aff %41. 11 have

R2 タD