Question: database Please provide each steps in details 1. Consider the ER schemn of relation F- (A, B, C. (D), E, F). Knowing that there are
1. Consider the ER schemn of relation F- (A, B, C. (D), E, F). Knowing that there are the following (func- tional) dependencies: fd1: {A) - {CE), fd2: {A} {D), fd3 {A, B} - {F}. (a) (5 points) Is F in 1NF? If "yes" why? If not modify F so as to put it in INF. Let us call F1 the result of this step (b) {10 points) Is F1 in 2NF? If "yes" why? If not modify Fl so as to put it in 2NF. Let us call F2 the result of this step (c) (5 points) Is F2 in 3NF? If "yes" why? If not modify F3 so as to put it in 3NF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
