Normalization

Assuming that all functional dependencies are apparent in the following table, determine whether following statements are true or false. Circle the correct one.

A	B	C
1	2	4
2	2	5
3	3	3
2	2	1

a. Does A B hold? True False

b. Does B A hold? True False

c. Does AB C hold? True False

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

A BCDE

B C

Is R in1NF, 2NF, 3NF or BCNF? Please explain?

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.