Relational database management systems can’t have M:M relationships, so before converting a data model to a database in Access, SQL Server, mysql, or other relational DBMS, the data modeler must solve the M:M into something else.
when drawing the er diagrams what is the correct option regrading many to many relationships ?
- solve many to many relationship in er diagram
- keep many to many relationship to solve when doing physical data modeling(before normalizing the database).