Database Reference
In-Depth Information
Figure 10.46. The current structure of the STAFF table
There is currently no means of associating a given staff member to other staff members
within the table; therefore, you must create a new field that will act as the foreign key and
enable you to establish the relationship. Let's assume you create a new foreign key field
called M
ANAGER
ID that will draw its values exclusively from the S
TAFF
ID field. You now
establishtherelationshipbyofficiallydesignatingM
ANAGER
IDastheforeignkeyandnot-
ating it as such in the relationship diagram.
Figure 10.47
shows the revised relationship
diagram for the STAFF table.