I have a question in regards to properly setting up a relational DB model. What I have are two tables that I am looking to join using some junction tables however I am having some trouble when I go to query the data and I am getting duplicates as my data model must not be correct.
Here is a simple breakdown of how my data is structured and I think if I can get some insight on this simple breakdown I can figure out how to create better data relationships.
I have a table of Maturity Buckets which consists of 8 mutually exclusive data fields and the primary key is a given number 1-8
I have another table of Market Indices which will be given a Maturity Bucket Number which is NOT mutually exclusive meaning that the Maturity could be a blend of values in the Maturity Bucket Table or encompass all of the values
Finally I have a Holdings Table by which I am trying to match up a holding to a Market Indice based on the Maturity Bucket Number
I've attached a couple of diagrams and my table relationships to hopefully illustrate better what I am trying to accomplish. I am thinking I may need more junction tables but I am not really sure if that is the best route.
Thanks in advance for your insights!