[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