(Database Design – products attributes): What is better option for product attribute database design? [closed]

You’re making a common mistake of database design, storing name in one column and value in another column. This is not a relational database design. Each attribute should be named by the column name. Color, pages, shirt size, publish date, should be column names. If each product type has a distinct set of attributes, there … Read more