[UPHPU] Another Question on Normalization
Webot Graphics
graphics at westernbotanicals.com
Fri Aug 18 13:11:31 MDT 2006
sorry i didn't know I couldn't send pictures
After all your help, and reading a few articles, I am attempting to
normalize this table
http://www.giboneydesigns.com/normalization/Picture3.png
Now I am trying to move this into 2nd level normalization first, for
practice, then I will go on to 3rd level. Now the ItemName field is
actually formed by the joining of the Products Table and the Product
Type Table as seen below. Same concept with the ItemDescription Table
(being formed be the Products Table, Size Table and Products Type
Table). How do I show that in 2nd level Normalization? Would I just
drop those fields like the Second Table below? Is this in 2nd level?
http://www.giboneydesigns.com/normalization/Picture4.png
http://www.giboneydesigns.com/normalization/Picture5.png
Justin Giboney
graphics at westernbotanicals.com
More information about the UPHPU
mailing list