DB design question
Dear all,
I would like to ask you, if you are able to help with the following case:
We have 3 types of objects (each one has 12 different items):
S1, S2, S3, S4, S5, S6, S7, S8, S9, S10, S11, S12 (1-12)
P1, P2, P3, P4, P5, P6, P7, P8, P9, P10, P11, P12 (1-12)
H1, H2, H3, H4, H5, H6, H7, H8, H9, H10, H11, H12 (1-12)
"H" objects are fixed and static, they stay as they are. Each "H" object, may contain from 0 to 12 "P" objects. The "H" object, together with his "P" objects, may interact with 1 or 2 from the "S" objects.
Apparently, "P" objects (1-12) may interact between each other, let's say - P1/P4, P7/P8, etc. In result, they produce fixed values - a1, a2, a3, a4 (for each interaction, they may produce only 1 of the above mentioned values).
Based on all relations, I want to:
1. Create a matrix and DB design for each possible combinations between all objects;
2. Depending on the combination/interaction, to serve specific data which is valid for specific combination and relation between all objects;
3. Implement semantic capabilities and let the DB/system learn which of the data I serve is really correct; (users will be involved in this operation);
Could you help me how to organize all of this? Some kind of approach, any products that may help, guides, advise, etc?