hi all,

i come up these tables for my project and i'm looking for
advice/suggestion how to improve/optimize the structure further.

table item(itemid,warehouse,category,shapeid,....)
table shape(shapeid,physical_shape,...)
table dimension(dimensionid,itemid,shapeid,characteristi c,...)

possible values for physical_shape:
round, hex, sheet, tubing, ... etc

possible values for characteristic:
diameter, length, width, height, ... etc

i have 2 questions:
1) can this be optimized any further?
2) i like to seperate itemid from dimension table, is it possible???

thanks,
t. hiep