Question :
I have the following tables: tblCustomer, tblProductA and tblProductB. I have also an order table
tblOrder. Each order consists of a customer and one or more products from tblProductA and one or more products tblProductB.
The standard case is when we have only one table for products, and we usually use a join table to connect orders and products.
However, in the case I am bringing, it is mandatory to have two tables for products (tblProductA and tblProductB). How do I model this case?
Answer :
There are 2 options:
-
If your productType has same attribute:
-
If your ProductType has different attribute:
