entity relationship diagram

399#0,943854/03

-0.9;08 W

%4:897,90470,943858 4:897,90470,943858-09003039908,70/0130/,3/ -09003039908,70/0130/,3/70130/ 70130/

W

%434470,943858,70 434470,943858,703.47547,90/39490/,9,-,80/083 3.47547,90/39490/,9,-,80/083 574.088

W

%4/08.7-04#.425430398 4/08.7-04#.425430398,110.9/,9,-,80/083,3/ ,110.9/,9,-,80/083,3/ 2502039,943



,9843.059:,,9,-,80083 W !74.08841/08.7-39 !74.08841/08.7-390/,9,70 0/,9,70,943858 ,943858 -0900390/,9,70,943858-0900390/,9, ,3/90.43897,3984390/,9, W 1907,3,88 1907,3,88 ,907,90088039,/, ,907,90088039,/,9, 9, 706:70/,3/:3/0789,3/490/,9,,7070,90/ W %014.: %014.:88 88439 4390 0/,9, /,9,7,9079,34390 7,9079,34390 574.08808 W %04:95:94190 %04:95:94190.43.059:, .43.059:,/,9,-,80/0 /,9,-,80/0838, 838, 43.059:,,9,4/0  ,9,. 9 9 43 43,7  

,907331472,94314743.059:,,9, 4/03



W %450 %450785 7850.9 0.9;0 ;08 8   %45/43 W ,9,24/08/07;0/1742,3392,90 :3/0789,3/34190-:83088

  49942:5 W ,9,24/08/07;0/-70;03850.1.,9438 ,3/-:83088/4.:20398



399#0,94385#4/03



W



#4/03

8,9  8,9 45 45/ 43 43,5574,.94/,9,-,80

/083 W 399 399#0,9 #0,9438 4385 5# #,7,2    /09,0/4.,705708039,9434190039908 ,884.,9438,3//,9,0020398147,347,3,94347 -:83088

W 49,943 49,943:80 :8089 897002, 7002,3 3.4389 .43897:.98 7:.98    ,9,039908    #0,943858

034/0 748449 4/0

  997-:908 

0349,943

 884.,943 -0900390 389,3.084143047 247003999508 399,20

!078435,.04-0.90;039 47.43.059,-4:9./,9, 894-02,39,30/ #057080398,80947.40.94341 4-0.9839070,47/9,9 8,70908,20574507908

'07- !7,80

 997-:90,20

3,20/574507947 .,7,.90789.41,3 0399

74844949,943

399

997-:90

399,20 399,20

8941 997-:908

 ..059,-0

#0,94385

'07-57,80

39908



W ,2508 ,2508410 410399 39908 08   !07843 !07843! ! $%&% $%&%!%% !%%    !,.0$% !,.0$%# ##&$ #&$    -0.9!#&%# -0.9!#&%#   ;039$ ;039$#$ #$%#% %#% # #    43.059 43.059&% &% &#$ &#$

W :/03081473,23,3 :/03081473,23,3//0133 //01330399950 03999508 8    303999503,208,83:,7 303999503,208,83:,734:3 34:3    3039995084:/-0/08.759;0 3039995084:/-0/08.759;0,3/850.1. ,3/850.1.    303993,2084:/-0.43.80 303993,2084:/-0.43.80    ;0390399950884:/-03,20/ ;0390399950884:/-03,20/14790708:94190 14790708:941900;039349 0;039349 90,.9;947574.08841900;039



 997-:908

 

W ,2504 ,25041039 10399 99508 9508,3/, ,3/,884., 884.,90/, 90/,997997-:908 :908 $%&%$9:/039*$9:/039*,20420*//7088 !430*:2-07,47 

W :/03 :/03081473 081473,23 ,23,997 ,997-:90 -:908 8    3,997-:903,208,34:3 3,997-:903,208,34:3    3,997-:903,2084:/-0:36:0 3,997-:903,2084:/-0:36:0    %42,0,3,997-:903,20:36:0,3/ %42,0,3,997-:903,20:36:0,3/.0,70,.,997-:903,20 .0,70,.,997-:903,20 84:/144,89,3/,7/1472,9    $2,7,997-:90841/110703903999 $2,7,997-:90841/11070390399950884:/:8082,7 50884:/:8082,7-:9 -:9 /893:833,208



 /039107997-:908

 

W ,3// ,3//,9 ,900 00    997-:90 997-:9047.42-3,94341,997-:908 47.42-3,94341,997-:9089,9:36:0 /0391080,.389,3.041,30399950    $4200399082,,;024709,3430.,3//,900 W .,3//,900147!825400* .,3//,900147!825400*,80.43/8 ,80.43/8 90.42-3,9434125400*,20,3///7088 W 19070824709,3430.,3//,90 19070824709,3430.,3//,900300/942,0 0300/942,0,.4.0 ,.4.0

W /03 /039 91 107  07     .,3//,9009,9,8-003800.90/,890:36:0 /03913.,7,.90789.147,30399950



  #0107039,997-:908

  

W

,0#010703 ,0#010703.0 .094,34 94,34907 907389,3.0 389,3.03 3,349 ,349079 079,-0 ,-0 ,  ,997 -: #0107 039    , ,997  -:9 0 0

%08900.9:707039994 ,3490703999,98/05,792039

,20

/:2

 

059





2,

,,.42

,7



%

2,7,.42

43





43,.42

2



%

2,.42

389,3.0410.9:707



,250

,20

03/07  



$9,11

$9,11 

$9,11  ! $9,11

,20 03/07  



#0,943858





884.,9438-09003389,3.0841430472470039995089,98413907089



;03,3,209,9/08.7-08981:3.943 W 70,943853,208,3,.9;0 47,5,88;0 ;07-

#0,943853,20

 7908 7908

:947 

44

 3,:9477908430472470-448  -44.,3-079903-430472470,:9478



070041#0,943858



W 07003:207003:2-0741 0741039 03999 995089, 5089,95,7 95,79.5 9.5,903, ,903,70,9 70,9438 4385 5 W %70 %700 0., .,80 808 8   &3,7-0900394389,3.08414300399950 3,7-0900394389,3.08414300399950   3,7 -0900390389,3.08419403999508   %073,7 ,24390389,3.0841970003999508



,7/3,9,3/4330.9;9 



W #0,943858.,3-0.,8810/ #0,943858.,3-0.,8810/,80907 ,80907 W 430  94 430 W 430  94 2,3

4330.9;9 

W 2,3  942,3

W

,7/3,9  232:2,3/2,2:23:2-0741  ,7/3,9 

389,3.08413999,9.,3 472:89-0 472:89-0  ,884.,90/90,.3 ,884.,90/90,.389,3.0410 89,3.0410399 399



,7/3,9,3/4330.9;9

!74108847

!74108847

90,.08

,88

90,.08

,88

 57410884790,.08.,88#  .,8889,:9-574108847 

4,3



,7/3,9,3/4330.9;9 4330.9;9

 !74108847

 90,.08

  

,88

  ,7/3,9

4330.9;9 90,.08

!74108847

 

,88

  ,7/3,9 

4330.9;9

W 03 034 4/0 /0   94705708039430 94705708039430    947057080392,3 947057080392,3





W 74 7484 8449 49 30

,3/,94743020,38 ,3/,94743020,38 

2,3 30472,3  59 43 0    8 43,  0  800

,1 9 90   7 9 7  98



3,7#0,943858



W

70,94385

  

#0, #0,94 943, 3, 24 24/0 /03 3 / /0, 0,

 

$4:/-09 $4:/-090347 034723, 23,370 370,943, ,943,/ /,9,-,80 ,9,-,80/083 /083



%070,94385-09003! %070,94385-09003 !%#,3/!% %#,3/!% 

%025020390/70,94385-09003! %025020390/ 70,94385-09003!%#,3/! %#,3/!% %

3,7#0,943858



W

70,94385

        

$4:/ $4:/-0 -07,7 7,703 03,3 ,37 70,9 0,943, 43, /,9 /,9,-, ,-,80 80/08 /083 3 830 8300399 0399389,3 389,3.0 .0343 3430039 00399. 9.,88 ,88870 870,90/ ,90/94, 94,830 8300399 0399 389,3.03,349070399.,88 4:/3/.,90 4:/3/.,909, 9,99 994039 4039908 908,.9:, ,.9:,-0 -043 43390 3908,20 8,209,-0 9,-0



%0#0,9438509003!#$$#,3/! %0#0,9438509003 !#$$#,3/!#%% #%%

%025020390/ #0,94385 09003 !#$$# ,3/ !#%%

3,7#0,943858



W

70,943858  

:89-0,;4/0/-0.,:80900,/94/,9,70/:3/,3.08 /,9,70/:3/,3.08

  

,3-025 ,3-025020390 020390/ /--7 --70,3 0,39: 9:5945 594574/:. 74/:.0, 0,809 80941 41  70,943858

  

,3,;4/ ,3,;4/574 574-028 -0283070 307039 3994 9470, 70,9438 94385 5-.70 -.70,93 ,93, , . 42 42 54890039947-7/00399 

W

%8 %8-0:80 -0:80/94 /943 3909, 909,-08 -089,9 9,90704 070473, 73, 70,9 70,90/ 0/ 3,70,94385

W

%0.425489 %0.4254890 00399 0399897: 897:.9:70 .9:703. 3.:/08 :/08,8 ,81  1 470308,9 470308,9 0,8990572,70841909,-089,9,7094-030/ 

%0#0,9438509003$%&%,3/$$ 4807 

$29843

 ..4:393  ..4:393 %  % 397494.74.425:93$ 397494.74.425:93 $  397494$9,989.8" 397494$9,989.8"   

%8%-025020390/,8843309

%09,-08,;02,370/:3/,3.08 %09,-08,;02,370/:3/,3.08

$$* $$* $$* 

$%&*&

,339070,9438594%70,943858

%0/,9,-,80/08307,82,345943894 %0/,9,-,80/08307,8 /0130,.42548909,-08572,70 /0130,.42548909,-08572,70 0907 :8090.42-3,94341948014703 08 47.70,90,30572,70 47.70,90,30572,70

4703087010703.090572,708390 49079,-0841.9,8,70,943859

43;07939070,94385394%70,943858

,3/,947;85943,,7/3,908



W

$50.1080907,3389,3.02:89 $50.1080907,3389,3.02:8908947.,3-0,-8039 08947.,3-0,-8039390 390 70,94385 ,3/,947

5943,

,3/08

0.9:707  

  



0.9:707

,88

,3/08  

,88  

 0.9:7072,,3/0 074 472,3.,8808

 .,888,3/0/-430,3/434300.9:707



494;,:,90,,9,4/0



W 44//,9,24/0 44//,9,24/0,890144 ,8901443 3    ..:7,.,3/.4250903088    4370/:3/,3.    3147.0203941-:830887:08    ,9,#0:8,-9    $9,-9,3/0-9    422:3.,943110.9;03088   $25.9



 4224389,0 4/0390-:83088574.08808 4/0390 -:83088574.08808 471:3.9438 471:3.9438 3890,/4190/,9, 3890,/4190 /,9,

,9/,9,0,3994005  0

,7 039 07 089 0/ 324 324/ 0 3 390 /,9,

%  9057 4.   %  4. 0880847  1 :3.  :3. 9 9438   4389,9 :8 :80

47    0307,9 0 9480 /,9,



,250

 02-07

 $0,7.08

448

8985,794190/,9,706:702039 70039070890/943490-44880,7.0/-90202-078 1,38078903% 3.:/09,9,8,70,94385 &804907,557457,90/,7,22390.36:0894.,59:7090-:83088 574.088088:.,8,9,4,7,2 43492:590:8041#4/039 

%0=

=

"

