Open study

is now brainly

With Brainly you can:

  • Get homework help from millions of students and moderators
  • Learn how to solve problems with step-by-step explanations
  • Share your knowledge and earn points by helping other students
  • Learn anywhere, anytime with the Brainly app!

A community for students.

i have 6 attributes A,B,C,D,E,F {A,B} -> C,D,E,F C -> B D -> C {B,C} ->E How to normalize this in 2NF and 3NF. I need the solution urgently. Please help!!!!

Computer Science
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.

Get this expert

answer on brainly

SEE EXPERT ANSWER

Get your free account and access expert answers to this and thousands of other questions

{A,B} -> C,D,E,F C -> B D -> C {B,C} ->E It's been long since I've normalized tables. I believe this would be 2NF, since this eliminates all dependencies to non-primary attributes among the tables. _AB_ D F --D and F only depend on primary key _AB_ _D_ C --C only depends on primary key _D_ _BC_ E -- E only depends on primary key _BC_ I would suggest you check this, since I'm not really sure.
Have you normalized this to 2NF or 3NF ?
Heh, apparently I skipped directly to 3NF.

Not the answer you are looking for?

Search for more explanations.

Ask your own question

Other answers:

Ok thanks alot !! Could you please also tell the 2NF ?
I might have actually skipped the whole 2NF step =P give me a minute to analyze
hehe ok :)
Hm, I believe that's 2NF which coincidentially happens to be in 3NF aswell. Sometimes tables in 2NF automatically become 3NF. But again, maybe you should check this answer.
Thanks alot !!

Not the answer you are looking for?

Search for more explanations.

Ask your own question