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

5HODWLRQ&RXQWU\ &RXQWU\B1R &RXQWU\B1DPH
5HODWLRQ3DWLHQW +.,' 3DWLHQWB1DPH&RXQWU\B1R
5HODWLRQ5HFRUGB)ROGHU )ROGHUB1R /RFDWLRQ+.,'
5HODWLRQ$(B5HFRUG 0HGLFDOB5HFB1R $(B1R
5HODWLRQ0HGLFDOB5HFRUG 0HGLFDOB5HFB1R &UHDWHB'DWH6XEB7\SH
)ROGHUB1R
5HODWLRQ%RUURZHU %RUURZHUB1 %RUURZHUB1DPH
5HODWLRQ%RUURZ %RUURZHUB1R )ROGHUB1R
5HODWLRQ/RDQB+LVWRU\ %RUURZHUB1R )ROGHUB1R/RDQB'DWH
5HODWLRQ'HSDUWPHQW %RUURZHUB1R' HSDUWPHQWB1DPH
5HODWLRQ'RFWRU %RUURZHUB1R 'RFWRUB1DPH
5HODWLRQ2WKHUB+RVSLWDO %RUURZB1R +RVSLWDOB1DPH

By following the procedures that were mentioned before, we now translate this
relational schema into DTD as shown below.

Step 1—Reverse Engineering Relational Schema into an EER Model
By using the classification table, we can recover the EER model from the given
relational schemas as shown in Fig. 3.54 .

((50RGHO '7'*UDSK

$
$

%
%

(OHPHQW
*URXS

(QWLW\$ (QWLW\%

PQ

P
Q

P
Q

5

$
$

&
&

(OHPHQW$ (OHPHQW% (OHPHQW&

&
&

(QWLW\&

6FKHPD

% %

7UDQVODWLRQ

5HODWLRQDO6FKHPD '7'

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

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

Fig. 3.53 N-ary relationship: schema translation