SQL for Database Construction and Application Processing - Database Processing: Fundamentals, Design, and Implementation - page 332

&5($7(352&('85(:25.B$GG:RUN7UDQVDFWLRQ
#$UWLVW,',QW $UWLVWPXVWDOUHDG\H[LVWLQGDWDEDVH
#7LWOH &KDU
#&RS\&KDU
#'HVFULSWLRQ9DUFKDU
#$FTXLVLWLRQ3ULFH 1XPHULF

6WRUHGSURFHGXUHWRUHFRUGWKHDFTXLVLWLRQRIDZRUN,IWKHZRUNKDV
QHYHUEHHQLQWKHJDOOHU\EHIRUHDGGDQHZ:25.URZ2WKHUZLVHXVH
WKHH[LVWLQJ:25.URZ$GGDQHZ75$16URZIRUWKHZRUNDQGVHW
'DWH$FTXLUHGWRWKHV\VWHPGDWH

$6
%(*,1

'(&/$5(#URZ&RXQW$6,QW

'(&/$5(#:RUN,'$6,QW

&KHFNWKDWWKH$UWLVW,'LVYDOLG

6(/(&7 #URZ&RXQW &2817

)520 $57,67$6$

:+(5( $$UWLVW,' #$UWLVW,'

,)#URZ&RXQW

7KH$UWLVWGRHVQRWH[LVWLQWKHGDWDEDVH

%(*,1

3ULQW1RDUWLVWZLWKLGRI6WU#DUWLVW,'

3ULQW3URFHVVLQJWHUPLQDWHG

5(7851

(1'

&KHFNWRVHHLIWKHZRUNLVLQWKHGDWDEDVH

6(/(&7 #URZ&RXQW &2817

)520 :25.$6:

:+(5( :$UWLVW,' #$UWLVW,'DQG

:7LWOH #7LWOHDQG

:&RS\ #&RS\

,)#URZ&RXQW

7KH:RUNLVQRWLQGDWDEDVHVRSXWLWLQ

%(*,1

,16(57,172:25.7LWOH&RS\'HVFULSWLRQ$UWLVW,'

9$/8(6#7LWOH#&RS\#'HVFULSWLRQ#$UWLVW,'

(1'

*HWWKHZRUNVXUURJDWHNH\:RUN,'YDOXH

6(/(&7 #:RUN,' ::RUN,'

)520 :25.$6:

:+(5( :$UWLVW,' #$UWLVW,'

$1' :7LWOH #7LWOH

$1' :&RS\ #&RS\

1RZSXWWKHQHZ75$16URZLQWRGDWDEDVH

Figure 7-32
Stored Procedure
to record the
acquisition of
a Work

,16(57,17275$16'DWH$FTXLUHG$FTXLVLWLRQ3ULFH:RUN,'

9$/8(6*HW'DWH#$FTXLVLWLRQ3ULFH#:RUN,'

5(7851

(1'