Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

More Books

Students also viewed these Databases questions