[UPHPU] Another Question on Normalization

Jon Jensen jon at jenseng.com
Fri Aug 18 14:20:29 MDT 2006


> Would I just drop those 
> fields like the Second Table below?

Exactly. The key for second level normalization is to remove unnecessarily
redundant data spanning multiple rows. Since ProductType and ProductNumber
can be used to get those values, ItemDescription and ItemName are
unnecessary.

> Is this in 2nd level?

Picture5.png looks right to me (according to the other tables in your
schema).

Jon



More information about the UPHPU mailing list