Dbm 380 Week 2 Discussion Question

Hi everybody!Please use the Reply link and then prepare your individual responses to this discussion question. Please post it by Saturday to the <Main> forum. This discussion question is related to the articles for Week Two.What are the issues identified in the Cox (2009) article that a database administrator should know when working with a many-to-many relationship. Identify and discuss one of them.Week 2, DQ 1 When working with a many-to-many relationship, I believe that an administrator should know what a composite key is. A composite key is made up of 2 fields that together make the primary key. I’m not sure that I fully understand this or not as I’ve read the part about many-to-many relationships several times and from what I’m understanding, the 2 fields together create a unique Identifier for the 3 tables that are created in the process of linking the 2 one-to-many tables together. Alone the 2 fields are foreign keys to the bridged tables. This would mean that each of the 2 fields would be a foreign key for one of the tables. Say foreign key 1 would belong to the one-to-many table 1 and foreign key 2 would belong to