Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please explain like im 5 years old 1. Consider the ER schema of relation F= (A, B, C, {D}, E, F). Knowing that there are
please explain like im 5 years old
1. Consider the ER schema of relation F= (A, B, C, {D}, E, F). Knowing that there are the following (func- tional) dependencies: fdl: {A} + {C, E}, 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 1NF. Let us call F1 the result of this step (b) {10 points} Is F1 in 2NF? If yes why? If not modify F1 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 3NFStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started