Consider the following set of functional dependencies on the relation schema R= (A, B, C, D, E, G):

A BCD

BC DE

B D

D A

it can be shown that the following is a canonical cover:

A BC

B DE

D A

1).

Give a 3NF decomposition of r based on the canonical cover.

2)

Give a BCNF decomposition of r using the original set of functional dependencies.