1. Consider a schema R = {A,B,C,D,E} and the set F of FDs:

F = {AB --> CDE, A --> DE, D --> E}.

(i) Using the definition of 2NF, explain whether R is in 2NF or not.

(ii) Decompose R into 2NF, and not 3NF, preserving all dependencies.

2. Using the database schema {R_1,R_2,...,R_n} and the corresponding

sets F_1,F_2,...,F_n of FDs obtained from question (1.ii):

(i) Using the definition of 3NF, explain whether each R_i is in

3NF or not.

(ii) Decompose the database schema into 3NF preserving all dependencies.

Please provide answers according to question numbers thank you.