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

((5PRGHO 0DSSHG80/

&RXUVH

FRXUVH
FRXUVHB/RFDWLRQ

&RXUVH

FRXUVH
FRXUVHORFDWLRQ
&UHDWH&RXUVH

SUHFRXUVH

Q

35(5(48,6,7(
SUHUHTXLVLWHLQWHJHU
SUHUHTWLWOHVWULQJ
&UHDWH3UHUHTXLVWH

SUHUHTXLVLWH
SUHUHTWLWOH

3UHUHTXLVLWH

Fig. 3.34 Map a relationship to an association in UML

0DSSHG80/

((5PRGHO

6WDII

6WDII
'2%

6WDII

6WDIILQWHJHU
'2%GDWH

&UHDWH6WDII

G

3HUPDQHQW6WDII &RQWUDFW6WDII

,QKHULW6WDII
6DODU\LQWHJHU

,QKHULW6WDII
+RXUO\BUDWHLQWHJHU

3HUPDQHQW
6WDII

&RQWUDFW6WDII

:KHQFUHDWH3HUPDQHQW
6WDIIFKHFNQRWH[LVWHQFH
&RQWUDFW6WDII

:KHQFUHDWH&RQWUDFW
6WDIIFKHFNQRWH[LVWHQFH
3HUPDQHQW6WDII

6WDII
VDODU\

6WDII
+RXUO\BUDWH

Fig. 3.35 Map disjoint generalization to method

Step 6—Map weak entity to component class.
The existence of a weak entity in the EER model depends on its owner entity.
For example, the weak entity Instructor in Fig. 3.38 can be mapped into UML where
class Department is a composite object class that owns a component class Instruc-
tor. The own statement implies an existence dependency of component class In-