hi all,

after a little 'research' and consultation with friends, i come up with
these tables for my database project.

table Item(ItemID,warehouse,ShapeID,weight,category,desc ription)
table Shape(ShapeID,physical shape)
table Dimension(DimensionID,dimension)
table ShapeDimension(ShapeDimensionID,ShapeID,DimensionI D)
table ItemShapeDimension(ItemID,ShapeDimensionID,value)

ItemID,ShapeID,DimensionID, and ShapeDimensionID are primary keys, auto
increment

Shape & Dimension are static tables

Shape: Round, Hex, Angle, Channel, Pipe,..etc.
Dimension: Diameter, Length, Width, Depth, Inner Diameter, Outer
Diameter...etc.

do you have any comment for this??? is there any potential structure
problem with these relationship?

thanks