For the following relations and FDs,

1) (10 pts.) Indicate all the 3NF violations

2) (20 pts.) Indicate all the BCNF violations and decompose the relations, as necessary, into collections of relations that are in BCNF.

a. R(A, B, C, D) and FDs: AB->C, C->D, and D->A

b. R(A, B, C, D) and FDs: B->C and B->D

c. R(A, B, C, D) and FDs: AB->C, BC->D, CD->A, and AD->B

d. R(A, B, C, D) and FDs: A->B, B->C, C->D, and D->A

e. R(A, B, C, D, E) and FDs: AB->C, DE->C, and B->D