Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given table memories(u,n,d,e,r,f,l,o,w) and the functional dependencies: f,d -> w,o,r,e r -> u,n d -> l o -> f Normalize to 2NF, 3NF, and BCNF,
Given table memories(u,n,d,e,r,f,l,o,w) and the functional dependencies:
f,d -> w,o,r,e
r -> u,n
d -> l
o -> f
Normalize to 2NF, 3NF, and BCNF, and find candidate keys.
Please explain the steps and first show 2NF, then 3NF, and the BCNF giving explnation at each step. Also, I found the candidate keys, are super keys important to know as well?
What I came up with was candidate keys fd and do, and i got four tables:
R1(d,f,w,o,r,e) df-> w,o,r,e
R2(r,u,n) r->u,n
R3(d,l) d-> l
R4(o,f) o->f
Please help, and let me know if that's correct or incorrect.
Step 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