Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

mm

  • 4 years ago

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

  • This Question is Closed
  1. Narsat
    • 4 years ago
    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. mm
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Have you normalized this to 2NF or 3NF ?

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

    Heh, apparently I skipped directly to 3NF.

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

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

  5. Narsat
    • 4 years ago
    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

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

    hehe ok :)

  7. Narsat
    • 4 years ago
    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.

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

    Thanks alot !!

  9. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy