I am an absolute beginner to relational data modelling. I hope my question will be acceptable here nevertheless.
Let’s say there’s a merchandise. An item of merchandise may have variants.
(While it also has attributes common to all variants).
I don’t want to limit in the data model what the variants can be. I know the merchandise can vary in size and in color, but I don’t want the model to be limited to these two possible variations. There might be other variants (such as in material or process).
It is not clothing, and the variants may be priced differently. While I expect mostly sizes to affect the price, I don’t want to impose any such limit.
I also wish to anticipate that several variants could combine to affect the final price. Say that a different process could affect the price and different sizes too but colors not. But I want to avoid any fixed limitations in the model.
This is what I don’t know how to model properly.
(BTW, variants are identified as such by adding a variant code to the base of their SKU.)