A table contains columns A B C D E F G AB is the primary key

A table contains columns A, B, C, D, E, F, G. A+B is the primary key. The following dependencies are identified: C rightarrow B A rightarrow D, E E rightarrow G Normalize this table to 2NF; underline the primary key of each table. Then normalize to 3NF; underline the primary key of each table. Then normalize to BCNF;; underline the primary key of each table.

Solution

1)
Non primary key dependencies should fully depend on primary key
C->B does not depend on A+B
T1: A,B,D,E,F,G
T2: B,C
A -> D,E
D,E does not depend on A + B
T1: A,B,F,G
T2: B,C
T3: A,D,E
E->G
T1: A,B,F,G,J
T2: B,C
T3: A,D,E
T4: J,E,G, J is the new PK

2)
There is no transitive dependencies so above tables are in 3NF and BCNF form
T1: A,B,F,G,J
T2: B,C
T3: A,D,E
T4: J,E,G, J is the new PK