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

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!