Question: 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
Get step-by-step solutions from verified subject matter experts
