Database Reference
In-Depth Information
Figure 10.12. A many-to-many relationship from the perspective of both TABLE A
and TABLE B
This is the second most common relationship that exists between a pair of tables in a data-
base. It can be a little more difficult to identify than a one-to-many relationship, so you
must be sure to examine the tables carefully.
Figure 10.13
shows a typical example of a
many-to-many relationship that you might find in a school database, which happens to be
a classic example of this type of relationship (no pun intended!).
