Database Reference
In-Depth Information
Establishtherelationshipbetweenthesetablesusingtheprocedureyou'vejustlearned,and
then identify the DEPARTMENTS table's new foreign key (E
MPLOYEE
ID) by placing the
letters “FK”nexttoitsname.
Figure10.35
showstherevisedrelationship diagramwiththe
results of your modifications.
Figure 10.35. Establishing the relationship between the MANAGERS and
DEPARTMENTS tables
As long as you can visualize this process generically, you'll be able to establish any one-
to-one relationship you encounter.
