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

J

$JJUHJDWLRQRI(OHPHQW&RXUVHZLWK
FRPSRQHQW(OHPHQWV/DEDQG/HFWXUH

'7'*UDSK

&RXUVH

L 3DUWLDO3DUWLFLSDWLRQEHWZHHQ(OHPHQW'HSDUWPHQW

DQG(OHPHQW,QVWUXFWRUZLWKQXOOYDOXH

⊥

/DE /HFWXUH

'7'*UDSK

'7'
(/(0(17&RXUVH/DE/HFWXUH!
(/(0(17/DE(037<!
(/(0(17/HFWXUH(037<!

'HSDUWPHQW ,QVWUXFWRU

LGUHI

LG

&RXUVH /DE /HFWXUH
)'/DE &RXUVH
)'/HFWXUH &RXUVH

⊆
Ĺ

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

Ĺ

K

1DU\UHODWLRQVKLSDPRQJ(OHPHQWV
&RXUVH7XWRUDQG6WXGHQWZLWKDWWULEXWH5

⊥

)''HSDUWPHQWĹ,QVWUXFWRU_
:KHUH ⊥ LVQXOOYDOXH

'7'*UDSK

&RXUVH 7XWRU 6WXGHQW

LG LG

N &DWHJRUL]DWLRQRI(OHPHQWV/HFWXUHUDQG3URIHVVRUWR

(OHPHQW7XWRU

LGUHI

LGUHI

$UWLIDFW

5

'7'*UDSK

'7'

LG LG

/HFWXUHU 3URIHVVRU 7XWRU

(/(0(176WXGHQW$57,)$&7!
(/(0(17$57,)$&7(037<!
$77/,67$57,)$&7LGUHI,'5()5(48,5('!
$77/,67$57,)$&7LGUHI,'5()5(48,5('!
(/(0(177XWRU(037<!
$77/,677XWRULG,'5(48,5('!
(/(0(17&RXUVH(037<!
$77/,67&RXUVHLG,'5(48,5('!

LGUHI

_

' 7'

(/(0(177XWRU(037<
$77/,677XWRULGUHI,'5()5(48,5('!
(/(0(173URIHVVRU(037<!
$77/,673URIHVVRULG,'5(48,5('!
(/(0(17/HFWXUHU(037<!
$77/,67/HFWXUHULG,'5(48,5('!

)'6WXGHQW7XWRU&RUXVHĹ5

XDU\UHODWLRQVKLSIRUHOHPHQW(PSOR\HH

M

/HFWXUHU

'7'*UDSK

7XWRU

3URIHVVRU

LGUHI

(PSOR\HH

:LIH

FRQGLWLRQDO

7XWRU

LG

+XVEDQG

'7'
(/(0(17(PSO\HH(037<
$77/,67(PSOR\HHLG,'5(48,5('!
$77/,67(PSOR\HHLGUHI,'5()5(48,5('!

)'(PSOR\HH Ĺ(PSOR\HH

Fig. 9.17 continued