I need suggestions on how to properly model an item record along with all of its corresponding dimensions.
Consider the following:\[code\]| ITEM_ID | ITEM_DESCRIPTION | ITEM_PRICE | SIZE | LENGTH | COLOR| SH01 | POLO SHIRT | 22.95 | LARGE| || PA02 | KHAKI PANTS | 9.95 | 38 | 32 || BR22 | BRACELET | 10.95 | | | GREEN\[/code\]All of the items have different dimensions that may/may not be used by other items. Shirts and pants have sizes and lengths. The bracelet, however, has only a color. Also, new dimensions may be necessary as new items are added (weight, pattern, etc.). I've looked at EAV (entity-attribute-value), but from what I understand, reporting would be a nightmare with such a model.
How can I manage the dimensions for each item? Any and all suggestions would be greatly appreciated.
Consider the following:\[code\]| ITEM_ID | ITEM_DESCRIPTION | ITEM_PRICE | SIZE | LENGTH | COLOR| SH01 | POLO SHIRT | 22.95 | LARGE| || PA02 | KHAKI PANTS | 9.95 | 38 | 32 || BR22 | BRACELET | 10.95 | | | GREEN\[/code\]All of the items have different dimensions that may/may not be used by other items. Shirts and pants have sizes and lengths. The bracelet, however, has only a color. Also, new dimensions may be necessary as new items are added (weight, pattern, etc.). I've looked at EAV (entity-attribute-value), but from what I understand, reporting would be a nightmare with such a model.
How can I manage the dimensions for each item? Any and all suggestions would be greatly appreciated.