Question

What do we generally avoid in a many-to-many junction table?

Answer 1

Answer

There are generally many types of mistakes or acts that one must avoid in a many-to-many junction table.

This many-to-many junction table is just a name used in theory for relational & entity–relationship type table.

No direct connection should be established, and an attempt should be made to have communications via multiple points so that if one fails, the other should be able to cover up the loose connections.

The transparent base relationship here representing the entity is sometimes casually called an associative table.