Database Reference
In-Depth Information
Figure 10.13. A typical example of a many-to-many relationship
A student can attend one or more classes during a school year, so a single record in the
STUDENTS table can be related to one or more records in the CLASSES table. Con-
versely, one or more students will attend a given class, so a single record in the CLASSES
table can be related to one or more records in the STUDENTS table.
Figure 10.14
shows a generic example of how you create a relationship diagram for a
many-to-many relationship.
