I have a problem in designing data model in database.
The issue is that product information should be keep in database (So we should have a table with name of "Products"), the products come from different sources(So we should have a table with name of "Source_Types"), but one of the sources is divided into several parts itself ( we have a table with name of "Source_A"). The Tables structures are like:
Source_Type_ID (PK) int NOT NULL
Source_Name varchar2(50) NOT NULL
Source_A_ID (PK) int
Name Source_A_Name varchar2(50)
And the products table is like this(the problem is here that I think design is wrong):
We need to partition the Products table by source_Type_id(not Source_A table),but we also need to know that the product come from which source_A. I mean partitions should be:
Product_ID (PK) int NOT NULL
Source_Type_ID FK To Source_Type Table
Source_A_ID FK To Source_A Table
What do you suggest for resolving the issue?