Normalization

2. Suppose R is a table with attributes ABCDE. Assume that the following functional dependencies hold:

A BCDE

B C

a. Is R in1NF, 2NF, 3NF or BCNF?

b. If the original table is already in BCNF and does not need to be decomposed, put it is already in BCNF. If the table R is not in BCNF, decompose the table to make it BCNF.

3. Given a table R(A,B,C,D,E) and functional dependencies

AB CDE

B C,

D E,

decompose R into BCNF.