[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