Schema Translation - Information Systems Reengineering, Integration and Normalization - page 86

1RQUHODWLRQDOUHFRUGW\SHVZLWKRQH
GXSOLFDWHNH\

,PSOLHGUHODWLRQVKLS
&XVWRP HU /RD Q
1

&86720(5 /2$1

&XVWRPHU
UHFRUGNH\
/RDQ
'XSOLFDWHNH\

/RDQ
UHFRUGNH\

1RQUHODWLRQDOUHFRUGW\SHVZLWKWZR
GXSOLFDWHNH\V

,PSOLHGUHODWLRQVKLS
&XVWRP HU /RD Q

&86720(5 /2$1

/RDQ
UHFRUGNH\
&XVWRPHU
'XSOLFDWHNH\

&XVWRPHU
UHFRUGNH\
/RDQ
'XSOLFDWHNH\

Fig. 3.4 Derive implied relationship

6<67(0

VHW

&,7,(6

VHW

6725(6

FLW\
FLW\KHDGTXDUWHU

VWRUH
VWRUHDGGUHVV VHW

VHW

,7(06

LWHP
TW\

Fig. 3.5 A circuit loop network schema

It is up to the user to confirm the original database designer's idea on the func-
tion of the alternative path. If the user confirms the existence of a navigational
semantic, then the record types and Sets in the alternative path are mapped to dif-