Datenbankbasierte Implementierung Von Informationssystemen

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 B B 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,"

Transcript of Datenbankbasierte Implementierung Von Informationssystemen

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