Database Reference
In-Depth Information
Figure 10.30. Displaying each table's structure in a relationship diagram
Note
You'lloccasionallyfinditdifficulttoidentifytheexactrelationshipbetweenagiv-
en pair of tables. When this happens, just load the tables with some sample data.
This usually helps to reveal the type of relationship that exists between the tables.
It's worth mentioning that this procedure is much easier and shorter when you work with
a table that has a self-referencing relationship, such as the STAFF table. As
Figure 10.31
illustrates, all youhave todohere isdiagram the relationship andcrossoutthe entry onthe
matrix.
