Upload
aldahar
View
214
Download
0
Embed Size (px)
Citation preview
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 1/57
!"#$%&'()$"**+*(,&,
-'.)(,/ 01 3'(,"4'"54'*),%(,!&./,&,"(),%6"7 8$" !"#$%&'()$"**+*(,&,"
9 :'"#%,; <,)=>,%(? @,(,% 3';'&A BB CDEF A G")8,%*)(H( G/&
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, C
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
! M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 2/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'() +,-./0/-12"3/"
4/-"56/%/! N6##%)*=>6"7 6"; N"Q,";6"7 ;,% -,""(")**, 4R7/I BVL 6"; 3'(,"4'"5,"(Q6%#
! J,%&)((/6"7 8$" P)"4/)=5," )" ;), W6"5()$"'/)(H( *$Q), <,'/)*),%6"7 4,(%),4/)=>,%
!"#$%&'()$"**+*(,&,! X )"*4,*$";,%, Y,%'"#T>%," '" ")=>(Z(%)8)'/, <,/'()$","*=>,&'('
! P)"4/)=5, )" !&./,&,"(),%6"7*8'%)'"(," #T% ;), !"(,%'5()$" 8$" N"Q,";6"7*Z#6"5()$"," &)( ;,& 3K:B 6"; ;,%," J$%Z 6"; ['=>(,)/,
! :$()8'()$" 6"; N"Q,";6"7*4,)*.),/, #T% Q,)(,%#T>%,";, BVLZW6"5()$"'/)(H(,"\
! X )"*4,*$";,%, <,'/)*),%6"7 ")=>(Z(%)8)'/,%? BVLZ4'*),%(,% N"Q,";6"7*#6"5()$","
! J,%&)((/6"7 8$" O%6";5,""(")**," )" K,R67 '6# B+"=>%$")*'()$" 6"; <,=$8,%+
! 7"8 3$"5 9/:/"&%6;#<
! =&286/-/" =6/ :,-3>?%&63 86/ @"9/"82"3:./6:A6/%/ 2"8 %/-"/" =6/
8$-$2:B :6/ :6"8 6"&/3-$%/- C/6% 8/- +,-%/:2"3D! E/"8/" =6/ 86/ /-9,-./"/" F/""&"6::/ 60 G$#0/" 8/- H.2"3/" 2"8
=/%.:&:&28620 /63/":&?"863 A-$1&6:;# $"( I J: %,#"& :6;#D
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'() +,-./0/-12"3/"
=&286/",.K/1&
! ^6& P%%,)=>," ;),*,% L,%"R),/, Q,%;," Q)% )& W$/7,";," ,_,&./'%)*=> ,)"`,)"#'=>,*a P<@ZB+*(,& #T% ;), 4/3,C-$6%/- @L ,"(Q,%#,"
! N6*7,>,"; 8$" ,)",% N"#$%;,%6"7*'"'/+*, Q,%;," Q)% ;), R6 %,'/)*),%,";,"@"9/"82"3:>2"1&6,"/" 6"; ;), P"()(),* #T% ;," M$&/".$"1/"&92-> );,"()#)R),%,"
! X 6"; ;,%," <,'/)*),%6"7*8'%)'"(," ;)*56(),%,"
! N4*=>/),U,"; Q,%;," Q)% ;), .%'5()*=>, M'67/)=>5,)( ;,% 7,QH>/(," P<@Z<,'/)*),%6"7 ;)*56(),%," 6"; 77#I b";,%6"7*Z 4RQI P%Q,)(,%6"7*8$%*=>/H7,,"(Q)=5,/"
! 3), `'6*R67*Q,)*,a <,'/)*),%6"7 ;,* P<@ZB+*(,&* *$Q), ;,**," P%Q,)(,%6"7,"4RQI '/(,%"'()8, !&./,&,"(),%6"7," Q,%;," Q)% (,)/* )" ;,% J$%/,*6"7? (,)/* )" ;,"c46"7," 8$%",>&,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 3/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, F
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
!
M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, d
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N O/6:A6/%>6-0$ 4/3,C-$6%/- @L
!"#$%&
0ICIE @%$;65(,? P)"R,/(,)/, 6"; ;,%," J,%Q,";6"7
0ICIC N"#$%;,%6"7," '" ;'* P<@ZB+*(,&
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 4/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, e
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() P-,821&/Q J6"5/%&/6%/ 2"8 8/-/" +/-9/"82"3
! 3), !"#$%&'()"& *+ 8,%(%,)4( '6* L,7$4'6*(,)"," >,%7,*(,//(, L5QZ N">H"7,%? 6"; RQ'% '/* O'"R,* *$Q), '6=> ,)")7, Y'/4#'4%)5'(,
! 3), P-,821&/ 7)4( ,* )" ;," R$-./" -,& 6"; .%$2
! 3,& ,"(*.%,=>,"; 7)4( ,* '6=> ,)")7, J6"5/%&/6%/ )" -,& 6"; .%$2? ,)")7, f,;$=> "6% )" ,)",% =&$"8$-8>$-./
! 3), '6# ;," "H=>*(," W$/)," 6"(,% SP-,821&/T ;'%7,*(,//(," *)";J"8A-,821&/ 6"; U$%.>$.-61$&/? Q,/=>, ;), W)%&' 8,%(%,)4(
! 3), '";,%,"? 6"(,% SJ6"5/%&/6%/T 7,/)*(,(," N%()5,/ ;),"," "6% R6%Y,%*(,//6"7 ;,% @%$;65(, 6"; Q,%;," ")=>( ,)"R,/" 8,%(%),4,"
! WT% ;), P-,821&/ 7)4( ,* ,)", P-/6:%6:&/ `#T% ;), '";,%," ")=>(a
! WT% $%%/ @-&61/% `P";.%$;65(,? Y'/4#'4%)5'(, 6"; P)"R,/(,)/,a 7)4( ,*1$%12%$&,-6:;#/ F,:&/"? Q,/=>, ;), K'*)* #T% ;), )"(,%", @%,)*Z 6";-$*(,"5'/56/'()$" *)";? *$Q), ,)"," ;,#)"),%(," V6"8/:&./:&$"8\
'6U,%;,& 5g""," N%()5,/ #T% )" K,'%4,)(6"7 4,#)";/)=>, N6#(%H7,-/:/-W6/-& *,)"
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, h
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I P-,821&/
@@L`N6#4'6'">H"7,% 7,*=>/$**,"a
@FF`-)..'">H"7,% 56%Ra
@F4`-)..'">H"7,% /'"7a
3),*, @%$;65(,7)4( ,* )" -,& XR$-.;,8/ Y )Z6"; )" .%$2 XR$-.;,8/ Y NZ
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 5/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, i
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I P-,821&/
[FF`j>'**)* -)..'">H"7,% 56%Ra
RL`W'>%7,*(,//a
[@U`j>'**)* N6#4'6'">H"7,%a
[F4`j>'**)* -)..'">H"7,% /'"7a
3),*, @%$;65(,7)4( ,* )" -,& XR$-.;,8/ Y )Z6"; )" .%$2 XR$-.;,8/ Y NZ
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ED
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I J6"5/%&/6%/
GR
`<,)#,"a
R@
`W,/7, &)( N=>*,a
FGN\
`-/$(R C _ ] #T% <';a
L]N^
`O,/,"5./'((, C _ F $4,"a
L7N^
`O,/,"5./'((, C _ F 6"(,"a
FN_`-/$(R C _ ha
F)``-/$(R E _ da
F)\`-/$(R E _ ]a
PN\`@/'((, C _ ]a
Pa`@/'((, &)( ^'.#,"a
GF))`<6";5/$(R E _ Ea
L+N^`O,/,"58,%4)";,% C _ Fa
P`N\`@/'((, d _ C]a
P`)``@/'((, d _ Eda
C4)'\`MT%, /)"5*E _ 0 _ ]a
CG)'\`MT%, %,=>(*E _ 0 _ ]a
P)_`@/'((, E _ ha
F)_`-/$(R E _ ha
3),*, P)"R,/(,)/, 7)4( ,* (,)/Q,)*, "6% )" ",6(%'/,% N6*#T>%6"7 `W'%4=$;, k Da?(,)/Q,)*, '4,% '6=> )" %$( `W'%4=$;, k Ea 6"; 4/'6 `W'%4=$;, k Ca
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 6/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I L,56"&,3-$A#/"
@@L X@2>.$2$"#?"3/- 3/:;#%,::/"Z
NNO#
-E]#
-Ed#
MLE0]#
M<E0]@dC]D
jNY#
E i Ch E E E
# ! l E? C m
#
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I L,56"&,3-$A#/"
[@U X[#$::6: @2>.$2#?"3/-Z
WO#
-Eh#
@Eh#
@dC]D
@^D
<-EE#
jNY# # ! l E? C m
E C C E E ]
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 7/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, E0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I L,56"&,3-$A#/"
RL XR$#-3/:&/%%Z
WO#
WN#
-ChD
-<C]D
@C]D
<WD
] C C ] ]
# ! l E? C m
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, E]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I L,56"&,3-$A#/"
N--#
-E]#
-Ed#
j--#
N-L#
-E]#
-Ed#
j-L#
# ! l E? C m
E d h E C Ed
@FF XF6AA$"#?"3/- 12-5Z @F4 XF6AA$"#?"3/- %$"3Z
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 8/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I L,56"&,3-$A#/"
[FF X[#$::6: F6AA$"#?"3/- 12-5Z
j--#
WO#
OnCFD
OGCFD
OJCFD
-Ed#
@dEdD
@^D
E C C C E C E
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Ed
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N() O/6:A6/%>6-0$ 4/3,C-$6%/- @L I L,56"&,3-$A#/"
[F4 X[#$::6: F6AA$"#?"3/- %$"3Z
j-L#
WO#
OnCFD
OGCFD
OJCFD
-Eh#
@^D
@dC]D
<-EE#
@Eh#
E C C C E C C C E ]
-Ed#
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 9/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Ee
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N(N @">,-8/-2"3/" $" 8$: JGPb=c:&/0 X!Z
['=>*(,>,"; ,)", '//7,&,)", K,*=>%,)46"7 ;,% N"#$%;,%6"7," 6"; ,)" c4,%4/)=5IP)", ;,(')//),%(, K,*=>%,)46"7 #$/7( )& ^6*'&&,">'"7 &)( ;,& 3'(,"4'"5,"(Q6%#I
! 3'* P<@ZB+*(,& *$//(, '//, !"#$%&'()$"," 8,%Q'/(,"? ;), )& ^6*'&&,">'"7
*(,>," &)( ;,% ! N6#(%'7*'4Q)=5/6"7
! @%$;65(>,%*(,//6"7
! K,*=>'##6"7 ;,% ,%#$%;,%/)=>," P)"R,/(,)/,
! N6*/),#,%6"7 ;,% S'%,
! L,7$M%')/,% *(,//( 7%6";*H(R/)=> '//, R6& J,%5'6# 5$&&,";," N%()5,/ *,/4*( >,%I3), >),%#T% 4,"g()7(," P)"R,/(,)/, Q,%;," 8$" ,_(,%"," L),#,%'"(," 4,R$7,"I
! N6#(%H7, Q,%;," 8$" ;,% L,7$M%')/,% NO '" ;), -6";," 7%6";*H(R/)=> )&&,%5$&./,(( '6*7,/),#,%(? ;I>I ,* 7)4( 5,)", M,)//),#,%6"7,"I N"'/$7 ;'R6 Q6%;, &)(;," L),#,%'"(," 8,%,)"4'%(? ;'** ;),*, K,*(,//6"7," ;,% L,7$M%')/,% NO
,4,"#'//* *(,(* "6% 5$&./,(( '6*/),#,%"I
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Eh
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N(N @">,-8/-2"3/" $" 8$: JGPb=c:&/0 X!!Z
! 3), @2>&-$3:./$-./6&2"3 4,>'";,/( ,)"," ,)"7,>,";," F2"8/"$2>&-$3Q), #$/7(1! B), .%T#(? $4 ;),*,% 5$&./,(( '6* ;,& 8,%#T74'%," L'7,%4,*('";
4,;),"( Q,%;," 5'"" `" o4$3/-%6/>/-2"3pa $;,% >),%#T% ,%*(.%$;6R),%( Q,%;," &6** `" oR/-&632"3:%6/>/-2"3paI
! K,) ,)",% !"#$%&'(&)*%"+"#'(& Q,%;," ,8(/I )& L'7,% 8,%#T74'%, N%()5,/ #T% ;),*," N6#(%'7 %,*,%8),%( 6"; #T% ;," <,*(W,%()76"7*'6#(%H7, ,%R,67(I
! B)"; *$#$%( 4RQI "'=> N4*=>/6** ;,% W,%()76"7 '//, N%()5,/ )&L'7,%4,*('"; 8,%#T74'%? Q)%; ,)" J,%*'";'6#(%'7 ,%*(,//( 6"; ;'&)(;'* N6*#'**," *$Q), ;), N6*/),#,%6"7 ;,% S'%, #T% ;),*,"-6";,"'6#(%'7 8,%'"/'**(I
! L,7$M%')/,% /),#,%( *,)", N%()5,/ )& N//7,&,)"," "'=> @%,)*/)*(,IS6%;, &)( ,)",& -6";," ,)" '4Q,)=>,";,% @%,)* 8,%,)"4'%(? *$ Q)%;;),*,% )" ;,% f,Q,)/)7," N6#(%'7*.$*)()$" 8,%&,%5(I
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 10/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Ei
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N(N @">,-8/-2"3/" $" 8$: JGPb=c:&/0 X!!!Z
! 3), R/-&632"3:$.&/6%2"3 4,>'";,/( ,)"7,>,";, R/-&632"3:$2>&-?3/Q), #$/7(1
! B), ,%&)((,/( #T% f,;, N6#(%'7*.$*)()$" ;," K,;'%# '" P)"R,/(,)/,"
! B)"; ;), `"$=>a R6 .%$;6R),%,";, N%()5,/&,"7, ,)",% N6#(%'7*.$*)()$" 4,"g()7(," P)"R,/(,)/, 8$//*(H";)7 )& L'7,%4,*('";8,%#T74'%? ;'"" Q)%; ;), W,%()76"7 #T% ;),*," @$*(," '"7,*($U,"I
! B)"; >)"7,7," ")=>( '//, P)"R,/(,)/, #T% ,)", N6#(%'7*.$*)()$"8$//*(H";)7 )& L'7,%4,*('"; 8,%#T74'%? ;'"" Q)%; ;,% O,*'&(4,;'%# '" P)"R,/(,)/," #T% ;," R6 .%$;6R),%,";," N%()5,/ '" ;," P)"5'6#7,&,/;,(\ 6"; RQ'% 6"'4>H"7)7 ;'8$"? $4 ,)", M,)/&,"7, ;,%4,"g()7(," P)"R,/(,)/, ,8(/I )& L'7,%4,*('"; 8,%#T74'% QH%,I Z B)";'//, 4,*(,//(," P)"R,/(,)/, #T% ,)"," W,%()76"7*Z'6#(%'7 ,)"7,(%$##,"?Q)%; ;), W,%()76"7 '"7,*($U,"I
! ['=> P%/,;)76"7 ,)",* W,%()76"7*'6#(%'7,* Q,%;," ;), N%()5,/ )&L'7,%4,*('"; ,)"7,46=>( 6"; `#T% ;),*, N6#(%'7*.$*)()$"a '/*%,*,%8),%( &'%5),%(I
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, CD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N(N @">,-8/-2"3/" $" 8$: JGPb=c:&/0 X!+Z
! 3), J6"1$2>:$.&/6%2"3 ,%>H/( O/:&/%%$">,-8/-2"3/"? ;), *)=> '6# ;),4,"g()7(," P)"R,/(,)/, #T% ,)"R,/", W,%()76"7*'6#(%H7,? ;I>I '6# ,)"R,/",
N6#(%'7*.$*)()$"," 8$" -6";,"'6#(%H7,"? 4,R),>,"I B), 8,%#H>%( &)(;),*," K,*(,//'"#$%;,%6"7," Q), #$/7(1
! B), #'**( 7,7,4,","#'//* &,>%,%, K,*(,//'"#$%;,%6"7,"? ;),;'**,/4, P)"R,/(,)/ 4,(%,##,"? R6 ,)",% K,*(,//6"7 R6*'&&," 6";
*=>)=5( ;),*, '" ;," '6*7,QH>/(," L),#,%'"(,"I! ['=> P)"7'"7 ;,% S'%, Q,%;," ;), P)"R,/(,)/, ;,"
K,*(,//'"#$%;,%6"7," `6"; ;'&)( '6=> ;," N6#(%'7*.$*)()$","aR67,$%;",(? ;I>I 4,) ;,% P)"46=>6"7 )& L'7,%4,*('"; #T% ;),*,%,*,%8),%(I
! 3), +/-:$"8$.&/6%2"3 4,'%4,)(,( ,)"," +/-:$"8$2>&-$3 Q), #$/7(1
! B), #'**( ;), S'%, .>+*)*=> '6* ;,& L'7,% '6*? *(,//( ;), S'%,R6*'&&," 6"; $%7'")*),%( ;," M%'"*.$%( R6& -6";,"I
! 3,% J$//R67 ;,% N6*/),#,%6"7 Q)%; 8$" ;,% J,%*'";'4(,)/6"7 '" ;),
K6=>>'/(6"7 7,&,/;,(? ;), ;'%'6#>)" ;), <,=>"6"7**=>%,)46"7'"*(gU(I
! 3'&)( )*( ;), N6#(%'7*4,'%4,)(6"7 '47,*=>/$**,"I
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 11/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, CE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(N(N @">,-8/-2"3/" $" 8$: JGPb=c:&/0 X+Z
M/- @.%$2> /6"/- @2>&-$3:$.96;1%2"3 60 H./-.%6;1
@2>&-$3:./$-./6&2"3<J,%#T74'%, S'%, %,*,%Z8),%," 6"; #T% <,*(W,%()76"7*'6#(%'7,%(,)/,"
E C
R/-&632"3 X"$;# J"8/Z<
K,*('"; q <,*,%8),%6"7,",%>g>,"
0
@2>&-$3:b./$-./6&2"3<
N6*46=>6"7 '6* K,*('";
6"; N"*($U," N6*/),#,%6"7
@2>&-$3:./$-./6&2"3< N6*46=>6"7 '6*K,*('"; q <,*,%Z8),%6"7 6";
N"*($U," ;,% N6*/),#,%6"7
+/-:$"8$.&/6%2"3< N6*/),#,%6"7
]
D 4$3/-b9$-/d f'
",)"
N6#(%'7Q6%;, ,%#'**(
F
O2;##$%&2"3<<,=>"6"7*Z*=>%,)46"7
,'+$#-& -.&")/0*1))"(
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, CC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
! M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 12/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, C0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(' J"&92-> 8/: M$&/".$"1:;#/0$:
!"#$%&
0I0IE P%&)((/6"7 ;,% P"()(),*
0I0IC c4,%/,76"7," R6% N44)/;6"7 8$" P"()(),* '6# <,/'()$","
0I0I0 <,'/)*),%(,* B=>,&' #T% L,7$M%')/,%NO
0I0I] N%4,)(," &)( B)=>(," ̀J),Q*a
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, C]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
S),;,%>$/6"71 S), );,"()#)R),%," Q)% .$(,"R),//, P"()(),* )" ,)",& M,_(r
S$;6%=> 6"(,%*=>,);," *)=> P"()(),* 8$" N((%)46(,"r
XP,&/"56/%%/Z J"&6&6/: :6"8 =2.:&$"&6W/Q 86/ 82-;# 9/6&/-/ @"3$./" "?#/-./:;#-6/./" :6"8(=2.:&$"&6W/ ,#"/ "?#/-/ @"3$./" :6"8 6" 8/- G/3/% %/863%6;# @&&-6.2&/
W," J"&6&6/:(
N4,% N=>(6"71
! N6=> )& M,_( ")=>( "H>,% 6&*=>%),4,", B64*('"()8, 5g""," ;,""$=> #T%,)" P"()(+ *(,>,"s t N6=> '6# ;), K,;,6(6"7 )& -$"(,_( ;,% N"Q,";6"7'=>(,"s
! N6# B+"$"+&, 6"; Y$&$"+&, '=>(,"s
! 3'%'6# '=>(,"? $4 ;,% K,7%)## '6=> ('(*H=>/)=> %,/,8'"( #T% ;'* R6
%,'/)*),%,";, !"#$%&'()$"**+*(,& )*(
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 13/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, CF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
3,(')//),%(, K,*=>%,)46"7 ;,% N"#$%;,%6"7," q P%&)((/6"7 ;,% P"()(),*1
! L,7$M%')/,% *(,//( 7%6";*H(R/)=> '//, R6& J,%5'6# 5$&&,";," S'%," *,/4*( >,%? ;),*, *)"; )" ,)",%
@%,)*/)*(, '6#7,#T>%(I! P)"R,/(,)/, *(,//( L,7$M%')/,% ")=>( >,%? *$";,%" 4,R),>( ;),*, 8$" ,_(,%"," L),#,%'"(,"
! L,7$M%')/,% 8,%Q'/(,( R6 f,;,& -6";," ,)", -6";,""6&&,% *$Q), ;," ['&,"? ;), B(';( *$Q),*,)", K$")(H(I
! ^6 f,;,& -6";," Q,%;," ;), N6#(%H7, &)( N6#(%'7*"6&&,%? N6#(%'7*;'(6&? P%#'**6"7*;'(6&?K,'%4,)(6"7**('(6* *$Q), ;," N6#(%'7*.$*)()$"," &)( M,)/,"6&&,% 6"; N"R'>/ 8,%Q'/(,(I
! 3,% K,'%4,)(6"7**('(6* ,)",* N6#(%'7,* )*( Q), #$/7( ;,#)"),%(1
D k6"4,'%4,)(,(
E k8,%#T74'%, S'%, )& K,*('"; %,*,%8),%( 6"; W,%()76"7*'6#(%'7 )")()),%(
C kW,%()76"7 4,,";,( 6"; S'%, )" K,*('"; 6"; <,*,%8),%6"7 ,)"7,46=>(
0 kS'%, Q6%;, )& K,*('"; ̀ 6"; 77#I '6=> <,*,%8),%6"7a '6*7,46=>( 6"; *(,>( R6% N6*/),#,%6"7 4,%,)(] kS'%, Q6%;, '6*7,/),#,%( 6"; P%*(,//6"7 6"; J,%*'"; ;,% <,=>"6"7 Q6%;, )")()),%(
F k<,=>"6"7**=>%,)46"7 )*( ,%#$/7( u N6#(%'7*4,'%4,)(6"7 '47,*=>/$**,"
Y J"&6&c d
Y J"&6&c
Y @&&-6.2&
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Cd
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
! L,7$M%')/,% /),#,%( *,)", N%()5,/ )& N//7,&,)"," "'=> @%,)*/)*(,I S6%;," &)( ,)",& -6";," ,)"'4Q,)=>,";,% @%,)* 8,%,)"4'%(? *$ Q)%; ;),*,% )" ;,% f,Q,)/)7," N6#(%'7*.$*)()$" 8,%&,%5(I
! L,7$M%')/,% 8,%Q'/(,( R6 f,;,& L),#,%'"(," *,)", L),#,%'"(,""6&&,% *$Q), ;," ['&,"? ;), B(';(6"; *,)", K,Q,%(6"7I
! ^6 f,;,& L),#,%'"(," Q,%;," ;), K,*(,//6"7," &)( K,*(,//"6&&,%? K,*(,//;'(6&? ;,&K,'%4,)(6"7**('(6* *$Q), ;," K,*(,//.$*)()$"," &)( M,)/,"6&&,% 6"; :,"7, 8,%Q'/(,(I
! 3,% K,'%4,)(6"7**('(6* ,)",% K,*(,//6"7 )*( Q), #$/7( ;,#)"),%(1
D kK,*(,//6"7 /H6#(
E kS'%, Q6%;, '"7,/),#,%(
C kS'%, Q6%;, ,)"7,/'7,%( 6"; )& K,*('"; ,)"7,46=>(
Y J"&6&c d
Y J"&6&c
Y @&&-6.2&
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 14/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Ce
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
! N6#(%H7, Q,%;," 8$" ;,% L,7$M%')/,% NO '" ;), -6";," 7%6";*H(R/)=> )&&,% 5$&./,(('6*7,/),#,%(? ;I>I ,* 7)4( 5,)", M,)//),#,%6"7,"I
! P%>'/(,", N6#(%H7, Q,%;," 8$" ;,% N6#(%'7*4,'%4,)(6"7 `;,% J,%5'6#*'4(,)/6"7a Q), #$/7(4,'%4,)(,(1
! B)"; '//, @$*)()$"," ,)",* N6#(%'7* )" ;,% 7,QT"*=>(," :,"7, )& 8,%#T74'%," L'7,%4,*('";`k K,*('"; IuI %,*,%8),%(a 8$%>'";,"? ;'"" Q,%;," ;), N%()5,/ ;$%( '6*7,46=>( 6"; ;),J,%*'";'4(,)/6"7 ,%>H/( ,)"," N6*/),#,%6"7*'6#(%'7I
! -'"" ;,% N6#(%'7 ")=>( 5$&./,(( '6* ;,& 8,%#T74'%," L'7,%4,*('"; 4,;),"( Q,%;,"? Q)%;Q), #$/7( 8,%#'>%,"1
! B)"; ,)")7, N6#(%'7*.$*)()$"," 7'"R $;,% (,)/Q,)*, )& 8,%#T74'%," L'7,%4,*('";8$%>'";,"? Q,%;," ;),*, ;$%( %,*,%8),%(I
! WT% ;), %,*(/)=>," N%()5,/ Q)%; ,)" W,%()76"7*'6#(%'7 '" ;), W,%()76"7*'4(,)/6"77,*=>)=5(I
! 3), W,%()76"7*'4(,)/6"7 46=>( ;), N%()5,/ "'=> W,%()7*(,//6"7 )& K,*('"; ,)" 6";5,""R,)=>",( ;),*, '/* %,*,%8),%(I
! 3), N6#(%'7*8,%Q'/(6"7 46=>( ;," N6#(%'7 &)( *,)"," @$*)()$"," '6* ;,& K,*('"; 6";)" ;,% <,*,%8),%6"7 '6* 6"; ,%(,)/( ;,% J,%*'";'4(,)/6"7 ,)"," J,%*'";'6#(%'7I
! P)" W,%()76"7*'6#(%'7 4,R),>( *)=> )&&,% '6# ,)"," -6";,"'6#(%'7 6"; '6# ;,**," N6#(%'7*Z.$*)()$","\ ;),*, 7,4," ;'%T4,% N6*56"#(? Q,/=>, @%$;65(, )" Q,/=>,% B(T=5R'>/ R6 #,%()7," *)";I
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Ch
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
! 3), W,%()76"7*'4(,)/6"7 4,>'";,/( ,)"7,>,";, W,%()76"7*'6#(%H7, Q), #$/7(1
! B), ,%&)((,/( #T% f,;, N6#(%'7*.$*)()$" :,"7, ;," K,;'%# '" P)"R,/(,)/,"I
! B)"; '//, P)"R,/(,)/, #T% ,)", N6#(%'7*.$*)()$" 8$//*(H";)7 )& L'7,%4,*('"; 8,%#T74'%?Q)%; ;), W,%()76"7 >),%#T% '"7,*($U," *$Q), ;), S'%, "'=> W,%()7*(,//6"7 )& L'7,% )"K,*('"; ,)"7,46=>( 6"; '/* %,*,%8),%( 7,5,""R,)=>",(I
! B)"; ")=>( '//, P)"R,/(,)/, ,)",% N6#(%'7*.$*)()$" 8$//*(H";)7 )& L'7,%4,*('"; 8,%#T74'%?Q)%; ;,% O,*'&(4,;'%# '" P)"R,/(,)/," )" W$%& ,)",% K,*(,//'"#$%;,%6"7 '" ;," P)"5'6#
7,&,/;,(I`;I>I #T% P)"R,/(,)/, ,%#$/7( 5,)", P"("'>&, $;,% <,*,%8),%6"7 8$" M,)/&,"7," )&K,*('";Ia
! ['=> N4Q)=5/6"7 ;,% K,*(,//6"7 46=>( ;,% P)"5'6# ;), M,)/, )" K,*('"; 6"; &'%5),%(;),*, '/* %,*,%8),%(I
! B)"; '//, P)"R,/(,)/, #T% ,)", N6#(%'7*.$*)()$" 8$%>'";,"? 46=>( ;), W,%()76"7 ;),P)"R,/(,)/, '6* K,*('"; 6"; ;,% <,*,%8),%6"7 '6* 6"; *(gU( ;), W,%()76"7 '"I
! S,"" ;), /,(R(, N6#(%'7*.$*)()$" )& L'7,% ,)"7,46=>( Q6%;,? Q)%; ;), N6#(%'7*4,'%4,)(6"7 8$" ;,% W,%()76"7*'4(,)/6"7 >),%T4,% )"#$%&),%(I
! P)", K,*(,//'"#$%;,%6"7 )*( ,)", L)*(, 8$" M,)/," &)( ;,% 4,"g()7(," N"R'>/? Q,/=>, ;),P)"5'6#*Z'4(,)/6"7 #T% ;), W,%()76"7*'4(,)/6"7 #T% ,)"," 4,*()&&(," W,%()76"7*'6#(%'74,*=>'##," *$//I
Y J"&6&c d
Y J"&6&c
Y @&&-6.2&
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 15/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Ci
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
! P)", K,*(,//'"#$%;,%6"7 Q)%; *,)(,"* ;,% P)"5'6#*'4(,)/6"7 Q), #$/7( 4,'%4,)(,(1
! B), .%T#(? $4 ,8(/I ;'**,/4, M,)/ '6=> )" '";,%,"? '5(6,// 8$%/),7,";," K,*(,//'"#$%;,%6"7,"'"7,#$%;,%( Q)%; 6"; #'**( ;),*, #T% ;), K,*(,//6"7 4,)& L),#,%'"(," ,8(/I R6*'&&,"I`;I>I ,)", K,*(,//.$*)()$" ,)",% K,*(,//6"7 5'"" *)=> ,8(/I '6# &,>%,%, K,*(,//'"#$%;,%6"7,"4,R),>,"Ia
! N"*=>/),U,"; /,7( ;), P)"5'6#*'4(,)/6"7 #,*(? 8$" Q,/=>,& L),#,%'"(," ;), M,)/, `6"; R6Q,/=>,& @%,)*a 4,R$7," Q,%;," *$//," 6"; #'**( ;),f,")7," K,*(,//.$*)()$","? ;), ;,"7/,)=>," L),#,%'"(," 4,(%,##,"? R6 ,)",% K,*(,//6"7 R6*'&&,"I
! 3), P)"5'6#*'4(,)/6"7 >'( &)( '//," L),#,%'"(," 8,%,)"4'%(? ;'** K,*(,//6"7," *(,(*5$&./,(( '6*7,#T>%( Q,%;," `;I>I ,* ,%#$/7," 5,)", M,)//),#,%6"7,"aI
! ['=> P)"7'"7 ;,% S'%, 46=>( ;), P)"5'6#*'4(,)/6"7 ;), S'%, )& L'7,% )" ;," K,*('";,)"\ 6"; #'//* ;), K,*(,//6"7 '6#7%6"; ,)",% K,*(,//'"#$%;,%6"7 `;,% W,%()76"7*'4(,)/6"7a,%#$/7(,? *$ Q)%; *), '6=> %,*,%8),%(I
! B)"; '//, K,*(,//.$*)()$"," R6 ,)",% K,*(,//'"#$%;,%6"7 '& L'7,%? 4,"'=>%)=>()7( ;),P)"5'6#*'4(,)/6"7 ;), W,%()76"7*'4(,)/6"7 ,"(*.%,=>,";I
! N6U,%;,& .%T#( ;), P)"5'6#*'4(,)/6"7 8$" ̂ ,)( R6 ^,)( ;), L'7,%4,*(H";, '6# G"(,%*=>%,)(6"7;,* :)";,*(4,*('";* 6"; )")()),%( 77#I ;'"" '6=> 8$" *)=> '6* K,*(,//6"7,"I
Y J"&6&c d
Y J"&6&c
Y @&&-6.2&
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0D
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
! P)" J,%*'";'6#(%'7 4,R),>( *)=> *(,(* '6# ,)"," -6";,"'6#(%'7 6"; )*( ,)", N"Q,)*6"7 ;,% N6#(%'7*4,'%4,)(6"7 '" ;), J,%*'";'4(,)/6"7? ;), )& -6";,"'6#(%'7'6#7,#T>%(," N%()5,/ )" ;,% '"7,7,4,"," :,"7, '" ;," -6";," R6 8,%*,";,"I
! P)" J,%*'";'6#(%'7 Q)%; 8$" ;,% J,%*'";'4(,)/6"7 Q), #$/7( 4,'%4,)(,(1
! 3), J,%*'";'4(,)/6"7 #'**( "'=> P)"7'"7 ;,* J,%*'";'6#(%'7* ;), S'%,.>+*)*=> '6* ;,& L'7,% '6*? *(,//( ;), S'%, R6*'&&," 6"; $%7'")*),%( ;,"M%'"*.$%( R6& -6";,"I
`3), N6*46=>6"7 '6* ;,& L'7,%4,*('"; Q6%;, 4,%,)(* 8$" ;,% N6#(%'7*4,'%4,)(6"7 ;6%=>7,#T>%(Ia
! 3,% J$//R67 ;,% N6*/),#,%6"7 Q)%; 8$" ;,% J,%*'";'4(,)/6"7 '" ;),K6=>>'/(6"7 7,&,/;,(? ;), ;'%'6#>)" ;), <,=>"6"7**=>%,)46"7 '"*(gU(\
! 3'&)( )*( ;), N6#(%'7*4,'%4,)(6"7 '47,*=>/$**,"I
f,;# 52 1%?-/"<
t G/;#"2"3 1 S)%; ")=>( )" ;),*,& P<@ZB+*(,&8,%Q'/(,(
t P-/6:%6:&/ 1 :6** "$=> ,%7H"R( Q,%;,"
M+.)*=>,%Q,)*, Q)// &'" )" 4,(%),4/)=>," !B 6I'I '6=> Q)**,"? R6 Q,/=>,& ^,)(.6"5(
Q,/=>, N5()$"," '"7,*($U," $;,% '47,*=>/$**," Q6%;,"I
S)% ,%7H"R," ;'>,% 6"*,%, ,%&)((,/(," P"()(),* "$=> 6& ,)" .''% R6*H(R/)=>, N((%)46(,
Y J"&6&c d
Y J"&6&c
Y @&&-6.2&
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 16/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0E
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
+/->/6"/-2"3 g J-3?"52"3 8/- J"&6&6/:
! P%&)((,/(, P"()(),* `EI P"(Q6%#a1 J-3?"52"3/"
! -6";, -;[%? -;['&,? -;B(';(? K$")(H(
! N6#(%'7 N6#(%[%? -;[% Q N6#(%3'(6&? P%#'**6"7*;'(6&? N6#(%B('(6*? 4346/>/-2"3Q @2>&-@"R/-&632"3Q R/-&632"3O//"8/&QE$-/@2:%6/>O/-/6&Q @2:%6/>M$&20Q G/;#"2"3::&$&2:QG/;#"2"3:8$&20Q a$#%2"3:/6"3$"3
! N6#(%'7*@$* N6#(%[%? N6#(%@$*? M,)/,[%? N"R'>/? J5@%,)*? @"5Re-F2"8/G/:/-W6/-&Q@"5f,;#a2R/-&63/"
! L),#,%'"( L),#[%? L),#['&,? L),#B(';(? K,Q,%(6"7
! K,*(,//6"7," K,*([%? K,*(3'(6&? B('(6*? E$-/J-#$%&/"Q 43a23$"3L/.2;#&
! K,*(,//@$* K,*([%? K,*(@$*? M,)/,[%? N"R'>/
! M,)/, M,)/,[%? K,*('";? %,*,%8),%( ? :)"K,*('";? F$%1F,:&/"
! W,%()76"7*'6#(%'7 W'[%? N6#(%[%? J6"3$"3:8$&20Q R/-&632"3O//"8/&
! W,%()76"7*'6#(%@$* W'[%? W'@$*? M,)/,[%? N"R'>/^6W,%()7,"? R/-&632"3:=&$&2:QO/:&@">,-8L/:&$-&/&Q O/:&@">,-8J-%/863&Q R/-&632"3L/:&$-&/&QR/-&632"3J-%/863&
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0C
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('() J-06&&%2"3 8/- J"&6&6/: X>e- -/%$&6,"$%/" MObJ"&92->Z
J-3?"52"3/"
! K,*(,//'"#$%;,%6"7 K'[%? W'[% Q O/:&J-%/863&M$&20
! K,*(,//N"#$%;@$* K'[%? K'@$*? M,)/,[%? N"R'>/ ? K,*([%? K,*(@$*
! L),#,%( L),#[%? M,)/,[%? @%,)*
! J,%*'";'6#(%'7 J'[%? N6#(%[%? E$-/@2:%6/>O/-/6&Q @2:%6/>M$&20
! J,%*'";'6#(%@$* J'[%? J'@$*? M,)/,[%? N"R'>/
! @%,)*/)*(, M,)/,[%? @%,)*
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 17/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 00
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(N H./-%/32"3/" 52- @..6%82"3 W," J"&6&6/: $2> G/%$&6,"/"
! P%7H"R(, P"()(),*1
N6#(%'7 N6#(%[%? -;[% Q N6#(%3'(6&? P%#'**6"7*;'(6&? N6#(%B('(6*? L7L),#,%6"7? N6#(%N"W,%()76"7? W,%()76"7K,,";,(? S'%,N6*/),#K,%,)(? N6*/),#3'(6&?
<,=>"6"7**('(6*? <,=>"6"7*;'(6&? ^'>/6"7*,)"7'"7
N6#(%'7*@$* N6#(%[%? N6#(%@$*? M,)/,[%? N"R'>/? J5@%,)*? N"RWT%-6";,<,*,%8),%(? N"R[$=>^6W,%()7,"
W,%()76"7*'6#(%'7 W'[%? N6#(%[% Q P)"7'"7*;'(6&? W,%()76"7K,,";,(
W,%()76"7*'6#(%@$* W'[%? W'@$*? M,)/,[%? N"R'>/^6W,%()7,"? W,%()76"7*B('(6*?K,*(N"#$%;O,*('%(,(? K,*(N"#$%;P%/,;)7(? W,%()76"7O,*('%(,(?W,%()76"7P%/,;)7(
J,%*'";'6#(%'7 J'[%? N6#(%[%? S'%,N6*/),#K,%,)(? N6*/),#3'(6&
J,%*'";'6#(%@$* J'[%? J'@$*? M,)/,[%? N"R'>/
! @%&/-"$&6W/ )< M6-/1&/ 70:/&52"3Q 8(#( !0A%/0/"&6/-2"3 W," ` G/%$&6,"/"
! P,:6&6W< F,--/:A,"8/"5 596:;#/" G/%$&6,"/" 2"8 J"&6&6/: 2"06&&/%.$- :6;#&.$-
! f/3$&6W< G/82"8$"&/ =A/6;#/-2"3 W," !">,-0$&6,"Q $2>9/"863/-/ F,":6:&/"&#$%&2"3
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(N H./-%/32"3/" 52- @..6%82"3 W," J"&6&6/: $2> G/%$&6,"/"
! @%&/-"$&6W/ N< a2:$00/">$::2"3 %,36:;#/- G/%$&6,"/"
O/,.$;#&2"3<
N6#(%'7 N6#(%[%? -;[% Q N6#(%3'(6&? P%#'**6"7*;'(6&? N6#(%B('(6*? L7L),#,%6"7? N6#(%N"W,%()76"7? W,%()76"7K,,";,(? S'%,N6*/),#K,%,)(? N6*/),#3'(6&?<,=>"6"7**('(6*? <,=>"6"7*;'(6&? ^'>/6"7*,)"7'"7
N6#(%'7*@$* N6#(%[%? N6#(%@$*? M,)/,[%? N"R'>/? J5@%,)*? N"RWT%-6";,<,*,%8),%(? N"R[$=>^6W,%()7,"
W,%()76"7*'6#(%'7 W'[%? N6#(%[% Q P)"7'"7*;'(6&? W,%()76"7K,,";,(
W,%()76"7*'6#(%@$* W'[%? W'@$*? M,)/,[%? N"R'>/^6W,%()7,"? W,%()76"7*B('(6*?K,*(N"#$%;O,*('%(,(? K,*(N"#$%;P%/,;)7(? W,%()76"7O,*('%(,(?W,%()76"7P%/,;)7(
J,%*'";'6#(%'7 J'[%? N6#(%[%? S'%,N6*/),#K,%,)(? N6*/),#3'(6&
J,%*'";'6#(%@$* J'[%? J'@$*? M,)/,[%? N"R'>/
<,/'()$"," E?C 6"; 0 5g""," '/* B.,R)'/)*),%6"7," ,)",* 7,&,)"*'&," `'4*(%'5(,"a B6.,%(+.*
'6#7,#'**( Q,%;,"\ *), %,.%H*,"(),%," 6"(,%*=>),;/)=>, ^6*(H";, ,)",* N6#(%'7*v &g7/)=>, `.>+*)*=>,a B.,)=>,%6"7 )" ,)",% <,/'()$"
N"'/$71 <,/'()$"," ]? F 6"; dI N6=> >),% &g7/)=>, B.,)=>,%6"7 )" ,)",% `.>+*)*=>,"a <,/'()$"I
E
C
0
]
F
d
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 18/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0F
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(N H./-%/32"3/" 52- @..6%82"3 W," J"&6&6/: $2> G/%$&6,"/"
J6":;#2.< @..6%82"3 W," !=@bO/56/#2"3/"
!
!"#$%&'() *+),-#.+
/$%+)012+345
6'50(2)05 8 6'50(2)05 8 6'50(2)05 89:)+2';4)+9 9/$%+)012+3459 9<)$%3"02)+9
=;#5'"-0(
>)+#?+ ?3,) !-+)##) !15 @)%3&5
<)$%3"02)+
AB/C&& ABD#5
:)+2';4)+
<053+1)05)+
A A A
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0d
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(N H./-%/32"3/" 52- @..6%82"3 W," J"&6&6/: $2> G/%$&6,"/"
J6":;#2.< @..6%82"3 W," !=@bO/56/#2"3/"
! !"&/-"/ G/$%6:6/-2"3:$%&/-"$&6W/" 60 1%$::6:;#/" G/%$&6,"/"bV,8/%%
EI B6.,%(+. 6"; B64(+.," Q,%;," f,Q,)/* '/* "%&"(" 3"*-$%1("( 415"**%"#$ I
3,% B=>/T**,/ ;,* B6.,%(+.* Q)%; '/* W%,&;*=>/T**,/ )" ;," B64(+.," 8,%Q,";,(I
v 3%,) h,6"b+6/9:? 6& /$7)*=>, <,/'()$"," J,%5H6#,%? B=>%,)45%'#( $;,% :,=>'")5,% R6 %,'/)*),%,"
CI B6.,%(+. 6"; '//, B645/'**," Q,%;," )" ,)",% &"4"%()-4"( `7%$U,"a 3"*-$%1(
R6*'&&,"7,#'**(\ ,8(/I 5'"" ,)" 3)*5%)&)"'($%ZN((%)46( ;), T4,%"$&&,", <$//,%,.%H*,"(),%,"I
v J),% P-,K/;&6,"b+6/9: #T% ;), /$7)*=>," <,/'()$"," *$Q), 6'**7"#$" #T% ;), f,Q,)/* ")=>( 4,/,7(," N((%)46(,
:)('%4,)(,%`@,%*[%? ['&,? N;%,**,? N4(? O,>'/(aJ,%5H6#,%`@,%*[%? GB$//? G!*(a
B=>%,)45%'#(`@,%*[%? N"*=>/H7,? W%,&;*.%a
:,=>'")5,%`@,%*[%? ^6*(H";)7a
:)('%4,)(,%`@,%*[%? ['&,? N;%,**,? N4(? O,>'/(? MH()75,)(? GB$//? G!*(?
N"*=>/H7,? W%,&;*.%? ^6*(H";)7a
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 19/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0e
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(N H./-%/32"3/" 52- @..6%82"3 W," J"&6&6/: $2> G/%$&6,"/"
J6":;#2.< @..6%82"3 W," !=@bO/56/#2"3/"
! !"&/-"/ G/$%6:/-2"3:$%&/-"$&6W/" 60 1%$::6:;#/" G/%$&6,"/"bV,8/%%
0I 3,% 8'9"#$:9 Q)%; (%/0$ )"9-#-$ 415"**%"#$ I B('((;,**," Q,%;," ;,**," N((%)46(, f,;,& B64(+. >)"R67,#T7( `7,>( "6% 4,) ;)*f6"5(,% ($('/,% ^,%/,76"7 )" B645/'**,"aI
v ;:9<=')-44"(0-(& &"0$ >"#*1#"(, ,)", 7f!]fb+6/9 R6% <,'/)*),%6"7 ,)",%O,*'&(*)=>(
! G/$%6:6/-2"3:$%&/-"$&6W/ 60 ,.K/1&-/%$&6,"$%/" CcAb=c:&/0 W," =i4<w J,%,%46"7*>),%'%=>)," ;)%,5( ;'%*(,//4'% ` [GJ@CJ CjPJ $:9(-4"XI 7fMJG Xa
w [GJ@CJ C@O4J &").'/" ]R $:9(-4" X
w c4,% )"(,%", <,'/)*),%6"7 `*),>, $4,"a ,"(*=>,);,( ;,% Y,%*(,//,%
X>e- M/&$6%: :6/#/ +,-%/:2"3 SM$&/".$"1:c:&/0/T X,8/- MO=b4/#-.e;#/-ZZ
J,%5H6#,%`@,%*[%? ['&,? N;%,**,? N4(? O,>'/(? GB$//? G!*(a
B=>%,)45%'#(`@,%*[%? ['&,? N;%,**,? N4(? O,>'/(? N"*=>/H7,? W%,&;*.%a
:,=>'")5,%`@,%*[%? ['&,? N;%,**,? N4(? O,>'/(? ^6*(H";)7a
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0h
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(' G/$%6:6/-&/: =;#/0$ >e- 4/3,C-$6%/- @L
k 4,36:;#/ =6;#& k
C/6%
C/6%/&cA
@2>&-$3
@2>&-$3:bA,:6&6,"
O/:&/%%2"3O/:&/%%bA,:6&6,"
R/-&632"3:b$2>&-$3
R/-&632"3:b$2>&-$3A,:6&6,"
F2"8/
+/-:$"8b$2>&-$3
+/-:$"8$2>&-$3bA,:6&6,"
O/:&/%%b$">,-8/-2"3
46/>/-$"&
G/;#"2"3
`E?xa
`E?Ea
`D?xa
`E?Ea
`E?xa
`D?Ea
`E?Ea`D?xa
`E?xa
`E?Ea
`E?Ea
`D?xa`D?xa
`D?xa
`E?Ea
`E?Ea
`D?xa
`E?xa
`D?Ea
`E?Ea
`D?Ea `E?Ea
`E?Ea
`D?xa
`D?Ea
`E?Ea
`E?Ea`D?Ea
`E?Ea
`E?xa`E?Ea
`D?Ea
`E?Ea
`E?Ea
`D?xa
`D?xa
`E?Ea
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 20/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, 0i
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
C/6%
C/6%/&cA
@2>&-$3
@2>&-$3:b
A,:6&6,"
O/:&/%%2"3O/:&/%%bA,:6&6,"
R/-&632"3:b$2>&-$3
R/-&632"3:b
$2>&-$3A,:6&6,"
F2"8/
+/-:$"8b$2>&-$3
+/-:$"8$2>&-$3bA,:6&6,"
O/:&/%%b$">,-8/-2"3
46/>/-$"&
G/;#"2"3
`E?xa
`E?Ea
`D?xa
`E?Ea
`E?xa
`D?Ea
`E?Ea`D?xa
`E?xa
`E?Ea
`E?Ea
`D?xa`D?xa
`D?xa
`E?Ea
`E?Ea
`D?xa
`E?xa
`D?Ea
`E?Ea
`D?Ea `E?Ea
`E?Ea
`D?xa
`D?Ea
`E?Ea
`E?Ea`D?Ea
`E?Ea
`E?xa`E?Ea
`D?Ea
`E?Ea
`E?Ea
`D?xa
`D?xa
`E?Ea
,'+$#-&)?8
,'+$#-&)@1)?8
;"%*"$:9"(
;"%*"
A%"+"#-($"(
B'(5"(
C")$"**,(+1#5"#'(&"(C")$"**'(&"(C")$"**@1)
k !0A%/0/"&6/-2"3 k
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]D
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(' G/$%6:6/-&/: =;#/0$ >e- 4/3,C-$6%/- @L
G/%$&6," @2>&-$3:M=
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 21/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]E
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]C
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
G/%$&6," @2>&-$3:P,:M= 3,(')/* *),>,
L,7$M%')/,%ZB=>,&'ZxI*y/
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 22/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
`W$%(*Ia
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 23/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]F
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'('(\ @-./6&/" 06& =6;#&/" X+6/9:Z
! N((%)46(, ;,% G/%$&6," @2>&-$3:M=
;'8$" `&)";,*(,"* a 4,"g()7(#T% P"()(+
@2>&-$3
R/-&632"3:$2>&-$3
+/-:$"8$2>&-$3
3), '";,%," !"#$%&'()$","5g""," 4,) K,;'%# ;6%=>!"*.,5()$" ;,% 4,);," '";,%,"P"()(),* ,%&)((,/( Q,%;,"
@2>&-f- l l l
F8f- l l
F8@2>&-f- l l
F8@2>&-M$&20 l
J->$::2"3:M$&20 l
4346/>/-2"3 l
@2>&-=&$&2: l l l
@2>&-@"R/-&632"3 l
@2>&-P,:!"@-./6& l
R/-&632"3O//"8/& l
E$-/@2:%6/>O/-/6& l
@2:%6/>M$&20 l
G/;#"2"3:=&$&2:
G/;#"2"3:M$&20
a$#%2"3:J6"3$"3
E
C
0
E C 0
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]d
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
! N((%)46(, ;,% G/%$&6,"@2>&-$3:P,:M=
! ;'8$" `&)";,*(,"*a 4,"g()7(#T% P"()(+
@2>&-$3:P,:
R/-&632"3:$2>&-$3:P,:
+/-:$"8$2>&-$3:P,:
@2>&-f- l l l
@2>&-P,: l l l
C/6%/!M l l l
R$-./ l l l
+1P-/6: l
@"5+,"F2"8/O/:&/%%& l l
@"5R2/-F2"8/G/:/-W6/-& l
@"5f,;#a2R/-&63/" l l
O/:&@">,-8J-:&/%%& X l Z
O/:&@">,-8J-%/863& X l Z
R/-&632"3L/:&$-&/& l
R/-&632"3O//"8/& l
R/-&632"3:=&$&2: l
!"&/-/::$"&<
J6"-6;#&/" W," =6;#&/"XSW6-&2/%%/ G/%$&6,"/"T >e-
z @2>&-$3:/->$::2"3
z @2>&-$3:./$-./6&2"3
z R/-&632"3:A%$"2"3
z m
v =i4 !!
E C 0
E
C
0
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 24/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]e
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
! J-3?"5/"8/ V$&/-6$%6/"X6"&/3-$%/- O/:&$"8&/6% W," +,-%( n H.(Z
4/3,C-$6%/-b=;#/0$bNo)^b3/>e%%&(:p%
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]h
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
! M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 25/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ]i
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
! J$%4,&,%56"7
! !" P%7H"R6"7 R6 ;," c46"7," )& W$/7,";," ,_,&./'%)*=>,
-$"5%,()*),%6"7 ,)")7,% N"Q,";6"7*#6"5()$"," ;,* P<@ZB+*(,&*;,% L,7$M%')/,% NO
! ^),/ )*(? 4,RT7/)=> 3'(,"4'"5'"#%'7," '/(,%"'()8, Lg*6"7," R6;)*56(),%," 6"; ;," N"Q,";6"7*"6(R," Q,)(,%#T>%,";,% BVLZW6"5()$"," '6#R6R,)7,"
! 3), Q,)(,%7,>,";," BVLZW6"5()$"," 4,>'";,/" Q)% ;'"" )&"H=>*(," -'.)(,/
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, FD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
! @2>&-$3:/->$::2"3
! R2"1&6,"$%6&?&< @"%/3/" @2>&-$3
! N"R,)7, ;,% 8$%>'";,"," -6";," R6% N6*Q'>/ ;,% F8f- `q ,8(/I :g7/)=>5,)( R6% [,6'"/'7,1 v R2"1&6,"$%6&?&< @"%/3/" F2"8/a
! J,%7'4, @2>&-f- Xv -'$14-$%)/0Z
! P%#'**6"7 F8@2>&-M$&20? F8@2>&-f- a
! R2"1&6,"$%6&?&< J->$::/" @2>&-$3:A,:6&6,"/"
! N"R,)7, ;,% @%$;65(, /'6( @%,)*/)*(, R6% N6*Q'>/ 8$" C/6%/!M? R$-./
! J,%7'4, @2>&-P,: Xv -'$14-$%)/0Z
! P%#'**6"7 @"5+,"F2"8/O/:&/%%&
! B,(R," @2>&-=&$&2:k D 6"; R/-&632"3:=&$&2: k ZE Xv K/9/6%: -'$14-$%)/0Z
! !0A%/0/"&6/-2"3<
! S), 7,Q$>"(1 P%#'**6"7*&'*5," q ![BP<M JNLGPB X
! =6""W,%%< MOb:/6&63/ +/-3$./ W," >,-&%$2>/"8/"
f200/-" 2"8 MJR@74CbE/-&/"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 26/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, FE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
! @2>&-$3:./$-./6&2"3
! R2"1&6,"$%6&?&< XJ-:&/Z O/$-./6&2"3 8/: /->$::&/" @2>&-$3:
! N"R,)7, ;,% ,%#'**(," N6#(%'7*;'(," 8$" N6#(%'7 [%I _ &)( L)*(,
;,% 4,'6#(%'7(," N%()5,/ `M,)/,!3? W'%4,a 6"; :,"7,
! -/'**)#)5'()$" ;,* N6#(%'7* '/* !'#"&'012&'# `v L7L),#,%6"7 k Ea$;,% 3"&2(#0.#4'012&'# `v L7L),#,%6"7 k Da Xv -'$14-$%)/0Z
! W'//* !'#"&'012&'# 1
w N6*46=>," @%$;65(, '6* K,*('"; `#T% '//, N6#(%'7*.$*)()$","a Xv -'$14-$%)/0Z
w !")()),%," J,%*'";'6#(%'7 `vN6#(%B('(6* k 0a Xv -'$14-$%)/0Z
! W'//* 5"(. !'#"&'012&'# 1
w <,*,%8),%," 8,%#T74'%, @%$;65(, )& L'7,%4,*('"; Xv -'$14-$%)/0Z
w WT% '//, @$*)()$"," ;,* N6#(%'7* #T% %,*(/)=>, @%$;65(, 6"; :,"7," ,)","7,&,)"*'&," W,%()76"7*'6#(%'7 ,%R,67," `q N6#(%B('(6* k Ea Xv -'$14-$%)/0Z
! !0A%/0/"&6/-2"3
1 &)((,/* 5$"8,"()$",//,% BVLZN"Q,)*6"7,"
1 N/(,%"'()8,"1 !(,%'()8,* j/),"(ZB,%8,%Z@%$7%'&& `juBZ@%$7%'&&a $;,% =i4bP-,5/82-
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, FC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
! =i4b@"9/6:2"3 >e-
F%$::6>61$&6," 8/: @2>&-$3: $%: A-&"#-'+$#-& Xq4346/>/-2"3 Y )Z,8/- !"#$%&'(&)-'+$#-& Xv 4346/>/-2"3 Y oZ Xv -'$14-$%)/0Z
! a6/%< O/:&6002"3Q ,. 4$3/-$2>&-$3 ,8/- "6;#& 06& /6"/- =i4b@.>-$3/
! 703$"3::A-$;#%6;#/ R,-02%6/-2"3 8/- @2>3$./<
6(. *012&'# (42 "(. !'#"&'012&'# #".'0 7'..8 9".. 1:& '))" 4"(." *012&'#4;$4(2($.". '))" *&2(5")
(. 7"& #"9:.4<=2". *.>'=) (/ ?"&1:#@'&". A"42'.7 ".2=')2". 4(.7B
! J-:&/- X"$6W/-Z @":$&5<
A"42(//" >0.C<=42 '))" *&2(5");$4(2($.".8 1:& 9")<=" 7("4" A"7(.#0.# "&1:))2 (42B
=J4J[C $(@2>&-P,:Q $(C/6%/!MQ $(R$-./
RG]V @2>&-$3:P,:M= @= $ h]!f C/6%/ @= &]f X$(C/6%/!M Y &(C/6%/!MZ @fM X$(R$-./ Y &(R$-./Z
EUJGJ $(@2>&-f- Y )^ @fM$(@"5+,"F2"8/O/:&/%%& rY X&(O/:&$"8 b &(G/:/-W6/-&Z
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 27/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, F0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
E6- 0e::/" 86/ :, /-#$%&/"/ V/"3/ 06& 8/- V/"3/ $%%/- @2>&-$3:A,:bC2A/% W/-3%/6;#/"(
:)( Q,/=>,% BVLZn.,%'()$" 5'"" &'" .%T#,"? $4 :,"7,E " :,"7,C 7)/(r Jl[JPC
-$&./,((, N"#%'7,1
=J4J[C@2>&-P,:Q C/6%/!MQ R$-./
RG]V @2>&-$3:P,:M=
EUJGJ @2>&-f- Y )^Jl[JPC
=J4J[C m( X:6/#/ W,-#/-63/ i2/-cZ
O/86"32"3 "6;#& >e- $%%/@2>&-$3:A,:( /->e%%&v 1/6" S4$3/-$2>&-$3T
S), Q)**," Q)%? $4 ;),* '//, N6#(%'7*.$*)()$"," *)";r
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, F]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
P-,.%/0<Sf$6W/T @">-$3/>,-02%6/-2"3>e#-& 52 /6"/- 1,0A%/s/"@">-$3/./$-./6&2"3
=i4b@2:>e#-2"3:A%$" W,"!OV MON >e- ,.63/ @">-$3/
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 28/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, FF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
! 703$"3::A-$;#%6;#/ R,-02%6/-2"3 8/- @2>3$./<
6(. *012&'# (42 "(. !'#"&'012&'# #".'0 7'..8 9".. 1:& '))" 4"(." *012&'#4;$4(2($.". '))"
*&2(5") (. 7"& #"9:.4<=2". *.>'=) (/ ?"&1:#@'&". A"42'.7 ".2=')2". 4(.7B
! @%&/-"$&6W/- @":$&5< `v oO,7,"4,)*.),/pa
6(. *012&'# (42 "(. !'#"&'012&'# #".'0 7'..8 9".. D
,* 5,)", N6#(%'7*.$*)()$" 7)4(? Q,/=>, ;), K,;)"76"7 ")=>( ,%#T//(
P"(*.%,=>,";, BVLZN"#%'7,1
@">-$3/ ) 06& 3/?"8/-&/- EUJGJbO/86"32"3<
m
EUJGJ $(@2>&-f- Y )̂ @fM
$(@"5+,"F2"8/O/:&/%%& t X&(O/:&$"8 b &(G/:/-W6/-&Z
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Fd
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
=i4b@2:>e#-2"3:A%$" W,"!OV MON >e- $%&/-"$&6W/ @">-$3/
R$56&<
R,-02%6/-2"3 8/- =i4b@">-$3/ 2(7( "6;#& S/3$%T
N"&,%56"71
3KC ̀ Q), '6=> '";,%, Y$=>/,)*(6"7*ZBVLZ3K:Ba #T>%( *+*(,&*,)()7 ,)", *$7I *.1&'#"$;2(/("&0.# ;6%=>? 4,) ;,% ;), N"#%'7, 6IGI )" ,)", *,&'"()*=>Hy6)8'/,"(,? f,;$=> *=>",//,%'6*#T>%4'%, N"#%'7, 6&#$%&6/),%( Q)%;I
3), OT(, ;,% n.()&),%6"7 )*( '4>H"7)7;'8$"? $4 6"; )" Q,/=>,& G&#'"7 ;,&3K:B B('()*()5;'(," T4,% ;),4,(%$##,"," <,/'()$"," R6% J,%#T76"7*(,>," *$Q), Q,/=>,% n.()&),%6"7*/,8,/,)"7,*(,//( )*(I
WT% &,>% !"#$%&'()$"," >),%R6 *),>,L,>%4T=>,% R6 3K:B *$Q), ;),J$%/,*6"7," o3'(,"4'"5*+*(,&,p 6";o3'('4'*, !"(,%"'/*pI
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 29/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Fe
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(\ !0A%/0/"&6/-2"3 W," @"9/"82"3:>2"1&6,"/"
! R/-&632"3:W,-./-/6&2"3! R2"1&6,"$%6&?&< XJ-:&/Z O/$-./6&2"3 8/: /-#$%&/"/" R/-&632"3:$2>&-$3/:
! N"R,)7, ;,* ,%>'/(,"," W,%()76"7*'6#(%'7,* &)( L)*(, ;,%
>,%R6*(,//,";," @%$;65(, `M,)/,!3? W'%4,? N"R'>/a
! K,%,=>"," ;,* M,)/,4,;'%#* #T% f,;, @$*)()$" ;,* W,%()76"7*'6#(%'7*`v B(T=5/)*(,"ZN6#/g*6"7sa Xv -'$14-$%)/0Z
! @%T#6"7 #T% f,;, @$*)()$" ;,* W,%()76"7*'6#(%'7*? $4 '//, P)"R,/(,)/,`7,&HU B(T=5/)*(,"'6#/g*6"7a 5$&./,(( '& L'7,% 8,%#T74'% *)";Xv -'$14-$%)/0Z
! W'//* f'? N6*#'**," ;,% M,)/, 6"; N"*($U," ;,% W,%()76"7 #T% ;),*,@$*)()$" Xv -'$14-$%)/0Z
! W'//* ",)"? P%R,676"7 ,)",% K,*(,//'"#$%;,%6"7 #T% ;),*, @$*)()$"Xv -'$14-$%)/0Z
! !0A%/0/"&6/-2"3
1 &)((,/* 5$"8,"()$",//,% BVLZN"Q,)*6"7,"
1 N/(,%"'()8,"1 !(,%'()8,* juBZ@%$7%'&& $;,% BVLZ@%$R,;6%
1 N/(,%"'()8,"1 !(,%'()8,* juBZ@%$7%'&&?BVLZ@%$R,;6% &)( )(,%'()8,% B(T=5/)*(,"'6#/g*6"7 $;,% -/12-:6W/ =i4b@.>-$3/
H>"/)=>,BVLZ N"#%'7,Q), 8$%>,%
v =i4 !!
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Fh
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
! M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 30/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, Fi
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(^ F,":6:&/"&/-#$%&2"3:$:A/1&/
! J6">e#-2"3! P=>(, P<@ZB+*(,&, 4'*),%," >H6#)7 '6# ('6*,";," 8$" M'4,//,"
! K,)*.),/ BN@ <u01
!" ;,% B('";'%;5$"#)76%'()$" #'*( EDDIDDD M'4,//,"? f, "'=> N6#4'6 6";B(%65(6% 5g""," ,* '6=> 4)* R6 EFDIDDD M'4,//," *,)"{ V6,//,1 :'%()" ̂ '";,%1 3), M'4,//," )" BN@ <u0? CDDh? QQQI_)"_) )I=$&|
! ^Q)*=>," ;),*," M'4,//," 4,*(,>," 8),/#H/()7, N4>H"7)75,)(,"
! o5/'**)*=>,p <,#,%,"R4,R),>6"7,"
! %,;6";'"( 7,*.,)=>,%(, !"#$%&'()$" `RIKI ")=>(Z'77%,7),%( q '77%,7),%(a
! -$"#)76%'()$"*4,R),>6"7," `S'>/ ;,% B.%'=>,? ;,% SH>%6"7? ;,% ^,)(R$",? Xa
! X
! W%'7,1 S), -$"*)*(,"R 7,QH>%/,)*(,"r
! N/(,%"'()8,"1! -,)", 3K:BZ*,)()7, -$"*)*(,"R*)=>,%6"7
! 3K:BZ*,)()7, o.'**)8,p -$"*)*(,"R*)=>,%6"7
! 3K:BZ*,)()7, o'5()8,p -$"*)*(,"R*)=>,%6"7
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, dD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(^ F,":6:&/"&/-#$%&2"3:$:A/1&/
! F/6"/ MOV=b:/6&63/ F,":6:&/"5:6;#/-2"3
! 3), -$"*)*(,"R*)=>,%6"7 )*( '//,)" B'=>, ;,% N"Q,";6"7*Z 6";B+*(,&.%$7%'&&,
! K,)*.),/,1! S,"" ,)" N6#(%'7 7,/g*=>( Q)%;? &T**," ;6%=> ;'* N"Q,";6"7*.%$7%'&& `N@a '6=>
'//, R67,>g%)7," N6#(%'7*.$*)()$"," 7,/g*=>( Q,%;,"
! S,"" ,)" B=>/T**,/ZN((%)46( ,)",% <,/'()$" 7,H";,%( Q)%;? ;'* )" '";,%," <,/'()$","%,#,%,"R),%( Q)%;? &T**," 8$& N@ ;), ;$%()7," N((%)46(Q,%(, ,4,"#'//* 7,H";,%( Q,%;,"
! S,"" ,)" M6.,/ )" ,)", K,*('";*%,/'()$" ,)"7,#T7( $;,% ;$%( 7,/g*=>( Q)%;? #T% ;), )",)",% '";,%," <,/'()$" ,)" ^H>/,%Z $;,% B6&&,"#,/; '"7,/,7( Q6%;,? *$ &6** 8$& N@;,% ;$%()7, S,%( ,"(*.%,=>,"; 7,H";,%( Q,%;,"
! S,"" ;), B('";'%;ZSH>%6"7 8$" PG< '6# GB3 6&7,*(,//( Q)%;? ;'"" &T**," '//,S,%(, )" oSH>%6"7*#,/;,%"p 8$& N@ ,"(*.%,=>,"; 7,H";,%( Q,%;,"
! P%#$%;,%( ,_(%,& >$>, 3)*R)./)" 6"; B$%7#'/( *,)(,"* ;,% !&./,&,"(),%,% *$Q),,)", *,>% 76(, 3$56&,"('()$" '//,% N4>H"7)75,)(*4,R),>6"7,"
! K,) 7%$U," B+*(,& #'*( ")=>( 4,>,%%*=>4'% `8),/, M'4,//,"? 8),/, !&./,&,"(),%,%a
! X )"*4,*$";,%,? Q,"" N"Q,";,% *,/4*(*(H";)7 b";,%6"7," 8$%",>&," ;T%#,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 31/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, dE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(^ F,":6:&/"&/-#$%&2"3:$:A/1&/
! MOV=b:/6&63/ SA$::6W/T F,":6:&/"5:6;#/-2"3
! 3'* 3K:B .%T#(? $4 ;), N6*#T>%6"7 ;,% BVLZN"Q,)*6"7 ;), >)"(,%/,7(,
-$"*)*(,"R4,;)"76"7 ,%#T//(! O/6 ,)",& +/-:&,u Q)%; ;), =i4b@"9/6:2"3 52-e;13/96/:/"? ;I>I 8$" )>%
,8,"(6,// ;6%=>7,#T>%(, b";,%6"7," Q),;,% R6%T=57,*,(R( 6"; ,)"BVLZW,>/,%=$;, R6%T=57,7,4,"
! V6&&/%<
! j<PNMP MNKLP X <PWP<P[jPB X { n[ 3PLPMP <PBM<!jM |
! j<PNMP MNKLP X <PWP<P[jPB X n[ G@3NMP <PBM<!jM
! j<PNMP MNKLP X jYPj- ̀ XIa
! j<PNMP NBBP<M!n[ X jYPj- `Xa! j<PNMP J!PS X S!MY jYPj- n@M!n[
! j<PNMP M<!OOP< X
;,% 4,) ,)",& ,"(;,=5(," J,%*($U ,)", P_=,.()$" Q)%#(
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, dC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(^ F,":6:&/"&/-#$%&2"3:$:A/1&/
! MOV=b:/6&63/ S$1&6W/T F,":6:&/"5:6;#/-2"3
! 3'* 3K:B 8,%>)";,%( !"5$"*)*(,"R," ;';6%=>? ;'** ,* 4,) ,)",% b";,%6"7*$.,%'()$" '6# ,)",% M'4,//, *,/4*(*(H";)7 ;), ,"(*.%,=>,";," b";,%6"7*$.,%'()$"," '6# ;," o'4>H"7)7,"p M'4,//," ;6%=>#T>%(
! V6&&/%<
! j<PNMP MNKLP X <PWP<P[jPB X n[ 3PLPMP jNBjN3P
! j<PNMP MNKLP X <PWP<P[jPB X n[ G@3NMP jNBjN3P
! j<PNMP M<!OOP< X
! a2:$00/">$::2"3
! -$"*)*(,"(>'/(6"7 8$" 3'(," )" 7%$U," !B ,)", *,>% 7%$U, Y,%'6*#$%;,%6"7
! -$"*)*(,"R*)=>,%6"7 '//,)", &)((,/* N"Q,";6"7*.%$7%'&&," )*( #'>%/H**)7
! S$ )&&,% &g7/)=>? -$"*)*(,"R*)=>,%6"7 )"* 3K:B )"(,7%),%," `.'**)8 $;,%'5()8as
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 32/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, d0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
!
M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, d]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
!"#$%&
! N//7,&,)",*
! M%'"*'5()$"*5$"R,.(
! B,%)'/)*),%4'%5,)(*.%)"R).
! N//7,&,)",* R6% B+"=>%$")*'()$" ̀ j$"=6%%,"=+ j$"(%$/\ jja
! B.,%%8,%#'>%,"
! B+*(,&.6##,%Q'/(6"7 6"; L$77)"7
! W,>/,%4,>'";/6"7 `<,=$8,%+a
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 33/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, dF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! @%%3/0/6"/:
! =5/"$-6,! :,>%4,"6(R,%4,(%),4
! J,%*=>),;,", N"Q,";6"7*.%$7%'&&, `N@a 7%,)#," `/,*,"; 6"; *=>%,)4,";a'6# ;,"*,/4," 3'(,"4,*('"; R6
! },;,* N@ `7,"'6,%1 f,;, oJ,%4)";6"7p $;,% oB,**)$"pa Q)%; )& 3K:B '/*,)7,",% @%$R,** $;,% M>%,'; %,'/)*),%( 6"; 5$"56%%),%,"; `6& ;),*,/4,"<,*$6%=,"a '6*7,#T>%(
! N@ Q,%;," t '6* @,%#$%&'"R7%T";," t ")=>( >)"(,%,)"'";,%? *$";,%"T4,%/'..,"; '6*7,#T>%(
!
;I>I ;'* 3K:B &6** ,)"," :)_ '6* 3KZn.,%'()$"," 8,%*=>),;,",% N@'6*#T>%,"
! ['=>#$/7,"; >),%R6 ,)" K,)*.),/ X
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, dd
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/"2&5/- ) g @P) O/"2&5/- N g @PN O/"2&5/- " g @P"
=i4b=&0&)) =i4b=&0&N) =i4b=&0&")
i2/-c [,0A6%/- g !"&/-A-/&/-
QEEF {4|
% EE] {=|QEE0 {'|% EEC {4|
% EEE {'|
QCE] {>|% CE0 {>|% CEC {7|QCEE {#|
Q"E] {&|% "E0 {7|% "EC {'|% "EE {4|
MOV=b=;#/82%/-
M$&/".$"1
,/,&,"('%,3KZN5()$","
!".6(ZV6,6,*
o4/'=5 4$_p#T% 3K:B
QCEE {#|
% EEE {'|
% "EE {4|
P$-$%%/%/@2:>e#-2"3W," =i4b=&$&/0/"&:82-;# 8$: MOV=
L,7,";,1% )f5 k 5Z(,% <,';Z^67%)## 8$" BVLZB(&( f 8$" K,"6(R,% )Q)f5 k 5Z(,% S%)(,Z 6̂7%)## 8$" BVLZB(&( f 8$" K,"6(R,% )
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 34/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, de
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
QEEF {4|
% EE] {=|QEE0 {'|% EEC {4|
QCE] {>|
% CE0 {>|% CEC {7|
Q"E] {&|
% "E0 {7|% "EC {'|
O/"2&5/- ) g @P) O/"2&5/- N g @PN O/"2&5/- " g @P"
=i4b=&0&)) =i4b=&0&N) =i4b=&0&")
i2/-c [,0A6%/- g !"&/-A-/&/-
MOV=b=;#/82%/-
M$&/".$"1
,/,&,"('%,3KZN5()$","
!".6(ZV6,6,*
o4/'=5 4$_p#T% 3K:B
QCEE {#|
% EEE {'|% "EE {4|
P$-$%%/%/@2:>e#-2"3W," =i4b=&$&/0/"&:82-;# 8$: MOV=
L,7,";,1% )f5 k 5Z(,% <,';Z^67%)## 8$" BVLZB(&( f 8$" K,"6(R,% )Q)f5 k 5Z(,% S%)(,Z 6̂7%)## 8$" BVLZB(&( f 8$" K,"6(R,% )
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, dh
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! P-,.%/0/ g R-$3/:&/%%2"3/"
! S,/=>, '//,% &g7/)=>," T4,%/'..,";," N6*#T>%6"7," #T>%," R6,)",& 5$%%,5(," <,*6/('(r
! S'* >,)U( T4,%>'6.( o5$%%,5(,* <,*6/('(p 4,) 5$"56%%),%,";," b";,%6"7,"r
! S), ,%5,""( 6"; 8,%&,);,( &'" 6",%QT"*=>(, ̀ ;I>I ")=>(5$%%,5(,a N6*#T>%6"7*%,)>,"#$/7,"r
! S), 7,>( &'" &)( ")=>( 8$//*(H";)7 '6*7,#T>%(," b";,%6"7,"`RIKI Q,7," @%$7%'&&'44%6=> $;,% B+*(,&=%'*>a 6&r
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 35/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, di
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% )< P-,.%/0 8/- SW/-%,-/"3/3$"3/"/" v"8/-2"3/"T XS%,:& 2A8$&/:TZ
D"#$ %4E-'9$<
)9"%/0"#
@P)
D"#$ %4E-'9$<
)9"%/0"#
@PN
s
D"#$ -'+ E%($"#&#'(5<
)9"%/0"# N
N
="%$ N@E1/,*,`_a
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, eD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
O/6:A6/% )< P-,.%/0 8/- SW/-%,-/"3/3$"3/"/" v"8/-2"3/"T XS%,:& 2A8$&/:TZ
sN
N
N
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@P)
@PN
="%$ N@E1/,*,`_a
N@C1/,*,`_a
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 36/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, eE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
O/6:A6/% )< P-,.%/0 8/- SW/-%,-/"3/3$"3/"/" v"8/-2"3/"T XS%,:& 2A8$&/:TZ
sN
N
N
N n ' Y ^^
@PN
@P) D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
="%$ N@E1/,*,`_a
N@C1/,*,`_a
N@E1_ k _q0
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, eC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% )< P-,.%/0 8/- SW/-%,-/"3/3$"3/"/" v"8/-2"3/"T XS%,:& 2A8$&/:TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
sN
^
N n ^ Y w
w
="%$ N@E1/,*,`_a
N@C1/,*,`_a
N@E1_ k _q0
N@C1_ k _qF
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 37/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, e0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% )< P-,.%/0 8/- SW/-%,-/"3/3$"3/"/" v"8/-2"3/"T XS%,:& 2A8$&/:TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
="%$ N@E1/,*,`_a
N@C1/,*,`_a
N@E1_ k _q0
N@C1_ k _qF
N@E1*=>%,)4,`_a
^
^
w
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, e]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% )< P-,.%/0 8/- SW/-%,-/"3/3$"3/"/" v"8/-2"3/"T XS%,:& 2A8$&/:TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
^
="%$ N@E1/,*,`_a
N@C1/,*,`_a
N@E1_ k _q0
N@C1_ k _qF
w
N@E1*=>%,)4,`_a
N@C1*=>%,)4,`_a
w
J-3/."6:<
M6/ v"8/-2"3 W," @P) 6:& W/-%,-/"3/3$"3/"(
J: 36.& 1/6"/ :/p2/"56/%%/ @2:>e#-2"3:-/6#/">,%3/86/:/- P-,3-$00/Q 86/ 520 :/%./" G/:2%&$& >e#-/" 9e-8/(
J6"/" :,%;#/" J>>/1& ./5/6;#"/& 0$" $%: F*1)$ '95-$"GH
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 38/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, eF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% N< P-,.%/0 8/: S:;#02&563/" 4/:/":T XS86-&c -/$8TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
="%$ N@E1/,*,`_a
N
N
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ed
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% N< P-,.%/0 8/: S:;#02&563/" 4/:/":T XS86-&c -/$8TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
="%$ N@E1/,*,`_a
N
N@E1_ k _q0
N n ' Y ^^
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 39/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ee
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% N< P-,.%/0 8/: S:;#02&563/" 4/:/":T XS86-&c -/$8TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
="%$ N@E1/,*,`_a
N@E1_ k _q0
^
N@E1*=>%,)4,`_a
^
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, eh
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% N< P-,.%/0 8/: S:;#02&563/" 4/:/":T XS86-&c -/$8TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
="%$ N@E1/,*,`_a
N@E1_ k _q0
N@E1*=>%,)4,`_a
N@C1/,*,`_a
^
^
^
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 40/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ei
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
O/6:A6/% N< P-,.%/0 8/: S:;#02&563/" 4/:/":T XS86-&c -/$8TZ
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
D"#$ %4E-'9$<
)9"%/0"#
D"#$ -'+ E%($"#&#'(5<
)9"%/0"#
D"#$ %4E-'9$<
)9"%/0"#
@PN
@P)
s
="%$ N@E1/,*,`_a
N@E1_ k _q0
^
N@E1*=>%,)4,`_a
^
N@C1/,*,`_a
^
N@E1 ,..#'/0I
J-3/."6:<
M2-;# 8/" @..-2;# W," @P) #$& @PN 6"1,":6:&/"&/M$&/" 3/%/:/"(
7"&/- 8/- @""$#0/Q 8$:: @P) :/6"/ v"8/-2"3/"./6 @..-2;# 96/8/- -e;13?"363 0$;#&Q 36.& /: 1/6"/:/p2/"56/%%/ @2:>e#-2"3 86/:/- P-,3-$00/Q 86/520 :/%./" X4/:/bZJ-3/."6: >e#-/" 9e-8/(
M6/:/" J>>/1& "/""& 0$" F5%#$:#"-5GH
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! C-$":$1&6,":1,"5/A&! H./-%/32"3/"<
! 3,% K,"6(R,% *$//(, /$7)*=> R6*'&&,"7,>g%)7, n.,%'()$"," o5/'&&,%"p5g""," `v ;#-()-J$%1(aI
!
N_)$&1 !& P)"4,"6(R,%4,(%),4 T4,%#T>%( ,)", 8$//*(H";)7 '6*7,#T>%(,M%'"*'5()$" ;), 3'(,"4'"5 8$" ,)",& 5$"*)*(,"(," ^6*('"; )",)"," ",6," 5$"*)*(,"(," ^6*('";I
! @'%'//,/ '6*7,#T>%(, M%'"*'5()$"," *$//(," *$ 7,7,",)"'";,% )*$/),%(Q,%;,"? ;'** *)=> ;'* B+*(,& t '6* B)=>( ;,* N"Q,";,%* t Q), )&P)"4,"6(R,%4,(%),4 8,%>H/(I
! 3'* 3K:B *$//(, #T% M%'"*'5()$"," ,)" oN//,*Z$;,%Z")=>(*pZ@%)"R).7'%'"(),%,"I
! 3), b";,%6"7," ,%#$/7%,)=> '47,*=>/$**,",% M%'"*'5()$"," )" ;,% 3K
*$//(," '6=> ;6%=> ,)"," ,8,"(6,//," *.H(,%," B+*(,&=%'*> ")=>( 8,%/$%,"7,>,"I
! 3), /,(R(7,"'""(," ] W$%;,%6"7," #)";," *)=> )& *$7I ,KL?<@-#-5%&4- Q),;,%I
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 41/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! 3'* ,KL?<@-#-5%&4- #T% 3KZM%'"*'5()$","
! @($&)=)(+ II <,'/)*),%6"71 B+"=>%$")*'()$" q L$77)"7u<,=$8,%+
! [$"*)*(,"=+ II ,)", @%H&)**,
! !*$/'()$" II <,'/)*),%6"71 B+"=>%$")*'()$"
! M6%'4)/)(+ II <,'/)*),%6"71 L$77)"7u<,=$8,%+
! P)", M%'"*'5()$" Q)%; 8$& K,"6(R,% u N@ &)((,/* ;," BVLZN"Q,)*6"7,"
! []VV!C '47,*=>/$**," $;,% &)((,/*
! G]44O@[F x E]GF y '47,4%$=>," `6"; ;'&)( R6%T=57,*,(R(a
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! =/-6$%6:6/-.$-1/6&:A-6"56A
3), B=>%,)4ZuL,*,$.,%'()$"," .'%'//,/ /'6#,";,% M%'"*'5()$"," Q,%;," )" ;,% <,7,/T4,%/'..( '6*7,#T>%(I
r2[a] r1[a] r2[b] r1[b] r2[c]r1[c] w1[c] w2[c] w2[d]
J6"/ 0z3%6;#/ =;#/82%/ XY @2:>e#-2"3:-/6#/">,%3/Z<
N5()$"," M%'"*'5()$" MCr2[a] r2[b] r2[c] w2[c] w2[d]
N5()$"," M%'"*'5()$" MEr1[a] r1[b] r1[c] w1[c]T1:
T2:
R-$3/< E/%;#/ 8/- W6/%/" 0z3%6;#/" =;#/82%/: >e#-/" 52 /6"/0 :/0$"&6:;#1,--/1&/" J-3/."6:d
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 42/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, h0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
z M/>6"6&6," 'b)< =/-6$%6:6/-.$-1/6&:A-6"56A
P)", T4,%/'..(, N6*#T>%6"7 ;,% M%'"*'5()$"," ME? MC? III? M" )*( 5$%%,5( 7,"'6
;'""? Q,"" ,* &)";,*(,"* ,)", *,%),//, N6*#T>%6"7*%,)>,"#$/7, `o*,%),//,B=>,;6/,pa ;,% M%'"*'5()$"," ME? MC? III? M" 7)4(? ;),? '"7,Q'";( '6# ;,"*,/4," N6*7'"7*R6*('";? R6& *,/4," P%7,4")* #T>%(I
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, h]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! K,)*.),/1 3), B=>,;6/, 8$" 8$%>,% t )*( *), *,%)'/)*),%4'%r
Y)/#*&)((,/1 -$"*(%65()$" o;#-()-J$%1()<,.0M(&%&J"%$)&#-90p
! 3), -"$(," ;,* O%'.>," *(,//," ;), M%'"*'5()$"," ;'% 6"; ;), 7,%)=>(,(," -'"(,"
RQ)*=>," !>"," 4,*=>%,)4," ,)", 7,#6";,", J$%7H"7,%Z['=>#$/7,%ZK,R),>6"7I! B,)," $.E){_| 6"; $.Cf{_| n.,%'()$"," RQ,),% M%'"*'5()$"," ME 6"; MC )" ,)",%
B=>,;6/,? ;), 4,);, '6# n4f,5( _ R67%,)#,"I W'//* &)";,*(,"* ,)", 8$" 4,);,"*=>%,)4,"; '6# _ R67%,)#(? ;'"" *(,>," ;), 4,);," n.,%'()$"," %( B1(+*%J$ R6,)"'";,%I
! WT% '//, )" -$"#/)5( *(,>,";," n.,%'()$"," RQ,),% M%'"*'5()$"," ME 6"; MC 6"*,%,%B=>,;6/, B #T>%," Q)% ;'* W$/7,";, ;6%=>1 M%)(( $.E){_| 8$% $.Cf{_| )" B '6#? ;'""#T7," Q)% ;,& O%'.> ,)", -'"(, ME v MC >)"R6? '"*$"*(," ,)", -'"(, MC v ME
! !*( ;,% O%'.> R+5/,"#%,)? 5g""," Q)% &)((,/* ;,% $191*1&%)/0"( B(1$"()1#$%"#'(& ;), Hy6)8'/,"(, *,%),//, N6*#T>%6"7*%,)>,"#$/7, 4,*()&&,"I
r2[a] r1[a] r2[b] r1[b] r2[c]r1[c] w1[c] w2[c] w2[d]
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 43/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! K,)*.),/1 3), B=>,;6/, 8$" 8$%>,% t )*( *), *,%)'/)*),%4'%r
S)% '"'/+*),%,"1
r2[a] 1 5,)" -$"#/)5(
r1[a] 1 5,)" -$"#/)5(
r2[b] 1 5,)" -$"#/)5(
r1[b] 1 5,)" -$"#/)5(
r1[c] 1 )" -$"#/)5( &)( w2[c] 1 ME v MC
w1[c] 1 )" -$"#/)5( &)( r2[c] 1 ME v MC
r2[c] 1 '4 >),% 5,)", -$"#/)5(, &,>% &g7/)=>? "6% "$=> n.,%'()$"," 8$" MC
P%7,4")*1 t 3), B=>,;6/, )*( *,%)'/)*),%4'%?
t Hy6)8'/,"(, *,%),//, N6*#T>%6"7*%,)>,"#$/7,1 ME? MC
K,)*.),/ #T% ,)", "6;#&b:/-6$%6:6/-.$-/ =;#/82%/1 r1[a] r2[a] w1[a] w2[a]
r2[a] r1[a] r2[b] r1[b] r2[c]r1[c] w1[c] w2[c] w2[d]
ME
`-'"(, 4,%,)(* ,)"7,(%'7,"a
MC
ME MC
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hd
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
! @"0/-12"3/" 520 C-$":$1&6,":$.#?"3631/6&:3-$A#
! S,"" ;,% M%'"*'5()$"*'4>H"7)75,)(*7%'.> R+5/,"#%,) )*(? ;'"" )*( ;),R67%6";,/),7,";, B=>,;6/, ;,#)")()8 *,%)'/)*),%4'%I
! :'" 5'"" '//,%;)"7* o.'(>$/$7)*=>,p B=>,;6/,* 5$"*(%6),%,"? 4,) ;,"," Q), $4,";,#)"),%(, N4>H"7)75,)(*7%'.> ^+5/," '6#Q,)*(? ;), B=>,;6/, `"'=> ;,% 3,#)")()$"8$" B,%)'/)*),%4'%5,)(a f,;$=> (%$(R;,& *,%)'/)*),%4'% )*(I
K,)*.),/1 r1[x] r2[x] w1[x] w2[x] w3[x]
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
'4,% &)( ;),*,% N5()$" Q)%;'//,* Q),;,% o7,>,)/(p
3),* '//,)", QH%, ")=>( *,%)'/)*),%4'%
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 44/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, he
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! @%%3/0/6"/: 52- =c";#-,"6:$&6," X[,";2--/";c [,"&-,%B [[Z
! P)" B+"=>%$")*'()$"*8,%#'>%,"? Q,/=>,* ;'* B,%)'/)*),%4'%5,)(*.%)"R). *(%)5(
4,'=>(,(?! 7,QH>%/,)*(,( ;," >g=>*(," O%'; '" !*$/'()$" ;,% M%'"*'5()$","
7,7,",)"'";,% `" /$7)*=>,% P)"4,"6(R,%4,(%),4a
! )*( f,;$=> '& %,*(%)5()8*(," )" K,R67 '6# ;), R67,/'**,"," B=>,;6/,*
! 6"; #T>%( ;'&)( `.$(,"R),//a R6 ,)",& "),;%)7," O%'; '" @'%'//,/)(H(
! !" ;,% @%'_)* ;'>,% 4,) 8),/," B+"=>%$")*'()$"*8,%#'>%," ,)"*(,//4'%? Q,/=>,"O%'; '" !*$/'()$" ;), N"Q,";6"7 4,"g()7(
! 3,% BVLZB('";'%; *),>( 8$%? ;'** &'" #T% f,;, M%'"*'5()$" ;," 7,QT"*=>(,"!*$/'()$"*7%'; ,)"*(,//," 5'""
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hh
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
!:,%$&6,":3-$8/ 60 =i4b=&$"8$-8 2"8 8/-/" J>>/1&/
!:,%$&6,":3-$8/ { a23-6>>:0,82: J>>/1&/
J-%?2&/-2"31 `M_ k (%'"*'=()$"a
<,'; G"=$&&)((,; u3)%(+ <,'; 1 P)", M_ 5'"" b";,%6"7," '";,%,% M_ *,>,"? '6=> Q,"" ;),*,
"$=> 5,)" jn::!M 7,&'=>( >'(
<,.,'('4/, <,'; 1 P)" ,%",6(,* L,*," ;,%*,/4," M6.,/&,"7, R,)7( 5,)", ",6,"S,%(, #T% ;),*, M6.,/? ,* *,) ;,""? ;), M_ >'( ;),*, *,/4*(
7,H";,%(@>'"($&R,)/," 1 P)" "$=>&'/)7,* N6*#T>%," ,)",% L,*,'"Q,)*6"7 #g%;,%( 5,)",
",6," M6.,/ `o@>'"($&,pa R6('7,
G/$8 ]"%c G/$8bE-6&/ M6-&c G/$8 f,"-/A/$&$.%/G/$8
P#$"&,0b5/6%/"
G/$8 7";,006&&/8 h$ f/6" h$ h$ h$
G/$8 [,006&&/8 h$ h$ f/6" h$ h$
G/A/$&$.%/ G/$8 h$ h$ f/6" f/6" h$
=/-6$%65$.%/ h$ h$ f/6" f/6" f/6"
!:,%$&6,":3-$8
a23-6>>:0,82:
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 45/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, hi
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! K,)*.),/ R6& @>'"($&.%$4/,&1
N""'>&,"1
z G& o%,.,'('4/, %,';p R6 7,QH>%/,)*(,"? *.,%%( ,)", M_ '//, M6.,/? '6# ;), *), R67%,)#(? 6"; >H/(
;),*, B.,%%," 4)* R6 )>%,& M_ZP";,I 3), M6.,/ Q,%;," ;6%=> )>%, M!3 );,"()#)R),%(I
z 3'&)( *)"; ;), 8$" ;,% M_ 4)*/'"7 7,/,*,"," M6.,/ 7,7," b";,%6"7," '";,%,% M_ 7,*=>T(R(I
P)" &g7/)=>,% N4/'6#1 `KnM k 4,7)" $# (%'"*'=()$"? PnM k ,"; $# (%'"*'=()$"a
lKnM MEm=J4J[C -;[%? -;['&,RG]V -6";,"EUJGJ F8=&$8& Y |7%0|B
lKnM MCm~ '";,%, J,%'%4,)(6"7 • !f=JGC !fC] -6";,"~ ,8(/I G.;'(,* ,)"R,/",% M6.,/ • +@47J= `0DD? €:6*(,%&'""€? €:'_€? €G/&€? Da\
[]VV!CB lPnM MCm=J4J[C -;[%? -;['&,RG]V -6";,"EUJGJ F8=&$8& Y |7%0|B
3), 4,);," BVLZB('(,&,"(* #T>%," R6 6"(,%*=>),;/)=>,"P%7,4")**,"? $4Q$>/ *), f,Q,)/* )"",%>'/4 ,)",% M%'"*'5()$" `;I>I 8$" MEa '6*7,#T>%( Q,%;,"I
O%6";1 ME *.,%%( 4,)& L,*,R67%)## ;), R6 ;),*," ̂ ,)(.6"5(,_)*(),%,";," M!3*? MC ,%R,67( #T% ;'* ,)"R6#T7,";, M6.,/ f,;$=> ,)", ",6,I
^,)(
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, iD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! N"&,%56"7,"1
! 3'* B,%)'/)*),%4'%5,)(*.%)"R). )*( ;), #$%&'/, O%6";/'7, `o;,% <'>&,"p 4RQI ;),o:,**/'((,pa #T% ;), <,'/)*),%6"7 8$" 6")8,%*,// ,)"*,(R4'%,"B+"=>%$")*'()$"*8,%#'>%,"I
! 3), 8,%*=>),;,"," B+"=>%$")*'()$"*8,%#'>%," %,'/)*),%," ;),*,* @%)"R). R6& M,)/'6# *,>% 6"(,%*=>),;/)=>, S,)*,I
! N4,% f,;,* *$/=>, J,%#'>%," &6** ;," ['=>Q,)* #T>%," 5g""," `&)( oB'(R 6";K,Q,)*pa? "'=> Q,/=>,& -%)(,%)6& &'" f,;, 8$" )>& ,%R,674'%, B=>,;6/,oHy6)8'/,"( *,%)'/)*),%,"p 5'""I
! 3,% M%'"*'5()$"*'4>H"7)75,)(*7%'.> >)"7,7," )*( )& S,*,"(/)=>," ,)7,"(/)=> "6%#T% M>,$%),#%'7,*(,//6"7," )"(,%,**'"(
! S)% R,)7," ;), <,'/)*),%6"7 ,)",* B+"=>%$")*'()$"*8,%#'>%,"* '& K,)*.),/ 8$"89"##>"#+-0#"( &)( =7"%<@0-)"(<89"##9#1$1J1**
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 46/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, iE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! =A/--W/->$#-/"! @%%3/0/6"/:
! L,*,R67%)##, 4,/,7," ;'* 3KZn4f,5( &)( ,)",% 4/:/b=A/--/ XS:#$-/8 %,;1TZ?B=>%,)4R67%)##, &)( ,)",% =;#-/6.:A/--/ XS/s;%2:6W/ %,;1TZI
! 3), 3K:B 8,%Q'/(," )I;I<I #T% '//, M_ ,)", &"4"%()-4" 89"##$-."**"? )" Q,/=>,;), B.,%%," ,)"7,(%'7," 6"; '6* ;,% *), '& P";, ;,% M_ Q),;,% 7,/g*=>( Q,%;,"I
! OH"7)7, 89"##&#-('*-$" *)"; 8"%$"( N9-&"<*">"* *1/J%(&O $;,% ;'9"* N#17<*">"*
/$=5)"7a? 4,) K,;'%# Q)%; '6=> '6# >g>,%," P4,","? Q), ,(Q' <,/'()$" $;,%M'4/,*.'=, 7,*.,%%(I :'" *.%)=>( ;'"" '6=> 8$" 0%"#-#/0%)/0"( 89"##"(I
w P)", B.,%%, '6# <,/'()$"*,4,", )*( 4,) &'"=>," B.,%%8,%#'>%," RIKI ,%#$%;,%/)=>?6& )& !*$/'()$"*&$;6* o*,%)'/)R'4/,p ;'* .'%'//,/, P)"#T7," 8$" M6.,/" )" ;),*,<,/'()$" ;6%=> '";,%, M_ R6 8,%>)";,%"I
w P)" '";,%,% O%6"; #T% ,)", *$/=>, B.,%%, 5g""," R6 8),/, M6.,/Z $;,%B,)(,"*.,%%," ;,% M_ )" ,)",% <,/'()$" *,)"I 36%=> ;," P%Q,%4 ,)",% B.,%%, '6# ;,%T4,%7,$%;",(," P4,", `v 89"##<P)J-*-$%1( N*1/J ")/-*-$%1(O Q)%; &'" ;),*,Q),;,% /$*I
! S)%; )" ,)",% M_ '6# ,)" n4f,5( R6"H=>*( /,*,"; 6"; ;'"" *=>%,)4,"; R67,7%)##,"?*$ Q)%; ̀ #'//* &g7/Ia ,)", 89"##J1(>"#)%1( *>'%,; /$=5# ,_=/6*)8, /$=5;6%=>7,#T>%(\ ,* #)";,( 77#I '4,% )&&,% "6% ,)" oG.7%';,p ,)",% B.,%%, *('((I
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, iC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! !0A%/0/"&6/-2"3
! `^,"(%'/,a B.,%%('4,//, &)( B.,%%8,%Q'/(,% `L$=5 :'"'7,%a
! B.,%%8,%Q'/(,% u B.,%%('4,//, /),7," )" ,)",& FJ#%$%)/0"( ,.)/0(%$$G ,_5/6*)8,% ̂ 67%)## #T% ;), f,Q,)/)7, M_
! N"#%'7,4,'%4,)(6"7 %6#( B.,%%8,%Q'/(,% `/$=5 &'"'7,%a R6& N"#$%;,%" uW%,)7,4," 8$" B.,%%,"
! K,) [)=>(7,QH>%6"7 ;,% B.,%%, 8$%T4,%7,>,";, B6*.,";),%6"7 ;,%M%'"*'5()$" ;6%=> ;," B.,%%8,%Q'/(,% 4RQI ;," B=>,;6/,% ;,* 3K:B
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 47/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, i0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! M$: a9/6bP#$:/"b=A/--A-,&,1,%%
! [6% o)%7,";Q),p R6 B.,%%," %,)=>( ")=>(? 6& B,%)'/)*),%4'%5,)( R67,QH>%/,)*(,"I
! Y),%R6 4,"g()7( &'" ,)" o@%$($5$//p? ;'* %,7,/(? Q'"" B.,%%," '"7,#$%;,%(6"; Q'"" *), Q),;,% #%,)7,7,4," Q,%;," ;T%#,"I
! P)" *,>% Q,)( 8,%4%,)(,(,* @%$($5$// )*( ;'* =7"%<@0-)"(<89"##9#1$1J1** N$71<90-)" *1/J%(& 9#1$1/1**Q R@AO '6# ;,& RIKI '6=> ;), )" !K: 3KC%,'/)*),%(," B+"=>%$")*'()$"*8,%#'>%," 4'*),%,"I
! G/3/%"<
)( O/W,- /6"/ C-$":$1&6," $2> /6" ].K/1& 523-/6>&Q 02:: :6/ 86/:/:3//63"/& :A/--/"(
N( =,.$%8 /6"/ C-$":$1&6," /6"/ =A/--/ >-/63/3/./" #$&Q 8$-> :6/ 1/6"/9/6&/-/ =A/--/ 0/#- $">,-8/-"(
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, i]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
M$: a9/6bP#$:/"b=A/--A-,&,1,%% XR,-&:(Z
M+.)*=>,% J,%/'6# ,)",% M%'"*'5()$" &)( C@LZB+"=>%$")*'()$"1
7,*.,%%(,
n4f,5(,
^,)(B.,%%.>'*, W%,)7'4,.>'*,
F*1/J -**G<="%$9'(J$
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 48/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, iF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
M$: a9/6bP#$:/"b=A/--A-,&,1,%% XR,-&:(Z
E6/ /-36.& :6;# 86/ ?p26W$%/"&/ :/-6/%%/ @2:>e#-2"3:-/6#/">,%3/d
N"(Q$%(
t M6/:/- 96-8 82-;# 86/ S4,;1 $%%Tba/6&A2"1&/ 8/- Cs 8/>6"6/-&( t L%/6;#5/6&63/- S4,;1 $%%Tba/6&A2"1& >e- 59/6 C-$":$1&6,"/"
v 1/6" a23-6>>:1,">%61&Q :/-6/%%/ @2:>e#-2"3 -/%$&6W 52/6"$"8/- ./%6/.63
! a23-6>>:1,">%61&/ #T>%," R6% C*1/J%"#'(& ;,% M_ 6"; ;'&)( 77#I '6=> R6 M/$8%,;1:
7,*.,%%(,n4f,5(,
^,)(
C)CN
C'
C\
)( N( '( \(
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, id
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
+/-1%/002"3/" XM/$8%,;1:Z
! 36%=> ;'* *65R,**)8, N"#$%;,%" 8$" B.,%%," *$Q), ;6%=> B.,%%5$"8,%*)$"," 6"; t,*5'/'()$"," 5g""," S"#J*"44'(&"( `?"-5*1/J)a '6#(%,(,"
! 3,';/$=5* 5g""," "6% ;6%=> N44%6=> ,)",% )"8$/8),%(," M_ 4,>$4," Q,%;,"&T**,"? ;' *), *)=> ")=>( 8$" *,/4*( Q),;,% '6#/g*,"
! 3), 3K:B 4,(%,)4," ;,*>'/4 ,"(Q,;,% 3,';/$=5,%5,""6"7 $;,% 4%,=>," M_ '4?Q,"" *), R6 /'"7, '6# ,)", B.,%%, Q'%(," &T**," ̀ M)&,$6(aI
! S$4,) ,)" ,)"#'=>,% N44%6=> &,)*( ")=>( 7,"T7(I !" ;,% <,7,/ &T**," ;), P##,5(,;,% M_ )" ;,% 3K %T=57'"7)7 7,&'=>( Q,%;," ̀ v <$//4'=5\ *),>, *.H(,%aI
>'( 7,*.,%%(
O/6:A6/% >e- 5c1%6:;#/ SE$-&/&b$2>Tb=6&2$&6,"
&g=>(, R6*H(R/)=>*.,%%,"
Cs )
Cs N
Cs '
].K/1& s
].K/1& c
].K/1& 5
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 49/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ie
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
! J-1/""2"3 2"8 @2>%z:2"3 W," +/-1%/002"3/" XM/$8%,;1:Z
+,-3/#/":9/6:/<
EI N"'/+*, ;,% B.,%%('4,//, `Q,/=>, M_ Q'%(,( '6# Q,/=>, M_ Q,7,"B.,%%5$"#/)5(ra 6"; P%*(,//6"7 ,)",% oS'%(,(Z'6#pZ:'(%)_
CI P%&)((/6"7 8$" R+5/)*=>," S'%(,(Z'6#ZK,R),>6"7,"
0I N6#4%,=>," ;,* ^+5/6* ;6%=> N44%6=> ,)",% ;,% 4,(,)/)7(," M%'"*'5()$","
]I B6=>,? $4 "$=> Q,)(,%, ̂ +5/," 8$%/),7,"
FI W'//* 5,)", +̂5/," &,>% 8$%>'";,"? ;'"" #,%()7? '"*$"*(," Q,)(,% 4,) B=>%)(( 0
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ih
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
@.:;#%6/u/"8/ O/0/-12"3/" 52 =A/--W/->$#-/"
! N6#Q'"; #T% ;), J,%Q'/(6"7 ;,% B.,%%('4,//, )"=/I ̂ +5/,"*6=>, %,=>( ,%>,4/)=>I
! Y$=>,##)R),"(, !&./,&,"(),%6"7 ,%#$%;,%/)=>? ;' )" Y$=>/,)*(6"7**+*(,&," 6IGI&,>%,%, M'6*,"; N6#%6#, .%$ B,56";, *('((#)";,"I
! P)"#'=>,%, 3K:B *.'%," *)=> ;,*>'/4 $#(&'/* ;," !&./,&,"(),%6"7*'6#Q'"; #T%
;), ^+5/6**6=>, 6"; 4%,=>," ,)", M_ 4,) c4,%*=>%,)(," ,)",% 8$%7,7,4,","^,)(;'6,% ̀ F;%4" 1'$G a 4,) S'%(," '6# ;), O,QH>%6"7 ,)",% B.,%%, '4I
! B.,%%8,%#'>%," ,%/'64," ;), !&./,&,"(),%6"7 ;,% ,)"7'"7* 4,*=>%),4,","!*$/'()$"**(6#,"I S,"" o%,.,'('4/, %,';p ")=>( 7,#$%;,%( )*(? ;'"" 5g""," RIKI%,)", L,*,ZB.,%%," 4,%,)(* 8$% ;,& jn::!M Q),;,% #%,)7,7,4," Q,%;,"\ G.;'(,ZB.,%%," Q,%;," '//,%;)"7* 7%6";*H(R/)=> 4)* R6& jn::!MZ^,)(.6"5( 7,>'/(,"I
! P* ,_)*(),%," 5%>"#)" S-#%-($"( >1( 89"##>"#+-0#"(? RIKI )" J,%4)";6"7 &)(J,%*)$"*5$"R,.(,"IK,)& 3K:B n%'=/, RIKI ,%>'/(," L,*,(%'"*'5()$"," ,8(/I ,)", #%T>,%, J,%*)$",)",* M6.,/*? 6& -$"#/)5(, &)( .'%'//,/ /'6#,";," G.;'(,%" R6 8,%&,);,"I
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 50/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ii
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
=c:&/0A2>>/-9$%&2"3 2"8 4,336"3
z MOV=ba23-6>> $2> U6"&/-3-2"8:A/6;#/-
N//, B,)(,"R67%)##, *$Q), ;),J,%Q'/(6"7 ;,* Y)"(,%7%6";Z*.,)=>,%* #)";," T4,% ;),B+*(,&.6##,%8,%Q'/(6"7 *('((
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDD
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
=c:&/0A2>>/-W/-9$%&2"3
! ^Q)*=>,"*.,)=>,%6"7 >H6#)7 4,"g()7(,% B,)(," )& Y'6.(*.,)=>,%
! ^),/1 <,;6R),%6"7 ;,% N"R'>/ 8$" @/'((,"R67%)##,"
! [6% 7,H";,%(, B,)(," Q,%;," '6# @/'((, R6%T=57,*=>%),4,"
! M+.)*=>, B=>")((*(,//,"Zn.,%'()$","1
FIX ( PageNo, Intention, Adress )
UNFIX ( PageNo, Dirty? )
FLUSH ( PageNo )
! B,)(," Q,%;," &)( ̂ ,)(*(,&.,/ ̀ $;,% ̂ H>/,%a ;,* /,(R(," ̂ 67%)##* 8,%*,>,"
! c4/)=>, B,)(,",%*,(R6"7**(%'(,7),1 L<G `/,'*( %,=,"(/+ 6*,;a 4RQI J'%)'"(,";'8$"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 51/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
=;#-/6./" W," 4,3bM$&/":?&5/" X4,336"3Z
! @2>3$./" 8/- 4,336"3bF,0A,"/"&/<
EI @%$($5$//),%6"7 ;,% S,%(, 8$" B,)(,"? M6.,/" $;,% M6.,/ZN((%)46(," 8$% ;,%," b";,%6"7 ̀ v o4,#$%, )&'7,pa ;6%=> ;), M_ )" ,)",&T(51<A1&+%*"
CI @%$($5$//),%6"7 ;,% S,%(, 8$" B,)(,"? M6.,/" $;,% M6.,/ZN((%)46(," "'=>;,%," b";,%6"7 ̀ v o'#(,% )&'7,a ;6%=> ;), M_ )" ,)",& 3"51<A1&+%*"
! @2>3$./" 8/- =c:&/0A2>>/-W/-9$%&2"3<
w B)=>,%*(,//6"7? ;'** ;,% G";$ZL$7,)"(%'7 ,)",% M_ *(,(* 8$% ;,& G.;'(, ;,% 3KZB,)(, )"* L$7#)/, 7,*=>%),4," Q)%;
w B)=>,%*(,//6"7? ;'** '//, <,;$ZL$7,)"(%H7, ,)",% M_ )&<,;$ZL$7#)/, *(,>,"? 4,8$% ;,% M_ ;'* j$&&)( 4,*(H()7( Q)%;
! E$-20 86/:/- @2>9$"8d t S,)/ Y$=>/,)*(6"7*Z3K:B
w 4,%,)(* QH>%,"; ;,% N6*#T>%6"7 ,)",% M_ 6IGI 4,%,)(* ;,%," b";,%6"7," )"3K *=>%,)4," ̀ '";,%, M_ *,>," ;),*, '4,% Q,7," ;,% B.,%%," "$=> ")=>(a
w 4,) j$&&)( 5,)" ,%RQ6"7,",* B=>%,)4," )" ;), 3K 8$%",>&," &g=>(," 6";;,*>'/4 7,H";,%(, B,)(," "'=> j$&&)( 6IGI o"6%p )& B+*(,&.6##,% *(,>,"
F7#%$"<-0"-5G *1&&%(&
ND,AO
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
E-6&/b@#/$8b4,3bP-6"56A XD,A 9#%(/%9*"Z! oM%)=5p1 K,) f,;,% B,)(, )& B@ Q)%; 8,%&,%5(? )" Q,/=>,% L$7*,)(,
`v LB[? /$7 *,y6,"=, "6&4,%a ;), /,(R(, b";,%6"7 ,)"7,(%'7," Q6%;,
J$% f,;,% J,%;%H"76"7 ,)",% B,)(, Q)%; 7,.%T#(? $4 ;), L$7*,)(, 4,%,)(* o;%'6U,"p )*(
! K,)*.),/1
t 3), '5(6,//, L$7ZB,)(, 0hEC ,"(>H/( G.;'(,* ;,% B,)(," FE]h? ]]Ce? C0FF 6"; ehiiI
t 3),*, B,)(," ;T%#," )" ;),*,& W'// ,%*( ;'"" '6* ;,& B@ 8,%;%H"7( Q,%;,"? Q,""LB[ • 0hEC 7)/(? ;I>I Q,"" L$7ZB,)(, 0hEC 7,*=>%),4," Q6%;,I
t 3), B,)(," dFFi 6I CECC Q6%;,"")=>( 8,%H";,%( `)>% LB[ZP)"(%'7)*( /,,%a 6"; &T**," ;,*>'/4 )&J,%;%H"76"7*#'// '6=> ")=>(R6%T=57,*=>%),4," Q,%;,"I
t 3), B,)(," E0EE 6"; eFhhQ6%;," 8,%H";,%(? )>%, b";,Z%6"7," Q6%;," '4,% '6# 4,%,)(*7,*=>%),4,"," L$7ZB,)(,".%$($5$//),%(I 3'&)( 5g""," *),
4,) @/'(R4,;'%# f,;,%R,)( )" ;),3K R6%T=57,*=>%),4," Q,%;,"I
LB[ @[$ LB[ @[$
LB[ @[$
LB[ @[$
LB[ @[$
LB[ @[$
LB[ @[$
LB[ @[$
LB[
A1&)"%$"(
J,%Q'/(6"7*Z!"#$%&'()$" ,)7,"(/)=>,3'(,"*,)(,=c:&/0A2>>/-
'_)o
'w}o
'_)N
w_}} )'))
`^^} \\Nw
^)\_ w^__
N'^^ N)NN
'_)N
'_)N
'_)N
'_)N
E
E
C
C
0
0
]
]
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 52/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ED0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
R/#%/-./#$"8%2"3 XG/;,W/-cZ
! @2>3$./"
S),;,%>,%*(,//6"7 ,)",* 5$"*)*(,"(," 3KZ^6*('";,* "'=>
t M%'"*'5()$"*'44%6=> " ;#-()-/$%1( 3"/1>"#: NT(51O
t B+*(,&R6*'&&,"4%6=> ̀ RIKI Q7I B(%$&'6*#'//a " K#-)0 3"/1>"#:
t Y'%;Q'%,#,>/,%" '6# B.,)=>,%&,;)6& " U"5%- 3"/1>"#:
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, ED]
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
[-$:# G/;,W/-c
! S),;,%>,%*(,//6"7 ,)",* 5$"*)*(,"(," 3'(,"4'"5R6*('";,*? *$ ;'** ;'* W$/7,";, 7)/(1
! '//, b";,%6"7," ")=>( '47,*=>/$**,",% M%'"*'5()$"," ̀ NKn<M $;,% *$"*()7,% N44%6=>a *)"; ")=>( )" ;,% 3'(,"4'"5
! '//, b";,%6"7," '47,*=>/$**,",% M%'"*'5()$"," ̀ jn::!M ,%%,)=>(a *)"; )" ;,%3'(,"4'"5
! K,)*.),/ #T% j%'*> <,=$8,%+
!"
!
!
!
!
#
$
%
&
'()*+,-
./)*012
*
J->,-8/-%6;#/ G/;,W/-cbV$u"$#0/""$;# 8/0 =c:&/0$.:&2-5<
G[3n #T% ;), oJ,%/),%,%p1 M]? MF
<P3n #T% ;), oO,Q)"",%p1 ME? MC? M0
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 53/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDF
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
N6#7'4,"EI K,*()&&, ;," /,(R(," 7,*=>%),4,"," L$7Z3'(,"*'(R
CI K,*()&&, 6"8$//,";,(, M%'"*'5()$"," `oS"#*%"#"# pa1 KnM )" L$7;'(,)? 5,)" jn::!M
0I K,*()&&, 8$//,";,(, M%'"*'5()$"," `oV"7%(("# pa1 jn::!M )" L$7;'(,)]I L,*, L$7;'(,) %T=5QH%(*? ,%&)((/, ;), G[3nZL$7,)"(%H7, ;,% J,%/),%,% 6"; #T>%, &)( ;),*," ,)"G[3n ;6%=>\ 6"; RQ'% 4)* ;,% N"#'"7 ;,% L$7;'(,) ,%%,)=>( )*(I
FI L,*, 8$& N"#'"7 ;,% L$7;'(,) >,% 8$%QH%(*? ,%&)((/, ;), <P3n L$7,)"(%H7, ;,% O,Q)"",% 6";#T>%, &)( ;),*," ,)" <P3n ;6%=>I
N"&,%56"71 B=>%)((, C? 0? 6"; ] 5g""," 4,)& o<T=5QH%(*/,*,"p ̀ <SLa '6# ,)"&'/ ,%/,;)7(Q,%;,"I
S),r
!:& 8/- %/&5&/ J6"&-$3 /6"/- C-$":$1&6," 6" 8/- 4,38$&/6
b 8/- [,006&bG/;,-8Q 8$"" 3/#z-& :6/ 52 8/" SL/96""/-"T<
O/60 GE4 1z""/" $%%/ 6#-/ J6"&-?3/ .6: 520 O]CbJ6"&-$3 63",-6/-& 9/-8/"(
b /6" $"8/-/- G/;,-8 X7"8,bgG/8,ZQ 8$"" 3/#z-& :6/ 52 8/" +/-%6/-/-"<
O/60 GE4 1z""/" 86/ 7"8,: 3%/6;# $2:3/>e#-& 9/-8/"(
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDd
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
[#/;1A,6"&: X[P:Z
! <,=$8,%+ 4)* R6& N"#'"7 ;,% L$7;'(,) 8,%6%*'=>( "'(T%/)=> 6IGI ,)"," ,"$%&," N6#Q'";? ;' ;'"" #T% *,>% 8),/, M_ G[3n 4RQI <P3n ;6%=>7,#T>%( Q,%;," &6**I
! N4>)/#,1 P#W"'&'(& >1( K@) X E"#-')W7%(&"( >1( 8"%$"( -') 5"4 8:)$"49'++"#
! ^Q,=51 G[3nZu<P3nZN6#Q'"; )& <,=$8,%+#'// 4,7%,"R,"
! [#/;1A,6"&1 ^,)(.6"5(? R6 ;,& 4,*()&&(, N""'>&," T4,% ;," ^6*('"; ;,% 3K7,&'=>( Q,%;," 5g"","I
! [PbJ6"&-$3 6" 86/ 4,38$&/6<
t !3* ;,% ")=>( '47,*=>/$**,"," M_
t J,%Q,)* '6# /,(R(," L$7;'(,"*'(R ;),*,% M_
! +/->$#-/":9/6:/"<
t S,"" 5,)", M%'"*'5()$" '5()8 )*( " $#-()-J$%1()J1()%)$"($"# K@
t S,"" 5,)", N5()$" '5()8 )*( " -J$%1()J1()%)$"($"# K@
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 54/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDe
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(` C-$":$1&6,"$%/ @:A/1&/ 2"8 V/#-./"2&5/-./&-6/.
O/6:A6/% >e- $1&6,":1,":6:&/"&/" [P
!"96/>/-" 1$"" /6" [P #/%>/"Q 8/" @2>9$"8 >e- G/;,W/-c 52 ./3-/"5/"d
G/8,< @0 [P 9/-8/" $%%/ 3/?"8/-&/" =/6&/" 6" 86/ MO 3/:;#-6/./"( =,06&02:: "2- $. 8/0 [P .6: 520 4,3>6%/bJ"8/ X.59( 8/0 [,006& 8/- %/&5&/" SL/96""/-bCsTZ G/8, 3/0$;#& 9/-8/"(
G";$1 !& j@ *(,>( 8,%R,)=>",(? Q,/=>, M_ R6& j@Z^,)(.6"5( $##," Q'%,"
*$Q), ;,% ̂ ,)7,% '6# ;," /,(R(," M_ZL$7Z<,=$%;I B$&)( 5'"" '6# ;),G";$Z<,=$%;* ;,% 8,%4/,)4,";," J,%/),%,% 7,R),/( R67%)##," Q,%;,"I
!"#$%& () *&#+#& ,-.
-/01-/02
!"#$%& () *&#+#& ,-.
"#$% "&&'(
")** ""#%#
$"&" "&*"+
'+"( $"$'(
(#"' $+%($
*"') $)#&&
*$## $#%%%
,345$*&
6&7& 8$6#9:4&
!"#$%& () *&#+#& ,-.
-/01-/02
!"#$%& () *&#+#& ,-.
"#$% "&&'(
")** ""#%#
$"&" "&*"+
'+"( $"$'(
(#"' $+%($
*"') $)#&&
*$## $#%%%
,345$*&
6&7& 8$6#9:4&[P)' [P)\
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDh
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
! M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 55/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EDi
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(w E/6&/->e#-/"8/ @">,-8/-2"3/" $" ./&-6/.%6;#/!">,-0$&6,"::c:&/0/
! O%$U, P<@ZB+*(,&, 8,%*6=>," '//, 4,(%),4/)=> %,/,8'"(," 3'(," 6";W6"5()$"," )" ,)",& B+*(,& '"R64),(,"!
:'(,%)'/Q)%(*=>'#(! @%$;65()$"
! K6=>>'/(6"7 `3,4)($%,"? -%,;)($%,"? N"/'7,"? @,%*$"'/? j'*>Z:'"'7,&,"(? Xa
! @,%*$"'/Q,*,"
! O,4H6;,8,%Q'/(6"7
! M%'"*.$%(Q,*,"
! X
! N6U,%;,& K,%,)(*(,//6"7 8$" 4,(%),4Q)%(*=>'#(/)=>," -,""R'>/," 6"; N6*Q,%(6"7," )" 6"(,%*=>),;/)=>," W$%&,"
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EED
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(w E/6&/->e#-/"8/ @">,-8/-2"3/" $" ./&-6/.%6;#/!">,-0$&6,"::c:&/0/
BN@ K6*)",** n", t N"*)=>( ,)",* -6";,"'6#(%'7*
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 56/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EEE
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(w E/6&/->e#-/"8/ @">,-8/-2"3/" $" ./&-6/.%6;#/!">,-0$&6,"::c:&/0/
BN@ K6*)",** n", t J,%5'6#*'"'/+*,Z3'*>4$'%;
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EEC
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
'(w E/6&/->e#-/"8/ @">,-8/-2"3/" $" ./&-6/.%6;#/!">,-0$&6,"::c:&/0/
! W%T>,%1 !";)8);6'/*$#(Q'%,? 7,R),/( #T% ,)" G"(,%",>&," ,"(Q)=5,/(
! Y,6(,1 :,)*( oB('";'%;pZB$#(Q'%,? ;), 56";,"*.,R)#)*=> 5$"#)76%),%( Q)%;
! SH>%6"7
! B.%'=>,
! ^,)(R$",
! N6**,>," 8$" n"/)",ZW$%&6/'%," 6"; :'*5,"
! K,%,=>()76"7," R6& L,*,"ub";,%" '6# W$%&6/'%,"u:'*5," 4)* >)"6"(,% R6%W,/;,4,",
! 6I8I'I&I
! Y),%;6%=> )& L'6#, ;,% }'>%, *,>% 5$&./,_, B+*(,&, ,"(*('";,"? &)(z >$>,% )"(,%",% -$&./,_)(H(
z >$>,& -$"#)76%'()$"*'6#Q'";
8/17/2019 Datenbankbasierte Implementierung Von Informationssystemen
http://slidepdf.com/reader/full/datenbankbasierte-implementierung-von-informationssystemen 57/57
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EE0
9 :I <,)=>,%(? @I 3';'&A G")8,%*)(H(G/& A BB CDEF
!"#$%&
! J$%4,&,%56"7,"
! K,)*.),/#)%&' L,7$M%')/,%NO
! P"(Q6%# ;,* 3'(,"4'"5*=>,&'*
! !&./,&,"(),%6"7 8$" N"Q,";6"7*#6"5()$","
! -$"*)*(,"(>'/(6"7*'*.,5(,
!
M%'"*'5()$"'/,N*.,5(, 6"; :,>%4,"6(R,%4,(%),4
! S,)(,%#T>%,";, N"#$%;,%6"7," '" 4,(%),4/)=>, !"#$%&'()$"**+*(,&,
! N4*=>/),U,";, K,&,%56"7,"
!"#$%&'()$"**+*(,&, A -'.)(,/01 3'(,"4'"54'*),%(, !&./,&,"(),%6"78$" !"#$%&'()$"**+*(,&,"B,)(, EE]
'(_ @.:;#%6/u/"8/ O/0/-12"3/"
! P<@ZB+*(,&, *)"; '6* ;,& >,6()7," S)%(*=>'#(*/,4," ")=>( &,>% Q,7 R6 ;,"5,"
! [,4," ;," #6"5()$"'/," N"#$%;,%6"7," *)"; J,%/H**/)=>5,)(? <$46*(>,)( 6";W,>/,%($/,%'"R Q)=>()7, -%)(,%)," #T% ;), @%'_)*('67/)=>5,)(
! P<@ZB+*(,&, 4'*),%," ;,*>'/4 ;6%=>Q,7 '6# `&,)*( %,/'()$"'/,%a 3K:BZM,=>"$/$7),
! !" 7%$U," G"(,%",>&," '%4,)(," (H7/)=> >6";,%(, 4)* ('6*,";, :)('%4,)(,% &)( ;,&`R,"(%'/,"a P<@ZB+*(,&
! 3,*>'/4 ,##)R),"(, <,'/)*),%6"7 ;,* ^6*'&&,"*.),/* RQ)*=>," P<@ZN"Q,";6"7*Z#6"5()$"," 6"; 3K:B ,4,"#'//* ,)" *,>% Q,*,"(/)=>,% W'5($%
! S), 7,*,>,"? )*( '6=> -$"*)*(,"(>'/(6"7 ;,% 3'(," ,)", 7%$U, Y,%'6*#$%;,%6"7