,,,
:
:
: ..
: . .,
...,
. , 2008.
1.
2. ,
3.
4.
5.
6.
7. -
8.
9.
10. ( )
11. (TO-BE)
1.
(Ô) , , , . 2 2008 9 1. Ô , , - , . Ô .
, , , , - - , , -1, -2 . - . , , , .
Δ - (є).
2. Ô
- , 1978 . . - , , , - , ( ).
. 1.2, :
: , , , () - . , .
, : , - , (), . , , , .
, : , , , .
(, Ը, , ), , (, , , ..).
1.
3.
, 34-601-90 , :
.
.
.
.
.
.
, , .
. , , . ( , , ), . : , , ,
.
. 2
-
, , 1
4.
1
|
/ |
|
||
| 1 |
( ) |
|
|
| 2 |
|
|
|
| 3 |
|
|
|
| 4 |
|
,
|
|
| 5 |
, , . |
||
| 6 |
. |
||
| 7 |
. |
, 2
2
|
/ |
|
|
||||
| 1 |
|
01 |
.. |
03.06.08 | 2 | 05.06.08 |
| 2 | 02 |
.. |
07.06.08 | 1 | 07.06.08 | |
| 3 | 03 |
.. |
08.06.08 | 1 | 08.06.08 | |
| 4 | 04 |
.. |
09.06.08 | 3 | 11.06.08 | |
| 5 | 05 |
.. |
14.06.08 | 4 | 17.06.08 | |
| 6 | 06 |
.. |
19.06.08 | 3 | 21.06.08 |
, . .
. 2.1. 100 50 8 , ( ) ( ).
( ), () . (, 5 8 ), .
2
5.
(AS-IS) 3 Case Bpwin.
.3
. 4 () .
. 5 .
7. ( )
( ) : , , . : /, , 3com, , . , , 100 / . TCP/IP (Nransmission Protocol/Internet Protocol). , - . -, , .
8. -
, . , , . , . 3 - : , .
, , .
3
| - " " | |||||||
| 1- | . 1 | . | - . | - | |||
| () | , | 1 40 | 347,21 | 20 | 70,8 | 20 | 5528,2 |
|
|
2 | 416,66 | 45 | 158,55 | 4 | 1032,44 | |
| 1 | 30 | 104,16 | 8 | 28,36 | 30 | 2274 | |
| 2 | 2 | 416,66 | 40 | 139,83 | 1 | 276,83 | |
| : | 9111,47 | ||||||
3 9- . 109337,64 . , .
4
| 22 500 . | 2 280 . | 850 . | 2500 . | 28 130 . |
= 28 130/9111,47= 3 , .
:
(TO BE)
(Access), .
, , ,
9.
( ϔ). .
: . 3 620 . 40-12-81
: 5- , . 32 21 . 37 75 17.
34-602-89 .
: 25 05 08.
28 10 08.
( ), : 1) PowerPoint Case BPwin. 2) Access Erwin.
. . . . 2. 2. . , .
, , ( ).
, . Microsoft Windows XP Professional 2002 Service Park2. Windows XP Professional, MS Office. Access .
:
, , . . : , .
, .
,
. .
, ().
. , ..
. .. Access Microsoft Office Windows XP Professional.
.. SQL,VBA Access.
, , ,
,
: IBM PC Microsoft Windows. Access
Case , ERwin, Bpwin (IDEF0). : Oracle, Access, dBase IV, FoxPro . .
10.
2.1
| / | ||
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | , | |
| 7 |
1
| (PK) | (FK) | ||
| (30) | |||
| (1) | |||
| . | (8) | ||
| (25) | |||
| (15) | |||
| (20) | |||
| (20) |
2
| (PK) | (FK) | ||
| / | |||
| (20) | |||
3
| (PK) | (FK) | ||
| / | |||
| (20) | |||
4
| (PK) | (FK) | ||
| / | |||
| (20) | |||
5
| (PK) | (FK) | ||
| / | |||
| (20) | |||
6
| (PK) | (FK) | ||
| / | |||
| (20) | |||
7
_Ϩ
| (PK) | (FK) | ||
| / | |||
| (20) | |||
8
ب
| (PK) | (FK) | ||
| / | |||
| (20) | |||
9
| (PK) | (FK) | ||
| / | |||
| (20) | |||
4
. 4
, .. .
1
: _
SQL:
.
SELECT _.[/], .[ ], .[ ], .[ ], .[ ], .[ ]
:
FROM
WHERE (((.[ ]) Like 'In(SELECT(([].[ ]*[].[ ])*[].[ ])*2'));
2
: _
SQL:
.
SELECT .[/], .[ ], .[ ], .[ ], .[ ], .[ ]
:
FROM _
WHERE (((.[ ]) Like 'In (SELECT(([].[ ])*([].[ ]))*([].[ ])))'));
3
: _
SQL:
Ĕ.
SELECT .[/], .[ ], .[ ], ., .[ ], .[ ], .[ ], .[ ], .[ ] AS 1
Ĕ:
FROM
WHERE ((([].[ ]) Like 'In(SELECT((((((3,14)*(([].[ ])*([].[ ])))/4)+([].[ ]*[].[ ])*2)+([].[ ]*[].[ ])+([].[ ]*[].[ ])))))) ';
4
: _
SQL:
Ĕ.
SELECT .[/], .[ ], .[ ], .[ ], _.[ ], .[ ], .[ ], .[ ]
Ĕ:
FROM
WHERE (((.[ ]) Like 'In(SELECT((((([].[ ]+[].[ ])*[].[ ]))*(0,5))*2)+(((([].[ ]+[].[ ])*([].[ ])*(0,5))*2)))))'));
6
: _
SQL:
.
SELECT .[/], .[ ], .[ ], .[ ], .[ ]
:
FROM
WHERE (((.[ ]) Like 'In(SELECT([].[ ]*[].[ ]))'));
7
: __
SQL:
_Ϩ .
SELECT _Ϩ.[/], _Ϩ.[ ], _Ϩ.[ ], _Ϩ.[ ], _Ϩ.[ ]
_Ϩ :
FROM _Ϩ
WHERE (((_Ϩ.[ ]) Like 'In(SELECT([_Ϩ].[ ]*[_Ϩ].[ ]))'));
8
: _
SQL:
ب .
SELECT ب.[/], ب.[ ], ب.[ ], ب.[ ], ب.[ ]
ب :
FROM ب
WHERE (((ب.[ ]) Like 'In(SELECT([ب].[ ]*[ب].[ ]))'));
9
: _
SQL:
.
SELECT .[/], ., .[ ], ., .[ ], .[ ], .[ ], .
, :
FROM
WHERE (((.[ ]) Like 'In(SELECT([].[ ]*[].[ ])') AND ((.)='In(SELECT([].[ ]-[].[ ])'));
.
10
: _
SQL:
, : .
SELECT .[/], . , .[ ], .[ ], .[ ], Abs([ ]-[ ]) AS , Round([]/[ ]) AS [ ]
FROM ;
5
. 5
6
.6
. 7
Access
. 8 -
9
. 9
10
. 10
.
. 11
11. ( )
. MS Excel.
11.1
| 0 1 | 0 2 | 0 3 | 0 4 | |
| 1 | ||||
| 2 | - | |||
| 3 | - | |||
| 4 | ||||
| 5 | ||||
| 6 | - | |||
| 7 | - | |||
| 8 | _ | |||
| 9 | _2 | _ | ||
| 10 | ||||
| 11 | __2 | |||
| 12 | ||||
: 802
11.2
| "" | |||||
| / | |||||
| 10 | 20 | 30 | 40 | 50 | |
| a | 1 | 1 | 1 (15) | 2,96 | 4 |
| b | 2 | 1 | 17 (150) | 2,47 | 4 |
| c | 3 | 1 | 29 (150) | 1,73 | 3 |
| d | 4 | 1 | 18 (150) | 1,53 | 1 |
| i | 5 | 1 | 45 250x250- | 1,28 | 1 |
| f | 6 | 1 | 6 800x800 | 2,56 | 2 |
| g | 7 | 1 | 32 800x600 | 1,92 | 3 |
| h | 8 | 1 | 36 600x600 | 1,44 | 1 |
| i | 9 | 1 | 42 400x400 | 1,20 | 1 |
| j | 10 | 1 | 10 500x500 | 1,00 | 1 |
| k | 11 | 1 | 12 500x500 | 1,00 | 1 |
| l | 12 | 1 | 800x800 | 0,90 | 2 |
| m | 13 | 1 | 800x600 | 0,78 | 2 |
| n | 14 | 1 | 600x600 | 0,66 | 4 |
| o | 15 | 1 | 600x500 | 0,54 | 5 |
| p | 16 | 1 | 500x500 | 0,39 | 2 |
| q | 17 | 1 | 500x400 | 0,33 | 6 |
| r | 18 | 1 | 400x400 | 0,28 | 3 |
| s | 19 | 1 | 1500x40 | 0,06 | 30 |
: 28 (150) 30 : 101c30
11.3
| "" | ||||||
| / | ||||||
| 11 | 22 | 33 | 44 | 55 | 66 | |
| a | 1 | 5 | . 12 7 | 89222113409 | ||
| b | 2 | 4 | . 10 134 | 89121043546 | ||
| c | 3 | 4 | . 35-108 | 89224356676 | ||
| d | 4 | 4 | . 12 | 8905894780 | ||
| e | 5 | 4 | . 23 56 | 83536899067 | ||
| f | 6 | 4 | . 33 124 | 8 9 226 345 446 | ||
: b223344 4 . 201b223344.
11.4
| "" |
|
||||||
| / | |||||||
| 111 | 222 | 333 | 444 | 555 | 666 | ||
| a | 1 | 0,5 | 3,125 | 17 ( 150) | 3,00 | 2 | |
| b | 2 | 0,5 | 3,125 | 1 ( 150) | 2,00 | 3 | |
| c | 3 | 0,5 | 3,125 | 6 | 3,00 | 3 | |
| d | 4 | 0,5 | 3,125 | 32 | 2,00 | 2 | |
| e | 5 | 0,5 | 3,125 | 33 | 1,00 | 5 | |
| f | 6 | 0,7 | 3,125 | 0,12 | 3 | ||
| g | 7 | 0,7 | 3,125 | 0,90 | 2 | ||
| h | 8 | 0,7 | 3,125 | 0,15 | 2 | ||
| i | 9 | 0,7 | 3,125 | 0,19 | 5 | ||
| j | 10 | 0,7 | 3,125 | 0,23 | 3 | ||
| k | 11 | 0,7 | 3,125 | _ | 0,06 | 2 | |
| l | 12 | 0,7 | 3,125 | _ | 0,05 | 3 | |
| m | 13 | 0,7 | 3,125 | _ | 0,02 | 4 | |
| n | 14 | 0,7 | 3,125 | _ | 0,02 | 6 | |
| o | 15 | 0,7 | 3,125 | _ | 0,03 | 7 | |
| p | 16 | 0,7 | 3,125 | ( 150) | 2,96 | 3 | |
| q | 17 | 0,7 | 3,125 | ( 150) | 2,47 | 3 | |
| r | 18 | 0,7 | 3,125 | 1,73 | 2 | ||
| s | 19 | 0,7 | 3,125 | 1,53 | 3 | ||
| t | 20 | 0,7 | 3,125 | 1,28 | 4 | ||
| u | 21 | 0,7 | 3,125 | 0,90 | 4 | ||
| v | 22 | 0,7 | 3,125 | 0,78 | 5 | ||
| w | 23 | 0,7 | 3,125 | 0,66 | 3 | ||
| x | 24 | 0,7 | 3,125 | 0,34 | 3 | ||
| y | 25 | 0,7 | 3,125 | 0,54 | 4 | ||
: 6ϔ c444. 202444.
12 () (TO-BE) .
. 12.1-
1.1 . 1.2 ( ). 1.3 (, , ..). 2.1 . 3.1 . 3.2 . 4.1 ( ). 4.2 . 4.3 . 5.1 .
1
, .
1. 34.602 89.
2. , Access MS Office Windows.
3. . .
4. , ( ) .
5. () .
6. .
7. , 2.501.
2
, . , 5- .
_____________
..., ..
______________
Access
Pentium IV, .
ϔ
_________
3
( )
|
, |
||||
|
|
5- |
20 10 08 |
|
, |
||||
|
|
|
20 10 08 |
1. .. , .. , .. є 2003.
2. .. - 2005.
3. . Microsoft Access 2003 .
4.http://www.northerncrown.ru/Tekhn_oper/Tekhnologicheskaja_set_proektirovanija_/index.html e- .
5. http://www.nist.ru/hr/doc/gost/19201-78.htm .
6. http://www.bp-arkadia.ru/publication20.htm , , .
7. http://revolution./programming/00036080_0.html - .
8. .. 2008.
:
Copyright (c) 2024 Stud-Baza.ru , , , .