Many-to-Many
With many-to-many, a table is used to link the master entity to the slave entities and vice versa. You can recognize these entities by their action buttons. They will have add, remove and view actions next to them. For example data owner membership is a many-to-many relation. Many users can have many data-owners membership and this table links those entities together in a matrix.
Figure 198 Schematic
Example: User - Data owner membership
| User A | Data Owner 1 |
|---|---|
| User B | Data Owner 1 |
| User B | Data Owner 2 |
| User C | Data owner 2 |
| User C | Data Owner 3 |
Table 195 Intermediate Table
Figure 199 Multiple Slave