I have a family of products that currently houses 3 product lines.  All 3 product lines share the same 4 options, but on top of those, each product line has 1, 2, or 3 different options respectively, individual to that product line.  To illustrate:+---------------------------------------------------+| Product Family:                                   |+---------------------------------------------------+| Product Line 1 | Product Line 2 | Product Line 3  |+----------------+----------------+-----------------+| * Base Option1 | * Base Option1 | * Base Option1  || * Base Option2 | * Base Option2 | * Base Option2  || * Base Option3 | * Base Option3 | * Base Option3  || * Base Option4 | * Base Option4 | * Base Option4  |+----------------+----------------+-----------------+| * Ind Option X | * Ind Option Y | * Ind Option A  ||                | * Ind Option Z | * Ind Option B  ||                |                | * Ind Option C  |+----------------+----------------+-----------------+How can I model those in relational database?What I have now is I have a table called category = {Product Line 1, Product Line 2, ..}  and product = {Product Line 1 - Model A, Product Line 1 - Model B, ...}
How to model shared and unique options for a family of products for a relational database?
database design;relational database;data modeling;normalization