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

1. Narsat

{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

Have you normalized this to 2NF or 3NF ?

3. Narsat

Heh, apparently I skipped directly to 3NF.

4. mm

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

5. Narsat

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

6. mm

hehe ok :)

7. Narsat

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

Thanks alot !!