Question

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

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

Answer 2

Have you normalized this to 2NF or 3NF ?

Answer 3

Heh, apparently I skipped directly to 3NF.

Answer 4

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

Answer 5

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

Answer 6

hehe ok :)

Answer 7

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.

Answer 8

Thanks alot !!