Using the functional dependencies provided, normalize each of the relations, R1, R2, and R3 to the third normal form.

Using the functional dependencies provided, normalize each of the relations, R1, R2, and R3 to the third normal form. You should assume that there are no duplicate rows present and that all values are atomic. A separate solution is required for each relation that must clearly identify the steps required to normalize the relation to 3NF and demonstrate that it is lossless and preserves all functional dependencies.

R1 (ABCDEFGH)

FDs: AB –> D, B –> C, B –> E, B –> F, A –> H, H –> G

R2 (ABCDEFGH)

FDs: ABC –> DE, BC –> G, G –> HF

R3 (ABCDEFGH)

FDs: BC –> DE, C –> F, F –> GH