Database Reference
In-Depth Information
Figure 10.24. Example of a self-referencing many-to-many relationship
In this case, a particular part can comprise several different component parts,
and
it can
itself be a component of other parts. For example, a clamp assembly (Part ID 704) is com-
posedofafasteningbolt(PartID703),abottomclamp(PartID702),andatopclamp(Part
ID701).Additionally,theclampassemblyisitselfacomponentofaseatassembly(PartID
707) and a frame assembly (Part ID 711).
Figure 10.25
shows how you diagram this type
of relationship.
Figure 10.25. Diagramming a self-referencing many-to-many relationship
