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

database
Please provide each steps in details
databasePlease provide each steps in details 1. Consider the ER schemn of

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!