Tweeted twitter.com/StackDBAs/status/667786471710072833
3 appended answer 11421 as supplemental
source | link

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done.

Maybe the 3NF schema is:

E1(ABC), E2(BD) 

Is it correct?

Thanks a lot


So according to @OliverAsmus the 3NF result should be:

E1(ABC), E2(BD) 

But if what I wrote is correct, am I right in thinking that the 3NF (in this particular case) doesn't preserve all the attributes? E doesn't depend upon any key so I got rid of it...

Is that correct? Thanks

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done.

Maybe the 3NF schema is:

E1(ABC), E2(BD) 

Is it correct?

Thanks a lot

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done.

Maybe the 3NF schema is:

E1(ABC), E2(BD) 

Is it correct?

Thanks a lot


So according to @OliverAsmus the 3NF result should be:

E1(ABC), E2(BD) 

But if what I wrote is correct, am I right in thinking that the 3NF (in this particular case) doesn't preserve all the attributes? E doesn't depend upon any key so I got rid of it...

Is that correct? Thanks

2 I edited my question since I tried to give an answer based on feedback
source | link

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done?.

I do apologize but I'm unable to work out how to normalize a schema into 3NFMaybe the 3NF schema is:

E1(ABC), E2(BD) 

Is it correct?

Thanks a lot

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done?

I do apologize but I'm unable to work out how to normalize a schema into 3NF

Thanks a lot

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done.

Maybe the 3NF schema is:

E1(ABC), E2(BD) 

Is it correct?

Thanks a lot

1
source | link

2NF and 3NF How to do it

Given E(ABCDE) ABC are candidate keys

Normalize into 2NF and 3NF

As far as 2NF is concerned the solution is quite easy:

E1(BD), E2(DE), E3(ABC) 

But with regard to 3NF I think I'm wrong if I say that nothing should be done?

I do apologize but I'm unable to work out how to normalize a schema into 3NF

Thanks a lot