2NF and 3NF

Hi,
I am kind of confused with the 2NF and 3NF.
Would someone give me some straight explanation?
Thanks for help.
JasonBasically 2NF is about removing data that keeps getting repeated within a
table and 3NF is about removing data that is not dependand on the primary
key. You have to have fulfilled the requiremenets of 2NF to move to 3NF.
"Jason Huang" wrote:

> Hi,
> I am kind of confused with the 2NF and 3NF.
> Would someone give me some straight explanation?
> Thanks for help.
>
> Jason
>
>|||Hi
Have a look at http://www.datamodel.org/NormalizationRules.html
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"rb" <rb@.discussions.microsoft.com> wrote in message
news:EE9E3D81-36BA-46FE-BB7A-F7806FCC1638@.microsoft.com...[vbcol=seagreen]
> Basically 2NF is about removing data that keeps getting repeated within a
> table and 3NF is about removing data that is not dependand on the primary
> key. You have to have fulfilled the requiremenets of 2NF to move to 3NF.
> "Jason Huang" wrote:
>