.


:




:

































 

 

 

 


Cache




һ

 

,

. .-. ,

..

____________________

- һ

 

3 . 080116

 

________ ..

 

 

2012


34 ., 22 ., 17 , 5 , 4 .

, -, IDEF0, DFD, IDEF3, IDEF1X, , CACHE, CSP.

- .

:

- - ;

- - ;

- Cache;

- Web- .

IDEF0, DFD BPwin, IDEF1X ERwin CSP Cache.

:

- - ;

- - ;

- Cache;

- Web- .

.


. 4

1 . 5

2 . 6

3 . 7

4 Cache. 9

5 CSP. 11

. 12

.. 13

.. 14

. 17

.. 21

. 26


 

, . [1, 2] [3, 4] , - . , , . , , , . , , . , .


 

. , , , .

( , ..), , , . , .

, () .

, , - .

, , - , , , .. .

 


 

, - - BPwin 4.1.

, .

: . , , , , .

: - .

: .

: (AS-IS) , .

: .

-0 ( .1), 0 ( .2), 1 ( .3), 2 ( .4), 3 ( .5), .


 

 

, ER- ( .1) 3, ERwin 4.1.

( 1 - 8).

1

Independent
Dependent
Independent
Independent
Dependent
Independent
Independent

 

2

INTEGER
INTEGER
DATE

 

3

INTEGER
INTEGER
VARCHAR(20)

 

4

INTEGER
DATE
INTEGER
VARCHAR(20)
INTEGER
DATE
DATE
DATE

 

5

INTEGER
VARCHAR(20)
VARCHAR(20)
VARCHAR(20)
INTEGER

 

6

INTEGER
INTEGER
INTEGER

 

7

INTEGER
INTEGER
INTEGER

 

8

INTEGER
VARCHAR(20)
VARCHAR(20)
INTEGER

 


Cache

 

, Cache [5] ( .2) , ERwin 4.1.

( 9 - 15).

9 CLIENT

ClienNo INTEGER
Name VARCHAR(50)
Address_obj VARCHAR(50)
Telephone VARCHAR(20)
Pasport INTEGER

 

10 CONT_EST

EstimateNo INTEGER
ServiceNo INTEGER
Work_volume VARCHAR(20)

 

11 CONTRACT

ContractNo INTEGER
Signing_date DATE
ClienNo INTEGER
Address_obj VARCHAR(50)
Cost INTEGER
Start_date DATE
End_date DATE
Payment_deadline DATE

 

12 ESTIMATE

EstimateNo INTEGER
ContractNo INTEGER
Total_cost INTEGER

 

13 ORDER

OrderNo INTEGER
ClienNo INTEGER
Registration_date DATE

 

14 SERVICE

ServiceNo INTEGER
Name VARCHAR(50)
Work_unit VARCHAR(20)
Price_of_workunit INTEGER

 

15 WISH

WishNo INTEGER
OrderNo INTEGER
ServiceNo INTEGER

 

.






:


: 2016-10-23; !; : 399 |


:

:

,
==> ...

1799 - | 1659 -


© 2015-2024 lektsii.org - -

: 0.017 .