-
, 2007
1 . .. 3
2 BPwin 4.1.. 10
3 Erwin 4.1.. 22
4 34
5 MS ACSESS 2000. 42
6 MS SQL SERVER.. 49
7 OBDC. SQL. 52
8 .. 57
9 . 64
10 . 73
11 . 79
12 . 83
1
.
: .
.
1. .
1.1. (.)
1.2 , :
:
;
- ();
;
;
;
;
;
.
2.
2.1. .
. . , .. . , . . , .
2.2. .
, .
. .. , .
, , .
|
|
3.
3.1.
:
( , , ), , , - .
1 5 1 6 . , . . , . , , .
, .
, . , , .
. . .
.
:
;
;
- ();
, ;
.
, : (), , , , , , , .
- :
;
, :
:
;
( , , ),
.
, : (), , , , , , , .
:
;
;
;
.
, : ( ), , , (), , , , ( ).
, , , .
:
;
, ;
.
, : , , , , , , , , , , , , .
|
|
:
;
.
.
;
, : , , , , , , , .
:
;
.
, : , , , , .
:
;
.
, : ( ), , , (), , , , ( ), (), , , , , , , .
3.2. .
.
. , , , , .
, . .
- , , .
4. .
4.1. .
:
;
;
. , ,
( .).
.
, ( ).
. ,
4.2. (), .
, :
- , , . , , - , . . . , , , .
- , . . . . , .
|
|
- . , . , .
- , . , . . ( ) .
- , . . . , , .
- . , , , . , , . . .
- . , , . , , . . .
- , . , . . , .
- , , . , . . , . . . , .
4.3. .
. :
MS ACCESS 2000, MS Word 2000, MS SQL Server 2000.
5. .
1 18.06.08
1.1 .
1.2 .
2 .
2.1 . 18.02.07
2.2 ER- . . . . . 18.02.07
|
|
2.3 , . ER- . 28.02.07
2.4 . 28.02.07
3. 15.04.07.
3.1 .
3.2 T-SQL- .
3.3 T-SQL- .
3.4 T-SQL- .
3.5 T-SQL- .
3.6 . ( ACCESS VBA).
4. . , , Transact SQL. 25.04.07.
5. . 1.05.07
6. . 8.05.07
7. ;
1. .
2. .
3.
8. .
34.602-89. . . .
2
BPwin 4.1
: BPwin 4.1
, , . . , .
, . . ( ).
.
BPwin 4.1. Model Mart Connection Manager Cancel. BPwin. Create model. Name . Type Business Process (IDEF0), OK. (.1)
1 .
(Property for new model). .
General (). , . (. 2)
2 .
Numbering (). . :
Activity Number Prefix A. Show prefix ( )
Numbering Convention Use diagram numbering format.
Diagram Show prefix ( ).
Activity Number Prefix A. Show prefix ( ).
Numbering Convention 1,1.1,1.1.(use dots).
Layout, ABS Units, Display, Page setup, Header/Folder . OK.
3 Numbering
(. 4).
4
, Name. Untitled Object ( ). , Font. , Apply settings to All activity in this diagram model All activity in this model. , Global Change all occurrences of font in model. ( 5)
5
.
. (. 6) .
6 .
, . , , . . .
|
|
. Name. Arrow Properties, Arrow Name . , Style, . OK.
, , . , , . , Color.
, Label Color, Arrow Color, Both. OK.
7 .
.
, .
. Activity Box Count. , DFD (Data Flow Diagram), IDEF0 Number of Activities in this Decomposition (0-8). OK. (.8)
8 .
, .
.
, - , , - , . , . , .
, Arrow Tunnel. Border Arrow Editor. , : How do you want to resolve this tunnel? Resolve it to border arrow. ( . ) , Change it to resolve rounded arrow. , () , . (. 9) OK.
9
, :
Delete. ;
, , , .
, . , , , , . , , , , , .
, , . , Dictionary Arrow. Delete Row. Save changes .
. Data Store Tool . , Data Store. Reusable Data Store Arrow. . (. 10)
10
. External Reference Tool . , Data Store. Reusable External Reference Arrow. . (. 11)
11
. Model Mart Close Model Close without saving. OK. (. 12)
12
BPwin 4.1. Model Mart Connection Manager Cancel. BPwin. Open model, OK. (.1) . , . Parent Diagram Text font.
13
Text Diagram Font (, Arial Cyr) Change all occurrences of font in model. OK. . Parent Diagram Title Text font. Text Diagram Font (, Arial Cyr) Change all occurrences of font in model. OK. (. 13)
.
, Diagram Add Node Tree (.14).
14 Diagram
Number of Levels (. 15). .
15 . 1.
(.16). .
.
16 . 2.
IDEF0 . . , ( , , ) (, ).
, . () .
. , , , . : , , , , . (. 17)
17 .
18 AO
. (. 18), , . 4 .
- , (.19, 20).
19 A3
20 A4 -
2 . , . ( 21,22,23)
( 24). , (. 25).
21 A2
22 A2.1
23 A2.2
24 A1
25 A1.3
26 .
:
.
3. ?
4. ?
5. ?
6. ?
7. ?
8. IDEF0?
9. ?
10. ?
3
Erwin 4.1
: Erwin 4.1
Erwin . . , , . , .. .
. . . , , , .
.
Erwin 4.1. Model Mart Connection Manager Cancel. Computer Associates Erwin. Create model. OK. Create model Select Template. New Model Type Logical/Physical. Target Database, (SQL Server 2000 Access 2000). (. 1) OK. .
1
(. 2) , .
2
. , . , ( ).
, , Attributes. (. 3)
3
New. New Attribute (. 4)
Attribute Name ( ) (String). OK.
, (. 3) .
, (. 3) .
OK. , Attributes.
Delete.
4
, . .
:
--
, , , . .
, Relationship Properties. Relationships. Verb Phrase . ( ). Relationship Cardinality : Cardinality ( ), Relationship Type ( ), Null ( ). (. 5)
5
Rolename , . Rolename . (.6)
6
--
-- . Physical (), (.7).
7 .
, , . Many-to-many Transform . . Many-to-many Relationships Transform Wizard. . (. 8)
8 -- ( 1)
Table Name , . (. 9). .
9 -- ( 2)
Transform Name. .
10 -- ( 3)
. . , , . .
. Close Close without saving. OK. (. 11)
11
EPwin 4.1. Model Mart Connection Manager Cancel. Computer Associates Erwin. Create model. OK. Erwin Open File .
, . Default Font & Colors.
Tables, Columns, General Relationships Font (Arial Cyr), Apply to All Objects. (. 12)
12
(. 2) Complete sub-category . . , . . , Complete sub-category. (), .
, :
. Display Level (Atributes , Entity , Primary Key ).
. Table Display .
. Entity Display .
. Display Level (Table , Column , Primary Key ).
Display
Format Stored Display Settings. New.(. 13) OK. Stored Display (.13) .
13 Display
:
- . , , ;
- , ;
- , ;
- , ;
- ;
- - ;
- , , ;
- ;
- ;
- .
( ).
:
- ISBN;
-
-
:
;
;
--
, , .. . 1 , .. . 1
, , .. . 1 , .. .
, , .. . 1 , .. .
, , .. . 1 , .. .
, .. . 1 , .. .
, .. . 1 , .. .
, .. . 1 , .. .
, .. . 1 , .. .
--, .. , .
--, .. , .
--, .. , .
-- . (. 15).
. , . , , , . , , . .
. , .
.
14
( , ) .
, .
15 --
:
;
- , ( ), ;
- ( );
- .
( ), ( );
( ), ( );
. , ;
. , ;
;
.
( ), ( ).
16
. , . , Columns. Columns, Datatype (. 17). ( Default).
17
1. . ISBN . (, 5-414-524316-41). , ISBN 15 . varchar(20).
2. . , , , . datetime.
3. . ( ) , . (, 2431). , . int.
:
1. ERwin 4.1?
2. ?
3. ?
4. ?
5. --?
6. ?
7. ?
8. ? ?
9. ?
10. .
4
: , .
. , , () . , . , . . ( ). , . , , . , . . , , , .
, . ( ), .
BPwin , Erwin, , .
ERwin BPwin
ERwin BPwin.
ERwin BPwin ERwin File/Bpwin/Export. *. .
BPwin , File/Import/Erwin ()..., . . (. 1) Accept. Help , Cancel .
. Arrow Data.
Arrow Data Arrow Property.
1
. . .
2 Arrow Data Arrow Property
Copy In .
Clear - .
Migrate Changes to Arrow Data Associations, , ( ). :
Deletions - , , ;
Additions - , .
Changes to Arrow Data Associations Commit. IDEFO DFD. , . Data Usage Editor (. 3).
3 - BPwin Data Usage Editor
Data Usage Editor , , , , . , ; .
CRUD (Create, Read, Update, Delete), - IRUN (Insert, Read, Update, Nullify), CRUD IRUN - , . . , . . , . (Update) (Delete), (Create). , , (Read), - . , , ( ), (Delete) (Create). .
Data Usage Report
Data Usage Report ( Report/Data Usage Report).
Tools\Reports\Data Usage Report.
Data Usage Report, , . (. 4)
Report
, . (. 5) .
4 Data Usage Repor
t
5
1
Arrow Name | Entity Name | Attribute Name |
ISBN | ||
ISBN | ||