M:N relationships

Available under Creative Commons-ShareAlike 4.0 International License.

Mapping M-N Binary Relationship Type: For each M-N Binary Relationship, identify two relations A, B represent two entity type participating in R. Create a new relation S to represent R. Include in S as foreign keys the primary keys of A and B and all the simple attributes of R. The combination of primary keys of A and B will make the primary key of S.