Competency 11, Normalize Many to Many Table Relationships

In the graphic below we normalized the relationship between the Style Table & Record Table. We originally wanted to create just a Category Table that would contain all of the information you see in the Style Table & Category Table. The Category Table would then entail a relationship to the Record Table. We could not do this though because what we ended up with was a many to many relationship. In order to counteract this we had to "normalize" the tables. In order to do this we created the Style Table which would connect to the record table as a one to many connection. We then took the Category table and created a relationship to the Style Table. All the information in the Category table can be accessed via the style table which connects to the record table. This might sound a little confusing, but maybe looking at the graphic might help.