I have a Logical / Physical model. Why does a Many-to-Many Transform appear in my logical model when ERwin already automatically added an associative table in the physical model? It looks like the transformation in the physical model is done.
That many-to-many transformation is for the logical model.
If you choose to include many-to-many relationships in a logical model, you may encounter some design problems. To avoid design problems that may be caused by many-to-many relationships, database designers frequently add associative entities to act as links for two ambiguously related entities. If you insert an associative entity between the two entities involved in a many-to-many relationship, you can change the relationship into a series of one-to-many relationships, and use the new relationships to clarify how the data model works.