Database design - multi category products with properties
I am designing a basic inventory system for a vendor.  
They have many different product categories.  
Each product category has many different properties.  

A - x1, x2, x3, a1, a2, a3;
B - x1, x2, x3, b1, b2, b3, b4;
C - x1, x2, x3, c1, c2;

Design1: Different tables for each category.
Design2: Common Table, property table.

What is the best approach?


   
Database design - multi category products with properties
===

I am designing a basic inventory system for a vendor.  
They have many different product categories.  
Each product category has many different properties.  

A - x1, x2, x3, a1, a2, a3;
B - x1, x2, x3, b1, b2, b3, b4;
C - x1, x2, x3, c1, c2;

Design1: Different tables for each category.
Design2: Common Table, property table.

What is the best approach?


   