A Many-to-Many relationship is impossible in a relational database.
It requires an unknown number of links in both directions and violates the 1st normal form.
Many-to-Many relationships are useful in a conceptual model to quickly capture what the business world sees.
In a logical model, a Many-to-Many relationship is replaced by an associative entity.
Copyright © 1996 Applied Information Science International