Database

Questioni: Consider the Entity Relational (ER) schema of relation R= (A, B, C, D, E(E1, E2)); knowing that there are the following functional dependencies (f.d.): fd1: {A, C} = {B, E) fd2:{A} {D) 1. Can you guess the primary key attribute(s)? Justify your answer 2. Is R in 1NF? If "yes" why? If not modify R so as to put it in 1NF. Let us call R1 the result of this step 3. Is R1 in 2NF? If "yes" why? If not modify R1 so as to put it in 2NF. Let us call R2 the result of this step 4. Is R2 in 3NF? If "yes" why? If not modify R3 so as to put it in 3NF