Database Reference
In-Depth Information
Figure 10.22. Example of a self-referencing one-to-many relationship
Figure 10.23
shows how you diagram a self-referencing one-to-many relationship.
Figure 10.23. Diagramming a self-referencing one-to-many relationship
Many-to-Many
A
self-referencing many-to-many
relationship exists when a given record in the table can
be related to one or more other records within the table and one or more records can them-
selves be related to the given record. This may sound somewhat confusing at first, but the
example in
Figure 10.24
should help clarify the matter.
