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

((50RGHO '7'*UDSK

$
$

$
$

(QWLW\$

(OHPHQW$

5

(OHPHQW
*URXS

Q

%
%

P Q &

&

(QWLW\% 5 (QWLW\&

%
%

&
& (OHPHQW% (OHPHQW5 (OHPHQW&

%BLG &BLG

%BLGUHI &BLGUHI

5HODWLRQDO6FKHPD

6FKHPD

5HODWLRQ$ $ $
5HODWLRQ% % %
5HODWLRQ& & &
5HODWLRQ5 % & $

'7'

7UDQVODWLRQ

(/(0(17$*URXS!
$77/,67$$&'$7$5(48,5('!
$77/,67$$&'$7$5(48,5('!
(/(0(17*URXS%5&!
(/(0(17%(037<!
$77/,67%%&'$7$5(48,5('!
$77/,67%%&'$7$5(48,5('!
$77/,67%%BLG,'5(48,5('!
(/(0(175(037<!
$77/,675%BLGUHI,'5()5(48,5('!
$77/,675&BLGUHI,'5()5(48,5('!
(/(0(17&(037<!
$77/,67&&&'$7$5(48,5('!
$77/,67&&&'$7$5(48,5('!
$77/,67&&BLG,'5(48,5('!

Fig. 3.48 Schema translation of aggregation

((50RGHO '7'*UDSK

$
$

$
$

(QWLW\$

(OHPHQW$

LVD

"

6FKHPD

$
%

7UDQVODWLRQ

(QWLW\% (OHPHQW% %

5HODWLRQDO6FKHPD

'7'

5HODWLRQ$ $ $
5HODWLRQ% $ %

(/(0(17 $%"!
$77/,67$$&'$7$5(48,5('!
$77/,67$$&'$7$5(48,5('!
(/(0(17 %(037<!
$77/,67%%&'$7$5(48,5('!

Fig. 3.49 Schema translation of ISA relationship