ࡱ> o {RybjbjBrBrD  /TT8 {eO4(*_+Lddddddd$igjpd9W,("(W,W,dV 5e444W,&d4W,d44N\dS6bo}.`LdKe0{e`j1\jbjb++4+ +~+++ddw3+++{eW,W,W,W,j+++++++++T? :!  2545=85 5 1. 07K 40==KE 7 2. 84K <>45;59 40==KE 11 3. >=OB85 8=D>@<0F8>==>3> >1J5:B0 13 4. >@<0;870F8O >B=>H5=89 14 5. "8?K A2O759 17 6. >45;8 40==KE 18 6.1 !2545=LO > <>45;OE 40==KE 18 6.2 @>5:B8@>20=85 <>45;59 40==KE 19 6.2.1 -B0?K ?@>5:B8@>20=8O 40==KE 19 6.2.2 @54AB02;5=85 40==KE A ?><>ILN <>45;8 ACI=>ABL-A2O7L 21 7. >AB0=>2:0 7040G8 29 8. >AB@>5=85 8=D>;>38G5A:>9 <>45;8 40==KE 31 9. >AB@>5=85 40B>;>38G5A:>9 <>45;8 40==KE 33 0:;NG5=85 34 !?8A>: ;8B5@0BC@K 35  !>2@5<5==0O 687=L =5<KA;8<0 157 MDD5:B82=>3> C?@02;5=8O. 06=>9 :0B53>@859 O2;ONBAO A8AB5<K >1@01>B:8 8=D>@<0F88, >B :>B>@KE 2> <=>3>< 7028A8B MDD5:B82=>ABL @01>BK ;N1>3> ?@54?@8OB8O ;8 CG@5645=8O. "0:0O A8AB5<0 4>;6=0: >15A?5G820BL ?>;CG5=85 >1I8E 8/8;8 45B0;878@>20==KE >BG5B>2 ?> 8B>30< @01>BK; ?>72>;OBL ;53:> >?@545;OBL B5=45=F88 87<5=5=8O 206=59H8E ?>:070B5;59; >15A?5G820BL ?>;CG5=85 8=D>@<0F88, :@8B8G5A:>9 ?> 2@5<5=8, 157 ACI5AB25==KE 7045@65:; 2K?>;=OBL B>G=K9 8 ?>;=K9 0=0;87 40==KE. !>2@5<5==K5 !# 2 >A=>2=>< O2;ONBAO ?@8;>65=8O<8 Windows, B0: :0: 40==0O A@540 ?>72>;O5B 1>;55 ?>;=> 8A?>;L7>20BL 2>7<>6=>AB8 ?5@A>=0;L=>9 -, =565;8 A@540 DOS. !=865=85 AB>8<>AB8 2KA>:>?@>872>48B5;L=KE  >1CA;>28; =5 B>;L:> H8@>:89 ?5@5E>4 : A@545 Windows, 345 @07@01>BG8: ?@>3@0<<=>3> >15A?5G5=8O <>65B 2 <5=LH5 AB5?5=8 701>B8BLAO > @0A?@545;5=88 @5AC@A>2, => B0:65 A45;0; ?@>3@0<<=>5 >15A?5G5=85  2 F5;>< 8 !# 2 G0AB=>AB8 <5=55 :@8B8G=K<8 : 0??0@0B=K< @5AC@A0< -. !@548 =081>;55 O@:8E ?@54AB028B5;59 A8AB5< C?@02;5=8O 1070<8 40==KE <>6=> >B<5B8BL: Lotus Approach, Microsoft Access, Borland dBase, Borland Paradox, Microsoft Visual FoxPro, Microsoft Visual Basic, 0 B0:65 107 40==KE Microsoft SQL Server 8 Oracle, 8A?>;L7C5<K5 2 ?@8;>65=8OE, ?>AB@>5==KE ?> B5E=>;>388 :;85=B-A5@25@. $0:B8G5A:8, C ;N1>9 A>2@5<5==>9 !# ACI5AB2C5B 0=0;>3, 2K?CA:05<K9 4@C3>9 :><?0=859, 8<5NI89 0=0;>38G=CN >1;0ABL ?@8<5=5=8O 8 2>7<>6=>AB8, ;N1>5 ?@8;>65=85 A?>A>1=> @01>B0BL A> <=>38<8 D>@<0B0<8 ?@54AB02;5=8O 40==KE, >ACI5AB2;OBL M:A?>@B 8 8<?>@B 40==KE 1;03>40@O =0;8G8N 1>;LH>3> G8A;0 :>=25@B5@>2. 1I5?@8=OBK<8, B0:65, O2;ONBAO B5E=>;>38, ?>72>;ONI85 8A?>;L7>20BL 2>7<>6=>AB8 4@C38E ?@8;>65=89, =0?@8<5@, B5:AB>2KE ?@>F5AA>@>2, ?0:5B>2 ?>AB@>5=8O 3@0D8:>2 8 B.?., 8 2AB@>5==K5 25@A88 O7K:>2 2KA>:>3> C@>2=O (G0I5  480;5:BK SQL 8/8;8 VBA) 8 A@54AB20 287C0;L=>3> ?@>3@0<<8@>20=8O 8=B5@D59A>2 @07@010BK205<KE ?@8;>65=89. >MB><C C65 =5 8<55B ACI5AB25==>3> 7=0G5=8O =0 :0:>< O7K:5 8 =0 >A=>25 :0:>3> ?0:5B0 =0?8A0=> :>=:@5B=>5 ?@8;>65=85, 8 :0:>9 D>@<0B 40==KE 2 =5< 8A?>;L7C5BAO. >;55 B>3>, AB0=40@B>< 45-D0:B> AB0;0 1KAB@0O @07@01>B:0 ?@8;>65=89 8;8 RAD (>B 0=3;89A:>3> Rapid Application Development), >A=>20==0O =0 H8@>:> 45:;0@8@C5<>< 2 ;8B5@0BC@5 >B:@KB>< ?>4E>45, B> 5ABL =5>1E>48<>ABL 8 2>7<>6=>ABL 8A?>;L7>20=8O @07;8G=KE ?@8:;04=KE ?@>3@0<< 8 B5E=>;>389 4;O @07@01>B:8 1>;55 381:8E 8 <>I=KE A8AB5< >1@01>B:8 40==KE. >MB><C 2 >4=>< @O4C A :;0AA8G5A:8<8 !# 2A5 G0I5 C?><8=0NBAO O7K:8 ?@>3@0<<8@>20=8O Visual Basic 4.0 8 Visual C++, :>B>@K5 ?>72>;ONB 1KAB@> A>74020BL =5>1E>48<K5 :><?>=5=BK ?@8;>65=89, :@8B8G=K5 ?> A:>@>AB8 @01>BK, :>B>@K5 B@C4=>, 0 8=>340 =52>7<>6=> @07@01>B0BL A@54AB20<8 :;0AA8G5A:8E !#. !>2@5<5==K9 ?>4E>4 : C?@02;5=8N 1070<8 40==KE ?>4@07C<5205B B0:65 H8@>:>5 8A?>;L7>20=85 B5E=>;>388 :;85=B-A5@25@. "0:8< >1@07><, =0 A53>4=OH=89 45=L @07@01>BG8: =5 A2O70= @0<:0<8 :0:>3>-;81> :>=:@5B=>3> ?0:5B0, 0 2 7028A8<>AB8 >B ?>AB02;5==>9 7040G8 <>65B 8A?>;L7>20BL A0<K5 @07=K5 ?@8;>65=8O. >MB><C, 1>;55 206=K< ?@54AB02;O5BAO >1I55 =0?@02;5=85 @0728B8O !# 8 4@C38E A@54AB2 @07@01>B:8 ?@8;>65=89 2 =0AB>OI55 2@5<O. 1. + +% &5;L ;N1>9 8=D>@<0F8>==>9 A8AB5<K  >1@01>B:0 40==KE >1 >1J5:B0E @50;L=>3> <8@0.  H8@>:>< A<KA;5 A;>20 1070 40==KE  MB> A>2>:C?=>ABL A2545=89 > :>=:@5B=KE >1J5:B0E @50;L=>3> <8@0 2 :0:>9-;81> ?@54<5B=>9 >1;0AB8. >4 ?@54<5B=>9 >1;0ABLN ?@8=OB> ?>=8<0BL G0ABL @50;L=>3> <8@0, ?>4;560I53> 87CG5=8N 4;O >@30=870F88 C?@02;5=8O 8, 2 :>=5G=>< AG5B5, 02B><0B870F88, =0?@8<5@ ?@54?@8OB85, 2C7 8 B 4. !>74020O 107C 40==KE, ?>;L7>20B5;L AB@5<8BAO C?>@O4>G8BL 8=D>@<0F8N ?> @07;8G=K< ?@87=0:0< 8 1KAB@> 872;5:0BL 2K1>@:C A ?@>872>;L=K< A>G5B0=85< ?@87=0:>2. !45;0BL MB> 2>7<>6=>, B>;L:> 5A;8 40==K5 AB@C:BC@8@>20=K. !B@C:BC@8@>20=85  MB> 22545=85 A>3;0H5=89 > A?>A>10E ?@54AB02;5=8O 40==KE. 5AB@C:BC@8@>20==K<8 =07K20NB 40==K5, 70?8A0==K5, =0?@8<5@, 2 B5:AB>2>< D09;5. >;L7>20B5;O<8 107K 40==KE <>3CB 1KBL @07;8G=K5 ?@8:;04=K5 ?@>3@0<<K, ?@>3@0<<=K5 :><?;5:AK, 0 B0:65 A?5F80;8ABK ?@54<5B=>9 >1;0AB8, 2KABC?0NI85 2 @>;8 ?>B@518B5;59 8;8 8AB>G=8:>2 40==KE, =07K205<K5 :>=5G=K<8 ?>;L7>20B5;O<8.  A>2@5<5==>9 B5E=>;>388 107 40==KE ?@54?>;0305BAO, GB> A>740=85 107K 40==KE, 55 ?>445@6:0 8 >15A?5G5=85 4>ABC?0 ?>;L7>20B5;59 : =59 >ACI5AB2;ONBAO F5=B@0;87>20==> A ?><>ILN A?5F80;L=>3> ?@>3@0<<=>3> 8=AB@C<5=B0@8O  A8AB5<K C?@02;5=8O 1070<8 40==KE. 070 40==KE ()  MB> ?>8<5=>20==0O A>2>:C?=>ABL AB@C:BC@8@>20==KE 40==KE, >B=>AOI8EAO : >?@545;5==>9 ?@54<5B=>9 >1;0AB8. !8AB5<0 C?@02;5=8O 1070<8 40==KE (!#)  MB> :><?;5:A ?@>3@0<<=KE 8 O7K:>2KE A@54AB2, =5>1E>48<KE 4;O A>740=8O 107 40==KE, ?>445@60=8O 8E 2 0:BC0;L=>< A>AB>O=88 8 >@30=870F88 ?>8A:0 2 =8E =5>1E>48<>9 8=D>@<0F88. &5=B@0;87>20==K9 E0@0:B5@ C?@02;5=8O 40==K<8 2 1075 40==KE ?@54?>;0305B =5>1E>48<>ABL ACI5AB2>20=8O =5:>B>@>3> ;8F0 (3@C??K ;8F), =0 :>B>@>5 2>7;030NBAO DC=:F88 04<8=8AB@8@>20=8O 40==K<8, E@0=8<K<8 2 1075. ;0AA8D8:0F8O 107 40==KE > B5E=>;>388 >1@01>B:8 40==KE 107K 40==KE ?>4@0745;ONBAO =0 F5=B@0;87>20==K5 8 @0A?@545;5==K5. &5=B@0;87>20==0O 1070 40==KE E@0=8BAO 2 ?0<OB8 >4=>9 2KG8A;8B5;L=>9 A8AB5<K. A;8 MB0 2KG8A;8B5;L=0O A8AB5<0 O2;O5BAO :><?>=5=B>< A5B8 -, 2>7<>65= @0A?@545;5==K9 4>ABC? : B0:>9 1075. "0:>9 A?>A>1 8A?>;L7>20=8O 107 40==KE G0AB> ?@8<5=ONB 2 ;>:0;L=KE A5BOE . 0A?@545;5==0O 1070 40==KE A>AB>8B 87 =5A:>;L:8E, 2>7<>6=> ?5@5A5:0NI8EAO 8;8 4065 4C1;8@CNI8E 4@C3 4@C30 G0AB59, E@0=8<KE 2 @07;8G=KE - 2KG8A;8B5;L=>9 A5B8. 01>B0 A B0:>9 107>9 >ACI5AB2;O5BAO A ?><>ILN A8AB5<K C?@02;5=8O @0A?@545;5==>9 107>9 40==KE (!# ). > A?>A>1C 4>ABC?0 : 40==K< 107K 40==KE @0745;ONBAO =0 107K 40==KE A ;>:0;L=K< 4>ABC?>< 8 107K 40==KE A C40;5==K< (A5B52K<) 4>ABC?><. !8AB5<K F5=B@0;87>20==KE 107 40==KE A A5B52K< 4>ABC?>< ?@54?>;030NB @07;8G=K5 0@E8B5:BC@K ?>4>1=KE A8AB5<: " D09;-A5@25@; " :;85=B-A5@25@. $09;-A5@25@. @E8B5:BC@0 A8AB5<  A A5B52K< 4>ABC?>< ?@54?>;0305B 2K45;5=85 >4=>9 87 <0H8= A5B8 2 :0G5AB25 F5=B@0;L=>9 (A5@25@, D09;>2). 0 B0:>9 <0H8=5 E@0=8BAO A>2<5AB=> 8A?>;L7C5<0O F5=B@0;87>20==0O . A5 4@C385 <0H8=K A5B8 2K?>;=ONB DC=:F88 @01>G8E AB0=F89, A ?><>ILN :>B>@KE ?>445@68205BAO 4>ABC? ?>;L7>20B5;LA:>9 A8AB5<K : F5=B@0;87>20==>9 1075 40==KE. $09;K 107K 40==KE 2 A>>B25BAB288 A ?>;L7>20B5;LA:8<8 70?@>A0<8 ?5@540NBAO =0 @01>G85 AB0=F88, 345 2 >A=>2=>< 8 ?@>872>48BAO >1@01>B:0. @8 1>;LH>9 8=B5=A82=>AB8 4>ABC?0 : >4=8< 8 B5< 65 40==K< ?@>872>48B5;L=>ABL 8=D>@<0F8>==>9 A8AB5<K ?0405B. >;L7>20B5;8 <>3CB A>74020BL B0:65 =0 @01>G8E AB0=F8OE ;>:0;L=K5 , :>B>@K5 8A?>;L7CNBAO 8<8 <>=>?>;L=>. ;85=B-A5@25@.  MB>9 :>=F5?F88 ?>4@07C<5205BAO, GB> ?><8<> E@0=5=8O F5=B@0;87>20==>9 107K 40==KE F5=B@0;L=0O <0H8=0 (A5@25@ 107K 40==KE) 4>;6=0 >15A?5G820BL 2K?>;=5=85 >A=>2=>3> >1J5<0 >1@01>B:8 40==KE. 0?@>A =0 40==K5, 2K40205<K9 :;85=B>< (@01>G59 AB0=F859), ?>@>6405B ?>8A: 8 872;5G5=85 40==KE =0 A5@25@5. 72;5G5==K5 40==K5 (=> =5 D09;K) B@0=A?>@B8@CNBAO ?> A5B8 >B A5@25@0 : :;85=BC. !?5F8D8:>9 0@E8B5:BC@K :;85=B-A5@25@ O2;O5BAO 8A?>;L7>20=85 O7K:0 70?@>A>2 SOL. !B@C:BC@=K5 M;5<5=BK 107K 40==KE >=OB85 107K 40==KE B5A=> A2O70=> A B0:8<8 ?>=OB8O<8 AB@C:BC@=KE M;5<5=B>2, :0: ?>;5, 70?8AL, D09; (B01;8F0). >;5  M;5<5=B0@=0O 548=8F0 ;>38G5A:>9 >@30=870F88 40==KE, :>B>@0O A>>B25BAB2C5B =545;8<>9 548=8F5 8=D>@<0F88  @5:2878BC. ;O >?8A0=8O ?>;O 8A?>;L7CNBAO A;54CNI85 E0@0:B5@8AB8:8: 8<O, =0?@8<5@. $0<8;8O, <O, BG5AB2>, 0B0 @>645=8O; B8?, =0?@8<5@, A8<2>;L=K9, G8A;>2>9, :0;5=40@=K9; 4;8=0, =0?@8<5@, 15 109B, ?@8G5< 1C45B >?@545;OBLAO <0:A8<0;L=> 2>7<>6=K< :>;8G5AB2>< A8<2>;>2; B>G=>ABL 4;O G8A;>2KE 40==KE, =0?@8<5@ 420 45AOB8G=KE 7=0:0 4;O >B>1@065=8O 4@>1=>9 G0AB8 G8A;0. 0?8AL  A>2>:C?=>ABL ;>38G5A:8 A2O70==KE ?>;59. -:75<?;O@ 70?8A8  >B45;L=0O @50;870F8O 70?8A8, A>45@60I0O :>=:@5B=K5 7=0G5=8O 55 ?>;59. $09; (B01;8F0)  A>2>:C?=>ABL M:75<?;O@>2 70?8A59 >4=>9 AB@C:BC@K.  AB@C:BC@5 70?8A8 D09;0 C:07K20NBAO ?>;O, 7=0G5=8O :>B>@KE O2;ONBAO :;NG0<8 ?5@28G=K<8 (), :>B>@K5 845=B8D8F8@CNB M:75<?;O@ 70?8A8, 8 2B>@8G=K<8 (), :>B>@K5 2K?>;=ONB @>;L ?>8A:>2KE 8;8 3@C??8@>2>G=KE ?@87=0:>2 (?> 7=0G5=8N 2B>@8G=>3> :;NG0 <>6=> =09B8 =5A:>;L:> 70?8A59). 2. +  +% /4@>< ;N1>9 107K 40==KE O2;O5BAO <>45;L 40==KE. >45;L 40==KE ?@54AB02;O5B A>1>9 <=>65AB2> AB@C:BC@ 40==KE, >3@0=8G5=89 F5;>AB=>AB8 8 >?5@0F89 <0=8?C;8@>20=8O 40==K<8. ! ?><>ILN <>45;8 40==KE <>3CB 1KBL ?@54AB02;5=K >1J5:BK ?@54<5B=>9 >1;0AB8 8 2708<>A2O78 <564C =8<8. >45;L 40==KE  A>2>:C?=>ABL AB@C:BC@ 40==KE 8 >?5@0F89 8E >1@01>B:8. !# >A=>2K205BAO =0 8A?>;L7>20=88 85@0@E8G5A:>9, A5B52>9 8;8 @5;OF8>==>9 <>45;8, =0 :><18=0F88 MB8E <>45;59 8;8 =0 =5:>B>@>< 8E ?>4<=>65AB25. 0AA<>B@8< B@8 >A=>2=KE B8?0 <>45;59 40==KE: 85@0@E8G5A:CN, A5B52CN 8 @5;OF8>==CN. 5@0@E8G5A:0O <>45;L 40==KE 5@0@E8G5A:0O AB@C:BC@0 ?@54AB02;O5B A>2>:C?=>ABL M;5<5=B>2, A2O70==KE <564C A>1>9 ?> >?@545;5==K< ?@028;0<. 1J5:BK, A2O70==K5 85@0@E8G5A:8<8 >B=>H5=8O<8, >1@07CNB >@85=B8@>20==K9 3@0D (?5@525@=CB>5 45@52>).  >A=>2=K< ?>=OB8O< 85@0@E8G5A:>9 AB@C:BC@K >B=>AOBAO: C@>25=L, M;5<5=B (C75;), A2O7L. #75;  MB> A>2>:C?=>ABL 0B@81CB>2 40==KE, >?8AK20NI8E =5:>B>@K9 >1J5:B. 0 AE5<5 85@0@E8G5A:>3> 45@520 C7;K ?@54AB02;ONBAO 25@H8=0<8 3@0D0. 064K9 C75; =0 1>;55 =87:>< C@>2=5 A2O70= B>;L:> A >4=8< C7;><, =0E>4OI8<AO =0 1>;55 2KA>:>< C@>2=5. 5@0@E8G5A:>5 45@52> 8<55B B>;L:> >4=C 25@H8=C (:>@5=L 45@520), =5 ?>4G8=5==CN =8:0:>9 4@C3>9 25@H8=5 8 =0E>4OICNAO =0 A0<>< 25@E=5< (?5@2><) C@>2=5. 028A8<K5 (?>4G8=5==K5) C7;K =0E>4OBAO =0 2B>@><, B@5BL5< 8 B.4. C@>2=OE. >;8G5AB2> 45@52L52 2 1075 40==KE >?@545;O5BAO G8A;>< :>@=52KE 70?8A59.  :064>9 70?8A8 107K 40==KE ACI5AB2C5B B>;L:> >48= (85@0@E8G5A:89) ?CBL >B :>@=52>9 70?8A8. !5B520O <>45;L 40==KE  A5B52>9 AB@C:BC@5 ?@8 B5E 65 >A=>2=KE ?>=OB8OE (C@>25=L, C75;, A2O7L) :064K9 M;5<5=B <>65B 1KBL A2O70= A ;N1K< 4@C38< M;5<5=B><. 5;OF8>==0O <>45;L 40==KE >=OB85 @5;OF8>==K9 (0=3;. relation  >B=>H5=85) A2O70=> A @07@01>B:0<8 8725AB=>3> 0<5@8:0=A:>3> A?5F80;8AB0 2 >1;0AB8 A8AB5< 107 40==KE . >440. -B8 <>45;8 E0@0:B5@87CNBAO ?@>AB>B>9 AB@C:BC@K 40==KE, C4>1=K< 4;O ?>;L7>20B5;O B01;8G=K< ?@54AB02;5=85< 8 2>7<>6=>ABLN 8A?>;L7>20=8O D>@<0;L=>3> 0??0@0B0 0;351@K >B=>H5=89 8 @5;OF8>==>3> 8AG8A;5=8O 4;O >1@01>B:8 40==KE. 5;OF8>==0O <>45;L >@85=B8@>20=0 =0 >@30=870F8N 40==KE 2 2845 42C<5@=KE B01;8F. 0640O @5;OF8>==0O B01;8F0 ?@54AB02;O5B A>1>9 42C<5@=K9 <0AA82 8 >1;0405B A;54CNI8<8 A2>9AB20<8: :064K9 M;5<5=B B01;8FK  >48= M;5<5=B 40==KE; 2A5 AB>;1FK 2 B01;8F5 >4=>@>4=K5, B.5. 2A5 M;5<5=BK 2 AB>;1F5 8<5NB >48=0:>2K9 B8? (G8A;>2>9, A8<2>;L=K9 8 B.4.) 8 4;8=C; :064K9 AB>;15F 8<55B C=8:0;L=>5 8<O; >48=0:>2K5 AB@>:8 2 B01;8F5 >BACBAB2CNB; ?>@O4>: A;54>20=8O AB@>: 8 AB>;1F>2 <>65B 1KBL ?@>872>;L=K<. B=>H5=8O ?@54AB02;5=K 2 2845 B01;8F, AB@>:8 :>B>@KE A>>B25BAB2CNB :>@B560< 8;8 70?8AO<, 0 AB>;1FK  0B@81CB0< >B=>H5=89, 4><5=0<, ?>;O<. >;5, :064>5 7=0G5=85 :>B>@>3> >4=>7=0G=> >?@545;O5B A>>B25BAB2CNICN 70?8AL, =07K205BAO ?@>ABK< :;NG>< (:;NG52K< ?>;5<). A;8 70?8A8 >4=>7=0G=> >?@545;ONBAO 7=0G5=8O<8 =5A:>;L:8E ?>;59, B> B0:0O B01;8F0 107K 40==KE 8<55B A>AB02=>9 :;NG. 'B>1K A2O70BL 425 @5;OF8>==K5 B01;8FK, =5>1E>48<> :;NG ?5@2>9 B01;8FK 225AB8 2 A>AB02 :;NG0 2B>@>9 B01;8FK (2>7<>6=> A>2?045=85 :;NG59); 2 ?@>B82=>< A;CG05 =C6=> 225AB8 2 AB@C:BC@C ?5@2>9 B01;8FK 2=5H=89 :;NG  :;NG 2B>@>9 B01;8FK. 3. /" $ & *" =D>@<0F8>==K9 >1J5:B  MB> >?8A0=85 =5:>B>@>9 ACI=>AB8 (@50;L=>3> >1J5:B0, O2;5=8O, ?@>F5AA0, A>1KB8O) 2 2845 A>2>:C?=>AB8 ;>38G5A:8 A2O70==KE @5:2878B>2 (8=D>@<0F8>==KE M;5<5=B>2). "0:8<8 ACI=>ABO<8 4;O 8=D>@<0F8>==KE >1J5:B>2 <>3CB A;C68BL: F5E, A:;04, <0B5@80;, 2C7, ABC45=B, A40G0 M:70<5=>2 8 B.4. =D>@<0F8>==K9 >1J5:B >?@545;5==>3> @5:2878B=>3> A>AB020 8 AB@C:BC@K >1@07C5B :;0AA (B8?), :>B>@><C ?@8A208205BAO C=8:0;L=>5 8<O (A8<2>;L=>5 >1>7=0G5=85), =0?@8<5@ !BC45=B, !5AA8O, !B8?5=48O. =D>@<0F8>==K9 >1J5:B 8<55B <=>65AB2> @50;870F88  M:75<?;O@>2, :064K9 87 :>B>@KE ?@54AB02;5= A>2>:C?=>ABLN :>=:@5B=KE 7=0G5=89 @5:2878B>2 8 845=B8D8F8@C5BAO 7=0G5=85< :;NG0 (?@>AB>3>  >48= @5:2878B 8;8 A>AB02=>3>  =5A:>;L:> @5:2878B>2). AB0;L=K5 @5:2878BK 8=D>@<0F8>==>3> >1J5:B0 O2;ONBAO >?8A0B5;L=K<8. @8 MB>< >4=8 8 B5 65 @5:2878BK 2 >4=8E 8=D>@<0F8>==KE >1J5:B0E <>3CB 1KBL :;NG52K<8, 0 2 4@C38E - >?8A0B5;L=K<8. =D>@<0F8>==K9 >1J5:B <>65B 8<5BL =5A:>;L:> :;NG59. 4.  &/ "( >=OB85 =>@<0;870F88 >B=>H5=89 4=8 8 B5 65 40==K5 <>3CB 3@C??8@>20BLAO 2 B01;8FK (>B=>H5=8O) @07;8G=K<8 A?>A>10<8, B.5. 2>7<>6=0 >@30=870F8O @07;8G=KE =01>@>2 >B=>H5=89 2708<>A2O70==KE 8=D>@<0F8>==KE >1J5:B>2. @C??8@>2:0 0B@81CB>2 2 >B=>H5=8OE 4>;6=0 1KBL @0F8>=0;L=>9, B.5. <8=8<878@CNI59 4C1;8@>20=85 40==KE 8 C?@>I0NI59 ?@>F54C@K 8E >1@01>B:8 8 >1=>2;5=8O. ?@545;5==K9 =01>@ >B=>H5=89 >1;0405B ;CGH8<8 A2>9AB20<8 ?@8 2:;NG5=88, <>48D8:0F88, C40;5=88 40==KE, G5< 2A5 >AB0;L=K5 2>7<>6=K5 =01>@K >B=>H5=89, 5A;8 >= >B25G05B B@51>20=8O< =>@<0;870F88 >B=>H5=89. >@<0;870F8O >B=>H5=89  D>@<0;L=K9 0??0@0B >3@0=8G5=89 =0 D>@<8@>20=85 >B=>H5=89 (B01;8F), :>B>@K9 ?>72>;O5B CAB@0=8BL 4C1;8@>20=85, >15A?5G8205B =5?@>B82>@5G82>ABL E@0=8<KE 2 1075 40==KE, C<5=LH05B B@C4>70B@0BK =0 2545=85 (22>4, :>@@5:B8@>2:C) 107K 40==KE. K45;5=K B@8 =>@<0;L=K5 D>@<K >B=>H5=89 8 ?@54;>65= <5E0=87<, ?>72>;ONI89 ;N1>5 >B=>H5=85 ?@5>1@07>20BL : B@5BL59 (A0<>9 A>25@H5==>9) =>@<0;L=>9 D>@<5. 5@20O =>@<0;L=0O D>@<0 B=>H5=85 =07K205BAO =>@<0;87>20==K< 8;8 ?@82545==K< : ?5@2>9 =>@<0;L=>9 D>@<5, 5A;8 2A5 53> 0B@81CBK ?@>ABK5 (40;55 =545;8<K). @5>1@07>20=85 >B=>H5=8O : ?5@2>9 =>@<0;L=>9 D>@<5 <>65B ?@825AB8 : C25;8G5=8N :>;8G5AB20 @5:2878B>2 (?>;59) >B=>H5=8O 8 87<5=5=8N :;NG0. 0?@8<5@, >B=>H5=85 !BC45=B = (><5@, $0<8;8O, <O, BG5AB2>, 0B0, @C??0) =02>48BAO 2 ?5@2>9 =>@<0;L=>9 D>@<5. B>@0O =>@<0;L=0O D>@<0 'B>1K @0AA<>B@5BL 2>?@>A ?@82545=8O >B=>H5=89 :> 2B>@>9 =>@<0;L=>9 D>@<5, =5>1E>48<> 40BL ?>OA=5=8O : B0:8< ?>=OB8O<, :0: DC=:F8>=0;L=0O 7028A8<>ABL 8 ?>;=0O DC=:F8>=0;L=0O 7028A8<>ABL. ?8A0B5;L=K5 @5:2878BK 8=D>@<0F8>==>3> >1J5:B0 ;>38G5A:8 A2O70=K A >1I8< 4;O =8E :;NG><, MB0 A2O7L =>A8B E0@0:B5@ DC=:F8>=0;L=>9 7028A8<>AB8 @5:2878B>2. $C=:F8>=0;L=0O 7028A8<>ABL @5:2878B>2  7028A8<>ABL, ?@8 :>B>@>9 M:75<?;O@5 8=D>@<0F8>==>3> >1J5:B0 >?@545;5==><C 7=0G5=8N :;NG52>3> @5:2878B0 A>>B25BAB2C5B B>;L:> >4=> 7=0G5=85 >?8A0B5;L=>3> @5:2878B0. "0:>5 >?@545;5=85 DC=:F8>=0;L=>9 7028A8<>AB8 ?>72>;O5B ?@8 0=0;875 2A5E 2708<>A2O759 @5:2878B>2 ?@54<5B=>9 >1;0AB8 2K45;8BL A0<>AB>OB5;L=K5 8=D>@<0F8>==K5 >1J5:BK.  A;CG05 A>AB02=>3> :;NG0 22>48BAO ?>=OB85 DC=:F8>=0;L=> ?>;=>9 7028A8<>AB8. $C=:F8>=0;L=> ?>;=0O 7028A8<>ABL =5 :;NG52KE 0B@81CB>2 70:;NG05BAO 2 B><, GB> :064K9 =5 :;NG52>9 0B@81CB DC=:F8>=0;L=> 7028A8B >B :;NG0, => =5 =0E>48BAO 2 DC=:F8>=0;L=>9 7028A8<>AB8 =8 >B :0:>9 G0AB8 A>AB02=>3> :;NG0. B=>H5=85 1C45B =0E>48BLAO 2> 2B>@>9 =>@<0;L=>9 D>@<5, 5A;8 >=> =0E>48BAO 2 ?5@2>9 =>@<0;L=>9 D>@<5, 8 :064K9 =5 :;NG52>9 0B@81CB DC=:F8>=0;L=> ?>;=> 7028A8B >B A>AB02=>3> :;NG0. "@5BLO =>@<0;L=0O D>@<0 >=OB85 B@5BL59 =>@<0;L=>9 D>@<K >A=>2K205BAO =0 ?>=OB88 =5B@0=78B82=>9 7028A8<>AB8. "@0=78B82=0O 7028A8<>ABL =01;N405BAO 2 B>< A;CG05, 5A;8 >48= 87 42CE >?8A0B5;L=KE @5:2878B>2 7028A8B >B :;NG0, 0 4@C3>9 >?8A0B5;L=K9 @5:2878B 7028A8B >B ?5@2>3> >?8A0B5;L=>3> @5:2878B0. B=>H5=85 1C45B =0E>48BLAO 2 B@5BL59 =>@<0;L=>9 D>@<5, 5A;8 >=> =0E>48BAO 2> 2B>@>9 =>@<0;L=>9 D>@<5, 8 :064K9 =5:;NG52>9 0B@81CB =5B@0=78B82=> 7028A8B >B ?5@28G=>3> :;NG0. ;O CAB@0=5=8O B@0=78B82=>9 7028A8<>AB8 >?8A0B5;L=KE @5:2878B>2 =5>1E>48<> ?@>25AB8 @0AI5?;5=85 8AE>4=>3> 8=D>@<0F8>==>3> >1J5:B0.  @57C;LB0B5 @0AI5?;5=8O G0ABL @5:2878B>2 C40;O5BAO 87 8AE>4=>3> 8=D>@<0F8>==>3> >1J5:B0 8 2:;NG05BAO 2 A>AB02 4@C38E (2>7<>6=>, 2=>2L A>740==KE) 8=D>@<0F8>==KE >1J5:B>2. 5. "+ !/ A5 8=D>@<0F8>==K5 >1J5:BK ?@54<5B=>9 >1;0AB8 A2O70=K <564C A>1>9. 07;8G0NBAO A2O78 =5A:>;L:8E B8?>2, 4;O :>B>@KE 22545=K A;54CNI85 >1>7=0G5=8O: >48= : >4=><C (1:1); >48= :> <=>38< (1 : ); <=>385 :> <=>38< ( : ). !2O7L >48= : >4=><C (1:1) ?@54?>;0305B, GB> 2 :064K9 <><5=B 2@5<5=8 >4=><C M:75<?;O@C 8=D>@<0F8>==>3> >1J5:B0  A>>B25BAB2C5B =5 1>;55 >4=>3> M:75<?;O@0 8=D>@<0F8>==>3> >1J5:B0  8 =0>1>@>B. @8 A2O78 >48= :> <=>38< (1:) >4=><C M:75<?;O@C 8=D>@<0F8>==>3> >1J5:B0  A>>B25BAB2C5B 0, 1 8;8 1>;55 M:75<?;O@>2 >1J5:B0 , => :064K9 M:75<?;O@ >1J5:B0  A2O70= =5 1>;55 G5< A 1 M:75<?;O@>< >1J5:B0 . @0D8G5A:8 40==>5 A>>B25BAB285 8<55B 284. !2O7L <=>385 :> <=>38< (:) ?@54?>;0305B, GB> 2 :064K9 <><5=B 2@5<5=8 >4=><C M:75<?;O@C 8=D>@<0F8>==>3> >1J5:B0  A>>B25BAB2C5B 0, 1 8;8 1>;55 M:75<?;O@>2 >1J5:B0  8 =0>1>@>B. 6.  +% 6.1. !2545=LO > <>45;OE 40==KE =D>;>38G5A:0O <>45;L >B>1@0605B @50;L=K9 <8@ 2 =5:>B>@K5 ?>=OB=K5 G5;>25:C :>=F5?F88, ?>;=>ABLN =57028A8<K5 >B ?0@0<5B@>2 A@54K E@0=5=8O 40==KE. !CI5AB2C5B <=>65AB2> ?>4E>4>2 : ?>AB@>5=8N B0:8E <>45;59: 3@0D>2K5 <>45;8, A5<0=B8G5A:85 A5B8, <>45;L ACI=>ABL-A2O7L 8 B.4. 081>;55 ?>?C;O@=>9 87 =8E >:070;0AL <>45;L ACI=>ABL-A2O7L. =D>;>38G5A:0O <>45;L 4>;6=0 1KBL >B>1@065=0 2 :><?LNB5@> - >@85=B8@>20==CN 40B0;>38G5A:CN <>45;L, ?>=OB=CN !#.  ?@>F5AA5 @0728B8O B5>@88 8 ?@0:B8G5A:>3> 8A?>;L7>20=8O 107 40==KE, 0 B0:65 A@54AB2 2KG8A;8B5;L=>9 B5E=8:8 A>74020;8AL !#, ?>445@6820NI85 @07;8G=K5 40B0;>38G5A:85 <>45;8. !=0G0;0 AB0;8 8A?>;L7>20BL 85@0@E8G5A:85 40B0;>38G5A:85 <>45;8. @>AB>B0 >@30=870F88, =0;8G85 70@0=55 7040==KE A2O759 <564C ACI=>ABO<8, AE>4AB2> A D878G5A:8<8 <>45;O<8 40==KE ?>72>;O;8 4>1820BLAO ?@85<;5<>9 ?@>872>48B5;L=>AB8 85@0@E8G5A:8E !# =0 <54;5==KE - A 25AL<0 >3@0=8G5==K<8 >1J5<0<8 ?0<OB8. >, 5A;8 40==K5 =5 8<5;8 4@52>284=>9 AB@C:BC@K, B> 2>7=8:0;0 <0AA0 A;>6=>AB59 ?@8 ?>AB@>5=88 85@0@E8G5A:>9 <>45;8 8 65;0=88 4>18BLAO =C6=>9 ?@>872>48B5;L=>AB8. !5B52K5 <>45;8 B0:65 A>74020;8AL 4;O <0;> @5AC@A=KE -. -B> 4>AB0B>G=> A;>6=K5 AB@C:BC@K, A>AB>OI85 87 =01>@>2  ?>8<5=>20==KE 42CEC@>2=52KE 45@52L52. 01>@K A>548=ONBAO A ?><>ILN 70?8A59-A2O7>:, >1@07CO F5?>G:8 8 B.4. @8 @07@01>B:5 A5B52KE <>45;59 1K;> 2K4C<0=> <=>65AB2> <0;5=L:8E E8B@>AB59, ?>72>;ONI8E C25;8G8BL ?@>872>48B5;L=>ABL !#. > ACI5AB25==> CA;>6=82H8E ?>A;54=85. @8:;04=>9 ?@>3@0<<8AB 4>;65= 7=0BL <0AAC B5@<8=>2, 87CG8BL =5A:>;L:> 2=CB@5==8E O7K:>2 !#, 45B0;L=> ?@54AB02;OBL ;>38G5A:CN AB@C:BC@C 107K 40==KE 4;O >ACI5AB2;5=8O =02830F88 A@548 @07;8G=KE M:75<?;O@>2, =01>@>2, 70?8A59 8 B.?. 48= 87 @07@01>BG8:>2 >?5@0F8>==>9 A8AB5<K UNIX A:070;: !5B520O 1070  MB> A0<K9 25@=K9 A?>A>1 ?>B5@OBL 40==K5. !;>6=>ABL ?@0:B8G5A:>3> 8A?>;L7>20=8O 85@0@E8G5A:8E 8 A5B52KE !# 70AB02;O;0 8A:0BL 8=K5 A?>A>1K ?@54AB02;5=8O 40==KE.  :>=F5 60-E 3>4>2 ?>O28;8AL !# =0 >A=>25 8=25@B8@>20==KE D09;>2, >B;8G0NI85AO ?@>AB>B>9 >@30=870F88 8 =0;8G85< 25AL<0 C4>1=KE O7K:>2 <0=8?C;8@>20=8O 40==K<8. 4=0:> B0:85 !# >1;040NB @O4>< >3@0=8G5=89 =0 :>;8G5AB2> D09;>2 4;O E@0=5=8O 40==KE, :>;8G5AB2> A2O759 <564C =8<8, 4;8=C 70?8A8 8 :>;8G5AB2> 55 ?>;59. $878G5A:0O >@30=870F8O 40==KE >:07K205B >A=>2=>5 2;8O=85 =0 M:A?;C0B0F8>==K5 E0@0:B5@8AB8:8 . 07@01>BG8:8 !# ?KB0NBAO A>740BL =081>;55 ?@>872>48B5;L=K5 D878G5A:85 <>45;8 40==KE, ?@54;030O ?>;L7>20B5;O< B>B 8;8 8=>9 8=AB@C<5=B0@89 4;O ?>4=0AB@>9:8 <>45;8 ?>4 :>=:@5B=CN . 07=>>1@0785 A?>A>1>2 :>@@5:B8@>2:8 D878G5A:8E <>45;59 A>2@5<5==KE ?@><KH;5==KE !# =5 ?>72>;O5B @0AA<>B@5BL 8E 2 MB>< @0745;5. 6.2 @>5:B8@>20=85 <>45;8 40==KE 6.2.1 -B0?K ?@>5:B8@>20=8O 40==KE @54<5B=0O >1;0ABL - G0ABL @50;L=>3> <8@0, ?>4;560I0O 87CG5=8N A F5;LN >@30=870F88 C?@02;5=8O 8, 2 :>=5G=>< AG5B5, 02B><0B870F88. @54<5B=0O >1;0ABL ?@54AB02;O5BAO <=>65AB2>< D@03<5=B>2, =0?@8<5@, ?@54?@8OB85 - F5E0<8, 48@5:F859, 1CE30;B5@859 8 B.4. 064K9 D@03<5=B ?@54<5B=>9 >1;0AB8 E0@0:B5@87C5BAO <=>65AB2>< >1J5:B>2 8 ?@>F5AA>2, 8A?>;L7CNI8E >1J5:BK, 0 B0:65 <=>65AB2>< ?>;L7>20B5;59, E0@0:B5@87C5<KE @07;8G=K<8 273;O40<8 =0 ?@54<5B=CN >1;0ABL. *@BDFLVvxz|ym^OG J L N P  T V X ¶ʭxmbhzhzCJaJhzh/CJaJh iWhO5CJaJhOCJaJh i5CJaJh iWh i5CJaJh iWh iW5CJaJh iW5CJaJhZCJaJmH sH hZCJaJh iWhzCJaJh iWh iWCJaJh iWCJaJhBicCJaJhzCJaJhCJaJ"P X ,dn#l%%%%dhgdv $dha$gdS"$ & Fdh^`a$gdn<6$dh^`a$gdn<6 dh`gdn<6$d`a$gdG <> (:< fh "26HJVZhjtxƿʹ hlPJh/CJNHaJmH sH hlPJh/CJaJmH sH hlPJh/CJNHaJhlPJh/CJaJ hn<65aJ h/5aJ hn<6hn<65aJ hlPJhr2CJaJh iWh/5CJaJmH sH h iW5CJaJmH sH 5"46<>JP\>@"(.0x """""""##"%$%l%n%t%ʺhm_hm_6CJOJQJaJhlPJhr2CJOJQJaJhlPJh/CJNHaJhlPJh/CJaJmH sH hlPJh/CJaJEt%|%%%%''D'j'( (:(F(v(V)X)V**6,8,-R-/H//00081:112·}l}l}Z}"hlPJh/5>*CJOJQJaJ hvh/CJNHOJQJaJhvh/CJOJQJaJh2CJaJhlPJh2CJaJhvh/CJaJhlPJh/CJNHaJhlPJh/CJaJhvhvCJ aJ h/56CJ OJQJaJ "hh/56CJ OJQJaJ "hm_h/56CJ OJQJaJ %(V**+R-H/@0133334689:::$ *dh`a$gdn<6gdh"$dh`a$gdIo$ *dh`a$gdIo`gdn<6$ *dh`a$gdn<622Z3\3333333v4x40525>7@789R:T:~:::::::::n;p;;;j<<<Ÿ󙎃{{obZZhGpCJaJhlPJh/CJNHaJhvh/5CJaJhlPJCJaJhlPJh/CJaJhoh/CJaJhoCJaJhvh/6CJOJQJaJ hh"hh"h/6CJOJQJaJhw>h/6CJOJQJaJhvhh"CJaJh/CJaJhvh/CJaJhvh/CJNHaJ#<<==V>>&?(?R@l@n@CCDDDDFDHD$EHHIIKKLLLLLL譝~q~q~q~q~f\Rhm_h/5aJ hm_hm_5aJ hlPJhr2CJaJhw>h/CJNHaJhw>h/CJaJ hh"hh"h/6CJOJQJaJhZh/6CJOJQJaJhh"6CJOJQJaJhlPJh/CJaJmH sH hZh/CJaJhZh/5CJaJhGpCJaJhlPJh/CJaJhlPJh/CJNHaJ:R@DDFDHD$EFF`G"HHI~JLL dh`gdtp$ *dh`a$gdn<6$ *dh`a$gdh"gdh"$dh`a$gdh"$ *dh`a$gdh"$ *dh`a$gdGpLLLLNO8P:PlPPP*CJaJh?Ph/CJaJh:h/CJaJh:h:CJaJh:h/6CJOJQJaJ,.0T~bPڎ܎ގ$dh[$\$`a$gd+tdhgd+t $dha$gdJm:$dh`a$gdJm:dhgdJm:$a$gdJm:$ & F *dha$gdMz$ *dh`a$gdn<6gdMzVXtvڌ܌\|ʎڎ܎ގ ²xhh[KhJm:h};5CJ OJQJaJ hiR5CJ OJQJaJ hJm:hZb5CJ OJQJaJ hJm:hJm:CJ OJQJaJ hJm:hJm:CJ aJ hJm:hJm:5CJ OJQJaJ h7khJm:5CJ OJQJaJ h7kh7k5CJ OJQJaJ hlPJhr2OJQJaJhlPJh/6CJaJhlPJh/CJNHaJhlPJh/CJaJhdh/6CJaJ.Z.024D.~.R*,06<tvǿo\%h7kh};56CJOJQJ]aJ%h7kh5gx56CJOJQJ]aJ%h7khiR56CJOJQJ]aJh};5CJ OJQJaJ h+tht5CJ OJQJaJ ht5CJ OJQJaJ h5gxOJQJhiR5CJ OJQJaJ hiRCJ hH'CJhH'hH'CJ h!CJ h};CJh+th+tCJ aJ #V,.0tvBdd`gdn<6 & F >dh^`gdSCdhgdn<6$a$gddydhgd+t$a$gdiR$dh[$\$`a$gd+tvʥ̥npvxhj>@pr02 J.0~ 6h"h7khiR56CJOJQJaJhX%6CJ OJQJaJ h!CJaJhh};5CJaJ hh};jhh};UUhh};CJNHaJhh};CJaJ> B5>@88 ?@>5:B8@>20=8O 8=D>@<0F8>==KE A8AB5< ?@54<5B=CN >1;0ABL (8;8, 5A;8 C3>4=>, 25AL @50;L=K9 <8@ 2 F5;><) ?@8=OB> @0AA<0B@820BL 2 2845 B@5E ?@54AB02;5=89: ?@54AB02;5=85 ?@54<5B=>9 >1;0AB8 2 B>< 2845, :0: >=0 @50;L=> ACI5AB2C5B :0: 55 2>A?@8=8<05B G5;>25: (8<55BAO 2 284C ?@>5:B8@>2I8: 107K 40==KE) :0: >=0 <>65B 1KBL >?8A0=0 A ?><>ILN A8<2>;>2. ".5. 3>2>@OB, GB> <K 8<55< 45;> A @50;L=>ABLN, >?8A0=85< (?@54AB02;5=85<) @50;L=>AB8 8 A 40==K<8, :>B>@K5 >B@060NB MB> ?@54AB02;5=85. 0==K5, 8A?>;L7C5<K5 4;O >?8A0=8O ?@54<5B=>9 >1;0AB8, ?@54AB02;ONBAO 2 2845 B@5EC@>2=52>9 AE5<K (B0: =07K205<0O <>45;L ANSI/SPARC): INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/ansi.gif" \* MERGEFORMATINET  =5H=55 ?@54AB02;5=85 (2=5H=OO AE5<0) 40==KE O2;O5BAO A>2>:C?=>ABLN B@51>20=89 : 40==K< A> AB>@>=K =5:>B>@>9 :>=:@5B=>9 DC=:F88, 2K?>;=O5<>9 ?>;L7>20B5;5<. >=F5?BC0;L=0O AE5<0 O2;O5BAO ?>;=>9 A>2>:C?=>ABLN 2A5E B@51>20=89 : 40==K<, ?>;CG5==>9 87 ?>;L7>20B5;LA:8E ?@54AB02;5=89 > @50;L=>< <8@5. =CB@5==OO AE5<0 - MB> A0<0 1070 40==KE. BAN40 2KB5:0NB >A=>2=K5 MB0?K, =0 :>B>@K5 @0718205BAO ?@>F5AA ?@>5:B8@>20=8O 107K 40==KE 8=D>@<0F8>==>9 A8AB5<K: >=F5?BC0;L=>5 ?@>5:B8@>20=85 - A1>@, 0=0;87 8 @540:B8@>20=85 B@51>20=89 : 40==K<. ;O MB>3> >ACI5AB2;ONBAO A;54CNI85 <5@>?@8OB8O: >1A;54>20=85 ?@54<5B=>9 >1;0AB8, 87CG5=85 55 8=D>@<0F8>==>9 AB@C:BC@K 2KO2;5=85 2A5E D@03<5=B>2, :064K9 87 :>B>@KE E0@0:B5@87C5BAO ?>;L7>20B5;LA:8< ?@54AB02;5=85<, 8=D>@<0F8>==K<8 >1J5:B0<8 8 A2O7O<8 <564C =8<8, ?@>F5AA0<8 =04 8=D>@<0F8>==K<8 >1J5:B0<8 <>45;8@>20=85 8 8=B53@0F8O 2A5E ?@54AB02;5=89 > >:>=G0=88 40==>3> MB0?0 ?>;CG05< :>=F5?BC0;L=CN <>45;L, 8=20@80=B=CN : AB@C:BC@5 107K 40==KE. '0AB> >=0 ?@54AB02;O5BAO 2 2845 <>45;8 ACI=>ABL-A2O7L. >38G5A:>5 ?@>5:B8@>20=85 - ?@5>1@07>20=85 B@51>20=89 : 40==K< 2 AB@C:BC@K 40==KE. 0 2KE>45 ?>;CG05< !#->@85=B8@>20==CN AB@C:BC@C 107K 40==KE 8 A?5F8D8:0F88 ?@8:;04=KE ?@>3@0<<. 0 MB>< MB0?5 G0AB> <>45;8@CNB 107K 40==KE ?@8<5=8B5;L=> : @07;8G=K< !# 8 ?@>2>4OB A@02=8B5;L=K9 0=0;87 <>45;59. $878G5A:>5 ?@>5:B8@>20=85 - >?@545;5=85 >A>15==>AB59 E@0=5=8O 40==KE, <5B>4>2 4>ABC?0 8 B.4. 07;8G85 C@>2=59 ?@54AB02;5=8O 40==KE =0 :064>< MB0?5 ?@>5:B8@>20=8O ?@54AB02;5=> 2 A;54CNI59 B01;8F5: 6.2.2 @54AB02;5=85 40==KE A ?><>ILN <>45;8 ACI=>ABL-A2O7L 07=0G5=85 <>45;8 @5645, G5< ?@8ABC?0BL : A>740=8N A8AB5<K 02B><0B878@>20==>9 >1@01>B:8 8=D>@<0F88, @07@01>BG8: 4>;65= AD>@<8@>20BL ?>=OB8O > ?@54<5B0E, D0:B0E 8 A>1KB8OE, :>B>@K<8 1C45B >?5@8@>20BL 40==0O A8AB5<0. ;O B>3>, GB>1K ?@825AB8 MB8 ?>=OB8OE B>9 8;8 8=>9 <>45;8 40==KE, =5>1E>48<> 70<5=8BL 8E 8=D>@<0F8>==K<8 ?@54AB02;5=8O<8. 4=8< 87 =081>;55 C4>1=KE 8=AB@C<5=B>2 C=8D8F8@>20==>3> ?@54AB02;5=8O 40==KE, =57028A8<>3> >B @50;87CNI53> 53> ?@>3@0<<=>3> >15A?5G5=8O, O2;O5BAO <>45;L ACI=>ABL-A2O7L (entity-relationship model, ER-model). >45;L ACI=>ABL-A2O7L >A=>2K205BAO =0 =5:>9 206=>9 A5<0=B8G5A:>9 8=D>@<0F88 > @50;L=>< <8@5 8 ?@54=07=0G5=0 4;O ;>38G5A:>3> ?@54AB02;5=8O 40==KE. =0 >?@545;O5B 7=0G5=8O 40==KE 2 :>=B5:AB5 8E 2708<>A2O78 A 4@C38<8 40==K<8. 06=K< O2;O5BAO B>B D0:B, GB> 87 <>45;8 ACI=>ABL-A2O7L <>3CB 1KBL ?>@>645=K 2A5 ACI5AB2CNI85 <>45;8 40==KE (85@0@E8G5A:0O, A5B520O, @5;OF8>==0O, >1J5:B=0O), ?>MB><C >=0 O2;O5BAO =081>;55 >1I59. B<5B8<, GB> <>45;L ACI=>ABL-A2O7L =5 O2;O5BAO <>45;LN 40==KE 2 AB@>3>< A<KA;5, ?>A:>;L:C =5 >?@545;O5B >?5@0F89 =04 40==K<8 8 >3@0=8G8205BAO >?8A0=85< B>;L:> 8E ;>38G5A:>9 AB@C:BC@K. >45;L ACI=>ABL-A2O7L 1K;0 ?@54;>65=0 2 1976 3. 8B5@>< 8=-(M= '5=><. -;5<5=BK <>45;8 N1>9 D@03<5=B ?@54<5B=>9 >1;0AB8 <>65B 1KBL ?@54AB02;5= :0: <=>65AB2> ACI=>AB59, <564C :>B>@K<8 ACI5AB2C5B =5:>B>@>5 <=>65AB2> A2O759. 048< >?@545;5=8O: !CI=>ABL (entity) - MB> >1J5:B, :>B>@K9 <>65B 1KBL 845=B8D8F8@>20= =5:8< A?>A>1><, >B;8G0NI8< 53> >B 4@C38E >1J5:B>2. @8<5@K: :>=:@5B=K9 G5;>25:, ?@54?@8OB85, A>1KB85 8 B.4. 01>@ ACI=>AB59 (entity set) - <=>65AB2> ACI=>AB59 >4=>3> B8?0(>1;040NI8E >48=0:>2K<8 A2>9AB20<8). @8<5@K: 2A5 ;N48, ?@54?@8OB8O, ?@074=8:8 8 B.4. 01>@K ACI=>AB59 =5 >1O70B5;L=> 4>;6=K 1KBL =5?5@5A5:0NI8<8AO. 0?@8<5@, ACI=>ABL, ?@8=04;560I0O : =01>@C #'+, B0:65 ?@8=04;568B =01>@C .. !CI=>ABL D0:B8G5A:8 ?@54AB02;O5B 87 A51O <=>65AB2> 0B@81CB>2, :>B>@K5 >?8AK20NB A2>9AB20 2A5E G;5=>2 40==>3> =01>@0 ACI=>AB59.  40;L=59H5< 4;O >?@545;5=8O ACI=>AB8 8 55 0B@81CB>2 1C45< 8A?>;L7>20BL >1>7=0G5=85 2840 !" # (",+_ , /,  !"). 0?@8<5@, >B45;K, =0 :>B>@K5 ?>4@0745;O5BAO ?@54?@8OB85, 8 2 :>B>@KE @01>B0NB A>B@C4=8:8, <>6=> >?8A0BL :0: " ( _", ). =>65AB2> 7=0G5=89 (>1;0ABL >?@545;5=8O) 0B@81CB0 =07K205BAO 4><5=><. 0?@8<5@, 4;O 0B@81CB0  !" 4><5= (=07>25< 53> '!_") 70405BAO 8=B5@20;>< F5;KE G8A5; 1>;LH8E =C;O, ?>A:>;L:C ;N459 A >B@8F0B5;L=K< 2>7@0AB>< =5 1K205B.  C?><O=CB>9 AB0BL5 . '5=0 0B@81CB >?@545;O5BAO :0: DC=:F8O, >B>1@060NI0O =01>@ ACI=>AB59 2 =01>@ 7=0G5=89 8;8 2 45:0@B>2> ?@>872545=85 =01>@>2 7=0G5=89. "0: 0B@81CB  !" ?@>872>48B >B>1@065=85 2 =01>@ 7=0G5=89 (4><5=) '!_". B@81CB / ?@>872>48B >B>1@065=85 2 45:0@B>2> ?@>872545=85 =01>@>2 7=0G5=89 /, $/ 8 "'!". BAN40 >?@545;O5BAO :;NG ACI=>AB8 - 3@C??0 0B@81CB>2, B0:0O, GB> >B>1@065=85 =01>@0 ACI=>AB59 2 A>>B25BAB2CNICN 3@C??C =01>@>2 7=0G5=89 O2;O5BAO 2708<=>>4=>7=0G=K< >B>1@065=85<. @C38<8 A;>20<8: :;NG ACI=>AB8 - MB> >48= 8;8 1>;55 0B@81CB>2, C=8:0;L=> >?@545;ONI8E 40==CN ACI=>ABL.  =0H5< ?@8<5@5 :;NG>< ACI=>AB8 !" # O2;O5BAO 0B@81CB ",+_  (:>=5G=>, B>;L:> 2 B>< A;CG05, 5A;8 2A5 B015;L=K5 =><5@0 =0 ?@54?@8OB88 C=8:0;L=K). !2O7L (relationship) - MB> 0AA>F80F8O, CAB0=>2;5==0O <564C =5A:>;L:8<8 ACI=>ABO<8. @8<5@K: ?>A:>;L:C :064K9 A>B@C4=8: @01>B05B 2 :0:><-;81> >B45;5, <564C ACI=>ABO<8 !" # 8 " ACI5AB2C5B A2O7L @01>B05B 2 8;8 "- "; B0: :0: >48= 87 @01>B=8:>2 >B45;0 O2;O5BAO 53> @C:>2>48B5;5<, B> <564C ACI=>ABO<8 !" # 8 " 8<55BAO A2O7L @C:>2>48B 8;8 "- #",; <>3CB ACI5AB2>20BL 8 A2O78 <564C ACI=>ABO<8 >4=>3> B8?0, =0?@8<5@ A2O7L ", - " <564C 42C<O ACI=>ABO<8 '. !;54C5B >B<5B8BL, GB> 2 <5B>48:5 ?@>5:B8@>20=8O 40==KE 5ABL A2>5>1@07=>5 ?@028;> E>@>H53> B>=0, A>3;0A=> :>B>@><C ACI=>AB8 >1>7=0G0NBAO A ?><>ILN 8<5= ACI5AB28B5;L=KE, 0 A2O78 - 3;03>;L=K<8 D>@<0<8. 0==>5 ?@028;>, >4=0:>, =5 O2;O5BAO >1O70B5;L=K<.  A>60;5=8N, =5 ACI5AB2C5B >1I8E ?@028; >?@545;5=8O, GB> AG8B0BL ACI=>ABLN, 0 GB> A2O7LN.  @0AA<>B@5==>< 2KH5 ?@8<5@5 <K ?>;>68;8, GB> @C:>2>48B- MB> A2O7L. 4=0:>, <>6=> @0AA<0B@820BL ACI=>ABL @C:>2>48B5;L, :>B>@0O 8<55B A2O78 @C:>2>48B A ACI=>ABLN >B45; 8 O2;O5BAO A ACI=>ABLN A>B@C4=8:. !2O7L B0:65 <>65B 8<5BL 0B@81CBK. 0?@8<5@, 4;O A2O78 "- " <>6=> 7040BL 0B@81CB !"_ "+__". >;L ACI=>AB8 2 A2O78 - DC=:F8O, :>B>@CN 2K?>;=O5B ACI=>ABL 2 40==>9 A2O78. 0?@8<5@, 2 A2O78 ",-" ACI=>AB8 ' <>3CB 8<5BL @>;8 @>48B5;L 8 ?>B><>:. #:070=85 @>;59 2 <>45;8 ACI=>ABL-A2O7L =5 O2;O5BAO >1O70B5;L=K< 8 A;C68B 4;O CB>G=5=8O A5<0=B8:8 A2O78. 01>@ A2O759 (relationship set) - MB> >B=>H5=85 <564C n (?@8G5< n =5 <5=LH5 2) ACI=>ABO<8, :0640O 87 :>B>@KE >B=>A8BAO : =5:>B>@><C =01>@C ACI=>AB59. %>BO, AB@>3> 3>2>@O, ?>=OB8O A2O7L 8 =01>@ A2O759 @07;8G=K (?5@20O O2;O5BAO M;5<5=B>< 2B>@>3>), 8E, B5< =5 <5=55, >G5=L G0AB> A<5H820NB. >MB><C, 2 40;L=59H5< B0:65 1C45< G0AB> ?>;L7>20BLAO B5@<8=0<8 A2O7L 8<5O 2 284C =01>@ A2O759 8 ACI=>ABL 8<5O 2 284C =01>@ ACI=>AB59.  A;CG05 n=2, B.5. :>340 A2O7L >1J548=O5B 425 ACI=>AB8, >=0 =07K205BAO 18=0@=>9. >:070=>, GB> n-0@=K9 =01>@ A2O759 (n>2) 2A5340 <>6=> 70<5=8BL <=>65AB2>< 18=0@=KE, >4=0:> ?5@2K5 ;CGH5 >B>1@060NB A5<0=B8:C ?@54<5B=>9 >1;0AB8. "> G8A;> ACI=>AB59, :>B>@>5 <>65B 1KBL 0AA>F88@>20=> G5@57 =01>@ A2O759 A 4@C3>9 ACI=>ABLN, =07K20NB AB5?5=LN A2O78. 0AA<>B@5=85 AB5?5=59 >A>15==> ?>;57=> 4;O 18=0@=KE A2O759. >3CB ACI5AB2>20BL A;54CNI85 AB5?5=8 18=0@=KE A2O759: 48= : >4=><C (>1>7=0G05BAO 1 : 1 ). -B> >7=0G05B, GB> 2 B0:>9 A2O78 ACI=>AB8 A >4=>9 @>;LN 2A5340 A>>B25BAB2C5B =5 1>;55 >4=>9 ACI=>AB8 A 4@C3>9 @>;LN.  @0AA<>B@5==>< =0<8 ?@8<5@5 MB> A2O7L @C:>2>48B, ?>A:>;L:C 2 :064>< >B45;5 <>65B 1KBL B>;L:> >48= =0G0;L=8:, 0 A>B@C4=8: <>65B @C:>2>48BL B>;L:> 2 >4=>< >B45;5. 0==K9 D0:B ?@54AB02;5= =0 A;54CNI5< @8AC=:5, 345 ?@O<>C3>;L=8:8 >1>7=0G0NB ACI=>AB8, 0 @><1 - A2O7L. "0: :0: AB5?5=L A2O78 4;O :064>9 ACI=>AB8 @02=0 1, B> >=8 A>548=ONBAO >4=>9 ;8=859. INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r1.gif" \* MERGEFORMATINET  @C3>9 206=>9 E0@0:B5@8AB8:>9 A2O78 ?><8<> 55 AB5?5=8 O2;O5BAO :;0AA ?@8=04;56=>AB8 2E>4OI8E 2 =55 ACI=>AB59 8;8 :0@48=0;L=>ABL A2O78. "0: :0: 2 :064>< >B45;5 >1O70B5;L=> 4>;65= 1KBL @C:>2>48B5;L, B> :064>9 ACI=>AB8 " =5?@5<5==> 4>;6=0 A>>B25BAB2>20BL ACI=>ABL !" #. 4=0:>, =5 :064K9 A>B@C4=8: O2;O5BAO @C:>2>48B5;5< >B45;0, A;54>20B5;L=> 2 40==>9 A2O78 =5 :0640O ACI=>ABL !" # 8<55B 0AA>F88@>20==CN A =59 ACI=>ABL ". "0:8< >1@07><, 3>2>@OB, GB> ACI=>ABL !" # 8<55B >1O70B5;L=K9 :;0AA ?@8=04;56=>AB8 (MB>B D0:B >1>7=0G05BAO B0:65 C:070=85< 8=B5@20;0 G8A;0 2>7<>6=KE 2E>645=89 ACI=>AB8 2 A2O7L, 2 40==>< A;CG05 MB> 1,1), 0 ACI=>ABL " 8<55B =5>1O70B5;L=K9 :;0AA ?@8=04;56=>AB8 (0,1). "5?5@L 40==CN A2O7L <K <>65< >?8A0BL :0: 0,1:1,1.  40;L=59H5< :0@48=0;L=>ABL 18=0@=KE A2O759 AB5?5=8 1 1C45< >1>7=0G0BL A;54CNI8< >1@07><: INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r5.gif" \* MERGEFORMATINET  48= :> <=>38< ( 1 : n ).  40==>< A;CG05 ACI=>AB8 A >4=>9 @>;LN <>65B A>>B25BAB2>20BL ;N1>5 G8A;> ACI=>AB59 A 4@C3>9 @>;LN. "0:>20 A2O7L "-!" #.  :064>< >B45;5 <>65B @01>B0BL ?@>872>;L=>5 G8A;> A>B@C4=8:>2, => A>B@C4=8: <>65B @01>B0BL B>;L:> 2 >4=>< >B45;5. @0D8G5A:8 AB5?5=L A2O78 n >B>1@0605BAO 4@52>>1@07=>9 ;8=859, B0: MB> A45;0=> =0 A;54CNI5< @8AC=:5. INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r2.gif" \* MERGEFORMATINET  0==K9 @8AC=>: 4>?>;=8B5;L=> 8;;NAB@8@C5B B>B D0:B, GB> <564C 42C<O ACI=>ABO<8 <>65B 1KBL >?@545;5=> =5A:>;L:> =01>@>2 A2O759. 45AL B0:65 =5>1E>48<> CG8BK20BL :;0AA ?@8=04;56=>AB8 ACI=>AB59. 064K9 A>B@C4=8: 4>;65= @01>B0BL 2 :0:><-;81> >B45;5, => =5 :064K9 >B45; (=0?@8<5@, 2=>2L AD>@<8@>20==K9) 4>;65= 2:;NG0BL E>BO 1K >4=>3> A>B@C4=8:0. >MB><C ACI=>ABL " 8<55B >1O70B5;L=K9, 0 ACI=>ABL !" # =5>1O70B5;L=K9 :;0AAK ?@8=04;56=>AB8. 0@48=0;L=>ABL 18=0@=KE A2O759 AB5?5=8 n 1C45< >1>7=0G0BL B0:: INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r6.gif" \* MERGEFORMATINET  =>3> : >4=><C (n : 1 ). -B0 A2O7L 0=0;>38G=0 >B>1@065=8N 1 : n. @54?>;>68<, GB> @0AA<0B@8205<>5 =0<8 ?@54?@8OB85 AB@>8B A2>N 45OB5;L=>ABL =0 >A=>20=88 :>=B@0:B>2, 70:;NG05<KE A 70:07G8:0<8. -B>B D0:B >B>1@0605BAO 2 <>45;8 ACI=>ABL-A2O7L A ?><>ILN A2O78 " "-', >1J548=ONI59 ACI=>AB8 " " ( , ! _!/, !#) 8 '(,  !). "0: :0: A >4=8< 70:07G8:>< <>65B 1KBL 70:;NG5=> 1>;55 >4=>3> :>=B@0:B0, B> A2O7L " "-' <564C MB8<8 ACI=>ABO<8 1C45B 8<5BL AB5?5=L n : 1. INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r3.gif" \* MERGEFORMATINET   40==>< A;CG05, ?> A>25@H5==> >G5284=K< A>>1@065=8O< (:064K9 :>=B@0:B 70:;NG5= A :>=:@5B=K< 70:07G8:><, 0 :064K9 70:07G8: 8<55B E>BO 1K >48= :>=B@0:B, 8=0G5 >= =5 1K; 1K B0:>2K<), :0640O ACI=>ABL 8<55B >1O70B5;L=K9 :;0AA ?@8=04;56=>AB8. =>385 :> <=>38< (n : n).  MB>< A;CG05 :0640O 87 0AA>F88@>20==KE ACI=>AB59 <>65B 1KBL ?@54AB02;5=0 ;N1K< :>;8G5AB2>< M:75<?;O@>2. CABL =0 @0AA<0B@8205<>< =0<8 ?@54?@8OB88 4;O 2K?>;=5=8O :064>3> :>=B@0:B0 A>7405BAO @01>G0O 3@C??0, 2 :>B>@CN 2E>4OB A>B@C4=8:8 @07=KE >B45;>2. >A:>;L:C :064K9 A>B@C4=8: <>65B 2E>48BL 2 =5A:>;L:> (2 B>< G8A;5 8 =8 2 >4=C) @01>G8E 3@C??, 0 :0640O 3@C??0 4>;6=0 2:;NG0BL =5 <5=55 >4=>3> A>B@C4=8:0, B> A2O7L <564C ACI=>ABO<8 !" # 8 '/_ # 8<55B AB5?5=L n : n. INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r4.gif" \* MERGEFORMATINET  A;8 ACI5AB2>20=85 ACI=>AB8 x 7028A8B >B ACI5AB2>20=8O ACI=>AB8y, B> x =07K205BAO 7028A8<>9 ACI=>ABLN (8=>340 ACI=>ABL x =07K20NB A;01>9, 0 ACI=>ABL y - A8;L=>9).  :0G5AB25 ?@8<5@0 @0AA<>B@8< A2O7L <564C @0=55 >?8A0==K<8 ACI=>ABO<8 '/_ # 8 " ". 01>G0O 3@C??0 A>7405BAO B>;L:> ?>A;5 B>3>, :0: 1C45B ?>4?8A0= :>=B@0:B A 70:07G8:><, 8 ?@5:@0I05B A2>5 ACI5AB2>20=85 ?> 2K?>;=5=8N :>=B@0:B0. "0:8< >1@07><, ACI=>ABL '/_ # O2;O5BAO 7028A8<>9 >B ACI=>AB8 " ". 028A8<CN ACI=>ABL 1C45< >1>7=0G0BL 42>9=K< ?@O<>C3>;L=8:><, 0 55 A2O7L A A8;L=>9 ACI=>ABLN ;8=859 A> AB@5;:>9: INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r7.gif" \* MERGEFORMATINET  0<5B8<, GB> :0@48=0;L=>ABL A2O78 4;O A8;L=>9 ACI=>AB8 2A5340 1C45B (1,1). ;0AA ?@8=04;56=>AB8 8 AB5?5=L A2O78 4;O 7028A8<>9 ACI=>AB8 <>3CB 1KBL ;N1K<8. @54?>;>68<, =0?@8<5@, GB> @0AA<0B@8205<>5 =0<8 ?@54?@8OB85 ?>;L7C5BAO =5A:>;L:8<8 10=:>2A:8<8 :@548B0<8, :>B>@K5 ?@54AB02;ONBAO =01>@>< ACI=>AB59:  "( _ ,!#, ! _(/, ). > :064><C :@548BC 4>;6=K >ACI5AB2;OBLAO 2K?;0BK ?@>F5=B>2 8 ?;0B568 2 AG5B 53> ?>30H5=8O. -B>B D0:B ?@54AB02;O5BAO =01>@>< ACI=>AB59 "(", !#) 8 =01>@>< A2O759 >ACI5AB2;O5BAO ?>.  B>< A;CG05, :>340 ?>;CG5=85 70?;0=8@>20==>3> :@548B0 >B<5=O5BAO, 8=D>@<0F8O > =5< 4>;6=0 1KBL C40;5=0 87 107K 40==KE. !>>B25BAB25==>, 4>;6=K 1KBL C40;5=K 8 2A5 A2545=8O > ?;0=>2KE ?;0B560E ?> MB><C :@548BC. "0:8< >1@07><, ACI=>ABL " 7028A8B >B ACI=>AB8  ". INCLUDEPICTURE "../AGU_48AF8?;8=K/Data%20Bases/2545=85%202%20%20(5;5=:>2)/img/r8.gif" \* MERGEFORMATINET  7. !" '  40==>< :C@A>2>< ?@>5:B5 ?>AB02;5=0 7040G0 A>740=8O 8=D>@<0F8>==>9 A8AB5<K 02B><>18;L=>3> ?@54?@8OB8O 3>@>40. 2B><>18;L=>5 ?@54?@8OB85 3>@>40 70=8<05BAO >@30=870F859 ?0AA068@A:8E 8 3@C7>2KE ?5@52>7>: 2=CB@8 3>@>40.  2545=88 ?@54?@8OB8O =0E>48BAO 02B>B@0=A?>@B @07;8G=>3> =07=0G5=8O: 02B>1CAK, B0:A8, <0@H@CB=K5 B0:A8, ?@>G89 ;53:>2>9 B@0=A?>@B, 3@C7>2>9 B@0=A?>@B, B@0=A?>@B 2A?><>30B5;L=>3> E0@0:B5@0, ?@54AB02;5==K9 @07;8G=K<8 <0@:0<8. 0640O 87 ?5@5G8A;5==KE :0B53>@89 B@0=A?>@B0 8<55B E0@0:B5@8AB8:8, A2>9AB25==K5 B>;L:> MB>9 :0B53>@88: =0?@8<5@, : E0@0:B5@8AB8:0< B>;L:> 3@C7>2>3> B@0=A?>@B0 >B=>A8BAO 3@C7>?>4J5<=>ABL, ?0AA068@A:89 B@0=A?>@B E0@0:B5@87C5BAO 2<5AB8<>ABLN 8 B.4. @54?@8OB85 8<55B HB0B 2>48B5;59, 70:@5?;5==KE 70 02B><>18;O<8 (70 >4=8< 02B><>18;5< <>65B 1KBL 70:@5?;5=> 1>;55 >4=>3> 2>48B5;O). 1A;C6820NI89 ?5@A>=0; (B5E=8:8, A20@I8:8, A;5A0@8, A1>@I8:8 8 4@.) 70=8<05BAO B5E=8G5A:8< >1A;C6820=85< 02B><>18;L=>9 B5E=8:8, ?@8 MB>< @07;8G=K5 2KH5?5@5G8A;5==K5 :0B53>@88 B0:65 <>3CB 8<5BL C=8:0;L=K5 4;O 40==>9 :0B53>@88 0B@81CBK. 1A;C6820NI89 ?5@A>=0; 8 2>48B5;8 >1J548=O5BAO 2 1@8304K, :>B>@K<8 @C:>2>4OB 1@83048@K, 40;55 A;54CNB <0AB5@0, 70B5< =0G0;L=8:8 CG0AB:>2 8 F5E>2.  2545=88 ?@54?@8OB8O =0E>4OBAO >1J5:BK 30@06=>3> E>7O9AB20 (F5E0, 30@068, 1>:AK 8 ?@.), 345 A>45@68BAO 8 @5<>=B8@C5BAO 02B><>18;L=0O B5E=8:0. 0AA068@A:89 02B>B@0=A?>@B (02B>1CAK, <0@H@CB=K5 B0:A8) ?5@52>78B ?0AA068@>2 ?> >?@545;5==K< <0@H@CB0<, 70 :064K< 87 =8E 70:@5?;5=K >B45;L=K5 548=8FK 02B>B@0=A?>@B0. 545BAO CG5B G8A;0 ?5@52>78<KE ?0AA068@>2, =0 >A=>20=88 G53> ?@>872>48BAO ?5@5@0A?@545;5=85< B@0=A?>@B0 A >4=>3> <0@H@CB0 =0 4@C3>9. #G8BK205BAO B0:65 ?@>153, G8A;> @5<>=B>2 8 70B@0BK =0 @5<>=B ?> 2A5<C 02B>B@0=A?>@BC, >1J5< 3@C7>?5@52>7>: 4;O 3@C7>2>3> B@0=A?>@B0, 8=B5=A82=>ABL 8A?>;L7>20=8O B@0=A?>@B0 2A?><>30B5;L=>3> =07=0G5=8O. #G8BK205BAO 8=B5=A82=>ABL @01>BK 1@8304 ?> @5<>=BC (G8A;> @5<>=B>2, >1J5< 2K?>;=5==KE @01>B), G8A;> 70<5=5==KE 8 >B@5<>=B8@>20==KE C7;>2 8 03@530B>2 (42830B5;59, , <>ABK, H0AA8 8 B.4.) ?> :064>9 02B><0H8=5, 8 AC<<0@=> ?> CG0AB:C, F5EC, ?@54?@8OB8N.  ?@>F5AA5 @01>BK ?@54?@8OB8O, A >4=>9 AB>@>=K B@0=A?>@B AB0@55B, GB> ?@82>48B : 53> A?8A0=8N, ?@>4065; 0 A 4@C3>9 AB>@>=K ?@54?@8OB85 ?@>872>48B ?>:C?:C =>2KE 02B><>18;59, :0: ?>?>;=OO 8E =0;8G85, B0: 8 70<5=OO =0 CAB0@52H89. 8. !"  $'!  +% ;O ?>AB@>5=8O 8=D>;>38G5A:>9 <>45;8 40==KE >?@545;8< ACI=>AB8 8E A2O78 8 0B@81CBK. ?@545;8< ACI=>AB8: 2B><>18;8, =02>4OI85AO 2 2545=88 ?@54?@8OB8O; !>B@C4=8:8 (C?@02;ONI89 8 >1A;C6820NI89 A>AB02K); 0@06=>5 E>7O9AB2>; >?>;=8B5;L=K5 40==K5. ?8H5< 0B@81CBK ACI=>AB59 4;O :064>9 2 >B45;L=>AB8: 2B><>18;8 >1;040NB A;54CNI8<8 0B@81CB0<8: - 3>AC40@AB25==K9 =><5@; - <0@:0; - 284 (3@C7>2>9, ;53:>2>9 8 B.?.) !>B@C4=8:8: - $; - ?@>D5AA8O (2>48B5;L, A20@I8:, A1>@I8: 8 B.?.); - ?@8=04;56=>ABL (B.5. 2 :0:>< 30@065 8;8 >B45;5 @01>B05B); - 70:@5?;5=85 (?@8<5=8B5;L=> : 2>48B5;O<, 70 :0:8< 02B><>18;5< 70:@5?;5=). 0@06=>5 E>7O9AB2>: - 284 B@0=A?>@B0 (B.5. B@0=A?>@B :0:>9 :0B53>@88 @0A?>;0305BAO 2 40==>< 30@065); - 1@83048@K; - ?5@5G5=L A>B@C4=8:>2. >?>;=8B5;L=K5 40==K5: - 8=D>@<0F8O > A?8A0==>9 8 ?>;CG5==>9 B5E=8:5; - 8=D>@<0F8O > @5<>=B0E; - 8=D>@<0F8O > @0A?@545;5=88 B@0=A?>@B0 (?> <0@H@CB0< 8 B.4.); - 8=D>@<0F8O > 3@C7>?5@52>7:0E. >AB@>8< 8=D>;>38G5A:CN <>45;L ?> >?@545;5==K< ACI=>ABO< (@8A.1):  SHAPE \* MERGEFORMAT  8A.1 =D>;>38G5A:0O <>45;L 40==KE. 9. !"  "'!  +% ;O ?>AB@>5=8O 40B>;>38G5A:>9 <>45;8 40==KE @0AA<>B@8< A2O7L <564C 0B@81CB0<8 ACI=>AB59 8 ?>AB@>8< MBC <>45;L. 0==0O <>45;L ?@54AB02;5=0 =8 @8A.2.  EMBED PaintShopPro  8A.2 0B>;>38G5A:0O <>45;L 40==KE .' 0 A53>4=OH=89 45=L @5;OF8>==K5 107K 40==KE >AB0NBAO A0<K<8 @0A?@>AB@0=5==K<8, 1;03>40@O A2>59 ?@>AB>B5 8 =03;O4=>AB8 :0: 2 ?@>F5AA5 A>740=8O B0: 8 =0 ?>;L7>20B5;LA:>< C@>2=5. A=>2=K< 4>AB>8=AB2>< @5;OF8>==KE 107 40==KE A>2<5AB8<>ABL A A0<K< ?>?C;O@=K< O7K:>< 70?@>A>2 SQL. ! ?><>ILN 548=AB25==>3> 70?@>A0 =0 MB>< O7K:5 <>6=> A>548=8BL =5A:>;L:> B01;8F 2> 2@5<5==CN B01;8FC 8 2K@570BL 87 =55 B@51C5<K5 AB@>:8 8 AB>;1FK (A5;5:F8O 8 ?@>5:F8O). "0: :0: B01;8G=0O AB@C:BC@0 @5;OF8>==>9 107K 40==KE 8=BC8B82=> ?>=OB=0 ?>;L7>20B5;O<, B> 8 O7K: SQL O2;O5BAO ?@>ABK< 8 ;53:8< 4;O 87CG5=8O. 5;OF8>==0O <>45;L 8<55B A>;84=K9 B5>@5B8G5A:89 DC=40<5=B, =0 :>B>@>< 1K;8 >A=>20=K M2>;NF8O 8 @50;870F8O @5;OF8>==KE 107 40==KE. 0 2>;=5 ?>?C;O@=>AB8, 2K720==>9 CA?5E>< @5;OF8>==>9 <>45;8, SQL AB0; >A=>2=K< O7K:>< 4;O @5;OF8>==KE 107 40==KE.  ?@>F5AA5 0=0;870 2KH587;>65==>9 8=D>@<0F88 2KO2;5=K A;54CNI85 =54>AB0B:8 @0AA<>B@5==>9 <>45;8 107 40==KE: B0: :0: 2A5 ?>;O >4=>9 B01;8FK 4>;6=K A>45@60BL ?>AB>O==>5 G8A;> ?>;59 70@0=55 >?@545;5==KE B8?>2, ?@8E>48BAO A>74020BL 4>?>;=8B5;L=K5 B01;8FK, CG8BK20NI85 8=48284C0;L=K5 >A>15==>AB8 M;5<5=B>2, ?@8 ?><>I8 2=5H=8E :;NG59. "0:>9 ?>4E>4 A8;L=> CA;>6=O5B A>740=85 A:>;L:>-=81C4L A;>6=KE 2708<>A2O759 2 1075 40==KE; 2KA>:0O B@C4>5<:>ABL <0=8?C;8@>20=8O 8=D>@<0F859 8 87<5=5=8O A2O759. !! !, " "# + >3C<8@A:89 . -DD5:B82=0O @01>B0 =0 IBM PC 2 A@545 Windows 95 !1, 8B5@, 1997. 59A:0A . -DD5:B82=0O @01>B0 A Microsoft Access 7.0 Microsoft Press, 1997. C4:>: 6., /=3 . -DD5:B82=0O @01>B0 A Microsoft Office 95 Microsoft Press. >@52 ., 0:0H0@8?>2 !., -DD5:B82=0O @01>B0 A !#: !1, 8B5@, 1997. 8@8;;>2 .. A=>2K ?@>5:B8@>20=8O @5;OF8>==KE 107 40==KE. #G51=>5 ?>A>185. - !1.: ", 1994. >B0?:8= .. A=>2K Visual Basic 4;O ?0:5B0 Microsoft Office:, -:><, 1995. C@=0; PC Magazine Russian Edition 17, 1994, AB0BLO #. ;59=0, Microsoft Access. C@=0; PC Magazine Russian Edition 15, 1994. C@=0; ><?LN"5@@0 !37-38 1994.     PAGE  PAGE 5  HYPERLINK "http://globalteka.ru/" globalteka.ru - @0<>B=>5 8 :0G5AB25==>5 2K?>;=5=85 2A5E 284>2 =0CG=KE @01>B. !:84:8, >@838=0;L=>ABL, :>=B@>;L ?;0380B0, ?@O<>5 >1I5=85 A 02B>@><. [2548B5 B5:AB] 2B><>18;8 >A. =><5@ 0@:0 84 !>B@C4=8:8 $ @>D5AA8O @8=04;56=>ABL 0:@5?;5=85 0@06=>5 E>7O9AB2> 84 B@0=A?>@B0 @83048@K !>B@C4=8:8 >?>;=8B5;L=K5 40==K5 =D>@<0F8O > ?>;CG5==>9 8 A?8A0==>9 B5E=8:5 =D>@<0F8O > @5<>=B0E =D>@<0F8O > @0A?@545;5=88 B@0=A?>@B0 =D>@<0F8O > 3@C7>?5@52>7:0E dJRP6>@dfL `gds@dhgds@`gdNgdH$a$gdH $`a$gdn<6 dh`gdn<6dhgdn<6:<>@df^` 8n $vܿ|p|c|ZN|N|hHh};CJ\aJh!CJ\aJhHh};CJNHaJhHh};CJ]aJhHh};CJaJh!CJaJhh};CJNHaJhh};CJaJh}CJaJhNh};5CJOJQJaJhHhHCJ aJ "h7khs@56CJOJQJaJ"h7kh};56CJOJQJaJ"h7kh5gx56CJOJQJaJvx(*HLz|:JɶɧwgwYYMBh)[h};CJaJh)[h};CJ\aJhh};6CJ]aJhNh};5CJOJQJaJhs@CJaJh};CJaJhh};CJNHaJhh};CJaJh!CJaJhh};B*CJaJph$hh};B*CJNH]aJph hh};B*CJ]aJphh!B*CJ]aJphhHh};CJaJhHh};CJNHaJ:    F(P~|L< `gdn<6  & F"dhgdjddhgdn<6dhgds@8`rvx:N`bNNPVz|24źœœœœœœœ}œœh)[h};CJNH]aJh}CJaJhh};CJNHaJh}h};CJNH]aJh}h};CJ]aJh}h};CJaJhh};CJaJh)[h};CJ\aJh)[h};CJ]aJh)[h};CJaJh)[h};CJNHaJ14RflnRT` b  x        RTr @(R  vPhHJ~"$$ݾݾݾݾƱƱhh};6CJ]aJh)[h};CJNHaJh!CJaJh)[h};CJaJh)[h};CJ\aJhh};CJNHaJhh}CJaJhh};CJaJ@$>t^`tvjl4FbvxL<><>ǻǮǮǝ~w~ljhh};U hh};jhh};U&h7h};56B*CJ]aJph h7h};5B*CJaJphh)[h};CJNHaJh)[h};CJ\aJh)[h};CJaJhh};6CJ]aJhh};CJNHaJh!CJaJhh};CJaJ*   f h   !!4!L!!!!<"z"|""""" #4#6#L###$b$p$$%&%%%%%&&⳨yh7h};CJNH]aJh7h};CJ]aJhYcKCJaJhh};CJNHaJhh};CJaJh!CJaJh7h};CJNHaJh7h};CJNH\aJh7h};CJ\aJh7h};CJaJ hh};jhh};U, "%&)*+.t/3l4J6<: ;p<?@GG$H&H(H$dh`a$gdy/K $dha$gdy/K $dha$gd7`gdn<6dhgdn<6&&&&&&&t'v'((*())L)r)t)))*****++*,,,,, -l------^.`.r.t...l/n/p/r/t//ѽѲⲥyjChh};Uj hh};UhYcKCJaJhh};6CJ]aJhh};CJNHaJhh};CJaJ&hh};56B*CJ]aJph hh};5B*CJaJph hh};jhh};Ujhh};U//////000T1n1p1&2(222x3333d4f4h4j4l45555J6n6x6|677>8@88899 :":,:6:<:>:;;;; ;еЭеееТеееееееТj'hh};Ujhh};U hh};jhh};UhYcKCJaJhh};CJNHaJhh};6CJ]aJhh};CJaJ hh};5B*CJaJph&hh};56B*CJ]aJph2 ;X;Z;;;;;;;<<<<P<R<p<====^>`>>>????@@@@@\A^ABBBBBCCCCCCCDDDDD齰Ƚh<CJaJjhh};U hh};jhh};Uh7CJaJhh};CJNHaJhh};CJaJhYcKCJaJh7h};CJNHaJh7h};CJ\aJh7h};CJ]aJh7h};CJaJ3DDEEFFFFGGGGGGGG"H$H&HHII"IIIJJKKLLM MHNJNOOOO"Q$QQQRտ||o|o|o|o|o|o|o|o|o|o|h^Kwhy/KCJNHaJh^Kwhy/KCJaJhy/KCJaJhrLhy/KCJaJhy/Kh%MCJ aJ hy/KCJ aJ hy/Khy/KCJ aJ hlPJhr2h};jhh};U hh};jhh};Uhh};CJNHaJhh};CJaJhYcKCJaJ+(HIMRXLZZZZP[x[[:\b\\\\P]$ & F'dha$gdy/K$dh^a$gdy/K$ & F&dha$gdy/K$7dh`7a$gdy/K$dh`a$gdy/Kdhgdy/K$a$gdy/K$dh`a$gdy/KRRdSfS4T6TUUUUVVWWXLZNZZZZt[v[0b2bbbbbbbbcDccccdʿਖwlahW;hy/KCJaJh%Mhy/KCJ aJ h%Mh%M5CJ OJQJaJ j$hahy/KCJUaJ"jhy/KCJUaJmHnHujhy/KCJUaJh2ehy/KCJaJh]hy/KCJaJh%Mhy/K5CJ OJQJaJ hy/KaJhy/KCJaJh^Kwhy/KCJaJh^Kwhy/KCJNHaJ%P]]]]]]^j^^P____6`\`v```6alaa2b$dh^`a$gdy/K $dha$gdy/K$ & F'dha$gdy/K$dh^`a$gdy/K2bbbbbeVeXeZefk$dh[$\$`a$gddhgd$a$gddhgdy/K dh`gdy/Kgdy/K $dha$gdy/K $dha$gdy/K$dh`a$gdy/Kddddddd>e@eTeVeZexg~giiiilkrkooooooop pp:pŸ~vkc[khBMCJaJh4CJaJhlPJh/CJaJh/CJ aJ h$$vCJ aJ hNhNCJ aJ hhCJNHhCJmH sH  hCJhhCJ aJ h5CJ OJQJaJ hh5CJ OJQJaJ hh3hy/KCJaJj]%hy/KUjHGXF hy/KUVhy/Kjhy/KUklooooop2qqbr$ssh & F dhdd[$\$^`gdL$ & Fdh^`a$gd0=$ & Fdh^`a$gd4$ & Fdh^`a$gdBMdhgdN $dha$gd;rw$ & F$dh1$`a$gd!$dh1$`a$gd :p@pBpFpXpfplppppppppppqqqq q.q2q>qJqPqVqXqqqqqqqqqqqqqqqqqr6r:r^r`rbr"s$s4s>s@sLsNsZs滳櫥ûh0=h/CJaJhNhLCJ hLCJh/CJaJh iCJaJh0=CJaJh CJaJhBMh/CJaJh4CJaJhBMCJaJhlPJh/CJaJhlPJh/CJaJmH sH 9Zs\sfshsnsps|s~ssssssssssssssst ttttt t,t.t0t4t@tDtFtfthtltxtzt|tttt浩ĚێssĩhLCJaJmH sH hjdhF=CJaJmH sH hF=CJaJmH sH hLhk&CJaJmH sH hk&CJaJmH sH hLh/CJaJmH sH hLhLCJaJmH sH h0=CJaJhlPJh/CJaJhlPJh/CJaJmH sH h0=h/CJaJ,slttuuuuuu u$u&u8u:uuJuLuNuPuRuTuVur\+hkhhkh5B* CJaJphpsHtH*5jhkhhkh5B* CJUaJmH phpsH tHhkh0JmHnHuh} h}0Jjh}0JUhYiPjhYiPUh/CJaJhlPJh/CJaJhLCJaJh4hk&CJaJmH sH hlPJh/CJaJmH sH hk&hk&CJaJmH sH Vuhulutuzuuuuuuuuuuuvvvѱ|f|K62.hkhh}(hkhhkh5B*CJaJphsHtH5jhkhhkh5B* CJUaJmH phpsH tH+hkhhkh5>*B*CJaJphsHtH/hkhhkh5>*B*CJaJmH phsH tH8jhkhhkh5B* CJUaJmH phpsH tH*>j/hkhhkh5B* CJUaJmH phpsH tH*+hkhhkh5B* CJaJphpsHtH*/hkhhkh5B* CJaJmH phpsH tH*vvwwNyPyRyh/CJaJ h>bbhy/Khy/KhYiPvw w w,w4w6wLwNwVwjwwwwwwwwxx@xBxxxyLyNyPygdy/KPyRy$$ & Fdhx^`a$gd<B00P1:pkh. A!"S#S$S%77 DpDd 4F  C "A ansib`^Fhvj4|<<D+n4^Fhvj4|T[` b!F9^'r ekgj5P7>,!a3|׽573x <~y=.{cRcaDj]>۶: @QhK*𘅜Y'3g*"pTejc2_0sq)Мjjcm `4yy9앂ǡ8ÔǯN hΕܪ1beIbf^|궴45Eq3v_݆u68 =b>+nuljÛ1MT>PNG  IHDRFG͎sBITLˢ PLTEotRNS@fbKGDH cmPPJCmp0712OmCIDATh˪0$A ݗYOayj8OΪ</I3LCHLLLLL̩ezpj-6;p~Ix{Iqşw>Is Pg XܹKʎ :WߥSN]VPA(D&JЭ\&:e uZiYv4Hw6ѓ u%OWNfoy'g:)NPYu׺m3=Hm_[dЁEBO?:6h{=:_7:Mk:6$m3}ęW,pxzje'z\:= =ɸZbX#FOsfwСլ!uGru5J]E?;=>\uUou5>FJ1`_~ {=yM\g](a˸9LxEֺNGO`Ƽ?\.~xLV?<9;߰o~Eybbbbbbbb|DQIENDB`DDd V  S $A?r5"`bu|7Q |v+nnu|7Q |PNG  IHDRFsBITLˢ PLTEjH}tRNS@fbKGDH cmPPJCmp0712OmIDATHA Ge#tQQ\$:ݴ_$|A\Ug܌`+y8O2;ΎV gWrי'z/͡`i wysݴZ|?KmN$h~;&pnwθ(۳[;}}V ;<i!GIENDB`IDd V  S $A?r2"`bfw]61da{> +nsfw]61daPNG  IHDR^ acsBITLˢ PLTE~tRNS@fbKGDH cmPPJCmp0712OmIDATxˎ `hlb ݛj| L=i\2}W uT?vOK9\q˝[\rLǯ .ľכz5Yz1[;_?u*Z^<@rr31W}=/xVCy q;DK#KN—8=\`eR>3 s_2;^ .8dBݿC2.TT쬢=djX W*F~)k aV2U;3r7l;Zyf8ohi#<Ǯ3<';SS\˯X5W~\O&8plc*LR NVu`Hx\F5& }_`C8>$1=m(o=T`H'HXQ/g%8%~{!TQ%}9$}2 i$r9;tiD^,7e|sLg2idd}NrvKTcO=2"Wȏԑl,,Ћ1ܾIENDB`6DdV  S $A?r3"`bzIKH$էh5+n`zIKH$էPNG  IHDRFӕsBITLˢ PLTEotRNS@fbKGDH cmPPJCmp0712OmIDAThA0DZE\*,sz_!s*51nޡ-V>KBbĈ#? P!! ̨W PےH0#B~cW8mU< q}fQ,߬gW"Af X,yx 1$dx󜆢)\ Na<>Qw{6PUMRd*d)2*R=0iJˬ,9\ΗIA;[Ta!Q ~ p%ta»c"')Ԡs8\}YkEx*XT2|` 6UV`Q9\l0"a`*NyA"zBMq'`bxTI$:&^,ncLE Z#b.I#Wo*~$LGrk&iY::Ԣb;1VnULZT/FCG ,lDQb6k^$ؐaI&̋ =FzǠPY~3 "Gw/T_~-ľ ];vU3~;`랊{*~-=H{*8vWrb#6ÿpU*C')+qъ>S:\3W9][Tl>][sҸxG2J1bĈ#?>D0.дIENDB`Dd>V  S $A?r4"`bas6~QTQY=Jk+nas6~QTQY=JPNG  IHDRFm}|sBITLˢ PLTEotRNS@fbKGDH cmPPJCmp0712Om IDAThK02Uxq G ͲW}kVHTwQ|^cpGŽvi 1qhrf/zLȹXD"2K=ߕ['8]93 dw}1Y7/ON I)?Vp&shMیBvn$[+B0[NH c~#[i^MU1"2";:lb/(8IfʲIW3V)!b0DZAAў 4 EEv*bLoO'E ('\SS W^q&5(y]<*CH储\1>q6l\QTWsU^!i\-ע+t%\AQ * *˽Ġ{'$1Ƴb*G#ˣ_' ߯ LqTO REWthƖ~΋%A֞׈;feq"_v^SS1Rm^o1]xy byL˳¾*L1ͽ#ºcPy pŔ3ʢ1Nu ŢAIq#Z+Y##C['ZϏKvΊ]v|N0b ?_XqhSH1rb@쑊/CA^Cpj'%ȕ"db$sVxFzOpllXUl][Ә]#dy;2sĀ+IENDB`Dd}V   S $A ?r8"`bAIyWw:cUP8& +nIyWw:cUP8PNG  IHDRNgsBITLˢ PLTEotRNS@fbKGDH cmPPJCmp0712OmrIDATh޽͎ ԛ7.IB=Mpgu3OArxQz9ڂLJGAw*"JSxrTOG,9P'!U%ǻ/X[ת^. \r;hZnVOO!4>-aiS5"\F'IIhF.mS|rI I5 ڬL'N}ڋe pP*<-) n [Lтj^G,킦=iOZ-DeJS!,i@޷Mbii/fS^SD^eY4@uڤ/ |hTMњZ3Z2fng[^I*Zi08rQ}ߕ~}ɒRC2gheY@eXTKʗ'd*4?,u4hЮQ~FR+wsOEfX}*- 29rP>MJ ŵvvA˶ {jsW.ݺ{ϐz776_7$9놣 9j \wGu35zrʍOCskrNr+rNZsoe9vMq4SXs+__;c 7:6`}|0R)>6(IkyZ/<֦Cs5LC; rW[XbƆW`"3j|]5CP^]lz> 蔢NQ:HjU$5Mb! cIENDB`Dd !4D  3 @@"? |Dd .^0   # A  bN|mqˌ]3*|%  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~- l m Root Entry  F oData WordDocument DObjectPool .o o_1180190536F.o@coOle CompObj_ObjInfo  F PaintShopPro PaintShopPro PaintShopPro9qImageOh+'0  0 < H T`hpxOle10Native POle10ItemName 1Tablep #kSummaryInformation(       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~                           ! " # $ % & ' ( ) * + , . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k n q r s t u v w x y z { | } ~  P( Aɡɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡźźźźźźźźźźźźźźźźźźźźźźźźźźź衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡źź桡桡桡桡桡桡桡桡桡桡桡桡źź䡡źź㡡źźޡźźźźźźźźźɡźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźźźɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡźźźźźźźźźźɡźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqź桡桡桡桡桡桡桡桡桡桡桡źɡdoqź䡡䡡䡡źɡdoqź㡡㡡㡡źɡdoqźޡޡźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźźźɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡdoqɡɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqź桡桡桡桡桡桡桡桡桡桡桡źɡdoqź䡡źɡdoqź㡡㡡źɡdoqźޡźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźźźɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡdoqɡɡdoqɡɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqź衡衡衡衡衡衡衡źɡdoqɡdoqɡdoqɡdoqź桡桡桡桡桡桡źɡdoqɡdoqɡdoqɡdoqź䡡䡡źɡdoqɡdoqɡdoqɡdoqź㡡㡡źɡdoqɡdoqɡdoqɡdoqźޡޡźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqɡdoqźźźźɡdoqɡdoqɡdoqɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡdoqɡdoqɡdoqɡɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqźźɡdoqɡdoqɡɡźźɡdoqɡdoqźźɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqɡdoqźźɡdoqź桡桡桡桡桡桡桡桡桡桡桡桡桡źɡdoqɡdoqźźɡdoqź䡡䡡źɡdoqɡdoqźźɡdoqź㡡㡡źɡdoqɡdoqźźɡdoqźޡźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqźźɡdoqɡdoqź桡桡桡桡桡桡桡桡桡桡桡źɡdoqźźɡdoqɡdoqź䡡䡡䡡źɡdoqźźźźɡdoqɡdoqź㡡㡡㡡źɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqźޡޡźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqźźɡdoqɡdoqɡźźɡdoqɡdoqźźɡźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźźźɡdoqɡdoqźźɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqɡdoqɡdoqź桡桡桡桡桡桡桡桡桡桡桡źɡdoqɡdoqɡdoqź䡡䡡źɡdoqɡdoqɡdoqź㡡㡡źɡdoqɡdoqɡdoqźޡźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźźźɡdoqɡdoqɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡdoqɡdoqɡɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqźźɡdoqɡdoqɡźźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqɡdoqɡdoqź桡桡桡桡桡桡桡桡桡桡桡źɡdoqɡdoqɡdoqź䡡䡡䡡źɡdoqɡdoqɡdoqź㡡㡡㡡źɡdoqɡdoqɡdoqźޡޡźɡdoqɡdoqɡdoqźźɡdoqɡdoqɡdoqźźɡdoqɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡdoqźźɡdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqdoqɡɡdoqźźɡźźɡdoqźźźźźźɡdoqźźźźźźɡdoqźźźźɡźźɡdoqźźźźɡdoqźźɡdoqźźźźɡdoqźźɡdoqźźźźɡdoqźźɡdoqźźźźźźɡdoqźźɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqź衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡衡źɡdoqź桡桡桡桡桡桡桡桡桡桡桡桡桡桡桡źɡdoqź桡桡桡桡桡桡桡桡桡桡桡桡źɡdoqź䡡䡡źɡdoqź䡡䡡źɡdoqź㡡㡡źɡdoqź㡡㡡źɡdoqźޡޡźɡdoqźޡźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqźźɡdoqɡźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźɡdoqɡdoqźźɡdoqźźźźɡdoqɡdoqźźźźɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźźɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡɡdoqɡdoqɡɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoqɡdoq