4. Consider the following relation (table): (15 pts)
R: (A, B, C, D, E, F, G, H)
The key functional dependency is {A,B} \rightarrow {C, D, E, F, G, H} -- (a)
Now there is a functional dependency in R: {B, C} \rightarrow {D, E, F, G} -- (b)
Normalize the relation R with functional dependency (b). The result will be two relations (tables). Show
your steps.