snippetMinor
2NF and 3NF How to do it
Viewed 0 times
2nfand3nfhow
Problem
Given E(ABCDE) ABC are candidate keys
Normalize into 2NF and 3NF
As far as 2NF is concerned the solution is quite easy:
But with regard to 3NF I think I'm wrong if I say that nothing should be done.
Maybe the
Is it correct?
Thanks a lot
So according to @OliverAsmus the 3NF result should be:
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
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
Solution
You're on the right track. Look closely at your 2NF result - this is where the 3NF result will come from. Your next task would be to take the 2NF result and eliminate the fields that do not depend on the key.
There are numerous sources for how and why to do this, but I prefer Microsoft's explanation the best:
http://support.microsoft.com/kb/283878
There are numerous sources for how and why to do this, but I prefer Microsoft's explanation the best:
http://support.microsoft.com/kb/283878
Context
StackExchange Database Administrators Q#11403, answer score: 3
Revisions (0)
No revisions yet.