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

'HSW
'HSWQDPH

(PS
(PSQDPH

5HODWLRQV
'HSDUWPHQ W'HS W'HSWQDPH
(PSOR\HH (PS (PSQDPH'HSW

(17,7<
'(3$570(17

(17,7<
(03/2<((

'HFLVLRQ

Q

((5PRGHO &RUUHVSRQGQJ5HODWLRQDO6FKHPD

Q

5HODWLRQV
(PSOR\HH (PS W
0DQDJHU (PS PDQDJHU

(QWLW\
(PSOR\HH

PDQDJHV

(PS

&RUUHVSRQGLQJ5HODWLRQDO6FKHPD

((5PRGHO

QRWHPDQDJHUUHIHUVWR(PSDVIRUHLJQNH\LQUHODWLRQ(PSOR\HH

Fig. 3.17 Map binary and unary relationship in EER model to relationship schema

((5PRGHO 0DSSHG5HODWLRQDO6FKHPD

&XVWRPHU

5HODWLRQ&XVWRPHU &XVWRPHU
5HODWLRQ/RDQ6HFXULW\ 6HFXULW\
5HODWLRQ/RDQ&RQWUDFW /RDQ
5HODWLRQ&ROODWHUDO &XVWRPHU
6HFXULW\
/RDQ
0RUWJDJH

P P

&ROODWHUDO

Q Q

/RDQ
6HFXULW\

/RDQ
&RQWUDFW

Q P

Fig. 3.18 Map ternary relationship of all n:m relationship from EER model to relational schema

((5PRGHO 0DSSHG5HODWLRQDO6FKHPD

&XVWRPHU

5HODWLRQ&XVWRPHU &XVWRPHU
5HODWLRQ/RDQ6HFXULW\ 6HFXULW\
5HODWLRQ/RDQ&RQWUDFW /RDQ
5HODWLRQ&ROODWHUDO &XVWRPHU
6HFXULW\
/RDQ
0RUWJDJH

&ROODWHUDO

/RDQ
6HFXULW\

/RDQ
&RQWUDFW