Quantcast

Got Homework?

Connect with other students for help. It's a free community.

  • across
    MIT Grad Student
    Online now
  • laura*
    Helped 1,000 students
    Online now
  • Hero
    College Math Guru
    Online now

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

mm Group Title

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!!!!

  • 2 years ago
  • 2 years ago

  • This Question is Closed
  1. Narsat Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    {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.

    • 2 years ago
  2. mm Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    Have you normalized this to 2NF or 3NF ?

    • 2 years ago
  3. Narsat Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    Heh, apparently I skipped directly to 3NF.

    • 2 years ago
  4. mm Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    Ok thanks alot !! Could you please also tell the 2NF ?

    • 2 years ago
  5. Narsat Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    I might have actually skipped the whole 2NF step =P give me a minute to analyze

    • 2 years ago
  6. mm Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    hehe ok :)

    • 2 years ago
  7. Narsat Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    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.

    • 2 years ago
  8. mm Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    Thanks alot !!

    • 2 years ago
    • Attachments:

See more questions >>>

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.