I have a requirement to create a denormalised database, to store the information about the products to be sold on an e-Commerce site. I need to store all the product attributes in the same database table.
The challenge is that, different Products can have different number of attributes and the maximum number of attributes that a product can have is not known in advance. For example, Product A can have 10 attributes while Product B may have 15 attributes and so on.
Please let me know if anyone is aware of any approach for optimal design of this type of database. Any pointers will help.