Data Normalization - Information Systems Reengineering, Integration and Normalization - page 359

D 2QHWRRQHFDUGLQDOLW\EHWZHHQ
(OHPHQW'HSDUWPHQWDQG(OHPHQW+HDG

G ,VBDUHODWLRQVKLSEHWZHHQ
(OHPHQW(PSOR\HHDQG(OHPHQW,QVWUXFWRU

'7'*UDSK

'7'*UDSK

'HSDUWPHQW (PSOR\HH

"

+HDG

,QVWUXFWRU

'7'

'7'

(/(0(17'HSDUWPHQW+HDG!
(/(0(17+HDG(037<!

(/(0(17(PSOR\HH,QVWUXFWRU"!
(/(0(17,QVWUXFWRU(037<!

)',QVWUXFWRUĹ(PSOR\HH

)'+HDGĹ'HSDUWPHQW

,',QVWUXFWRU ⊆ (PSOR\HH

H 'LVMRLQW*HQHUDOL]DWLRQRIVXEFODVV(OHPHQWV)XOO7LPHDQG
3DUW7LPHXQGHUVXSHUFODVV(OHPHQW,QVWUXFWRU

E 2QHWR0DQ\FDUGLQDOLW\EHWZHHQ
(OHPHQW'HSDUWPHQWDQG(OHPHQW,QVWUXFWRU

'7'*UDSK

,QVWUXFWRU

'7'*UDSK

_

'HSDUWPHQW

)XOO
7LPH

3DUW
7LPH

,QVWUXFWRU

'7'

'7'

(/(0(17,QVWUXFWRU)XOO7LPH_3DUW7LPH!
(/(0(17)XOO7LPH(037<!
(/(0(173DUW7LPH(037<!

(/(0(17'HSDUWPHQW,QVWUXFWRU!
(/(0(17,QVWUXFWRU(037<!

)XOO7LPH ∩ 3DUW7LPH

)',QVWUXFWRU Ĺ'HSDUWPHQW

,')XOO7LPH ⊆ ,QVWUXFWRU

,'3DUW7LPH ⊆ ,QVWUXFWRU

F 0DQ\WRPDQ\FDUGLQDOLW\EHWZHHQ
(OHPHQW$DQG(OHPHQW%ZLWKDWWULEXWHF

I 2YHUODS*HQHUDOL]DWLRQRIVXEFODVV(OHPHQWV+HDGDQG
,QVWUXFWRUXQGHUVXSHUFODVV(OHPHQW(PSOR\HH

'7'*UDSK

'7'*UDSK

(PSOR\HH

&RXUVH

,QVWUXFWRU

" "

LG

HYDOXDWLRQ

LGU
HI

+HDG ,QVWUXFWRU

$UWLIDFW

'7' '7'

(/(0(17,QVWUXFWRU$57,)$&7!
(/(0(17$57,)$&7(037<!
$77/,67$57,)$&7(YDOXDWLRQ&'$7$(03/,('!
$77/,67$57,)$&7LGHUI,'5()5(48,5('!
(/(0(17&RXUVH(037<!
$77/,67&RXUVHLG,'5(48,5('!

(/(0(17(PSOR\HH+HDG",QVWUXFWRU"!
(/(0(17+HDG(037<!
(/(0(17,QVWUXFWRU(037<!

,'+HDG ⊆ (PSOR\HH

,',QVWUXWRU ⊆ (PSOR\HH

)',QVWUXFWRU &RXUVHĹ(YDOXDWLRQ

+HDG ∩ ,QVWUXFWRU

Fig. 9.17 Data dependency of data semantics in DTD Graph