What would be the resulting tables from decomposing R based on the functional dependency B EG? How would decomposing R based on the functional dependency B EG affect the functional dependency AC EF? Reduce R to 2NF. Reduce R to 3NF, removing the violating functional dependencies from the last one listed (EF) to the first (AB C). R(A, B, C, D, E, F, G) AB C A D AC EF BEG BCD A EF