Bazy_dannykh_Uchebnoe_posobie
.pdf. 38.
, , 1 (
1), R1, 1 A1, A2, A3.
().
. 39. ().
, , 1 (
1), |
|
|
A1, , |
A1.1, A1.2 |
. ( |
|
, |
), |
|
: |
R1, |
|
1 |
A1.1, |
R2, |
1 |
A1.2. |
|
|
|
( |
). |
|
|
|
, |
( ). |
|
|
|
( ). |
141
|
. 40. |
|
|
|
|
|
|
( |
). |
|
|
|
, |
|
, |
1 ( |
|
|
1), |
A1, |
AA1, A |
2 |
. |
( |
, |
: |
, ICQ), |
|
: |
|
R1, |
|
1 |
A1.1, |
|
|
R2, |
1 |
A1.2. |
|
|
. 1:1.
.
. 41. , 1:1.
, , 1 ( 1) 2 ( 2), A1 2, 1:1 1
2 2.
R1 1 1 2 R2 2 2.
142
. 1:1.
.
. 42. , 1:1
|
, |
|
|
, |
|
1 |
( |
1) |
2 ( |
2), |
|
A1 |
2, |
|
|
1:1 |
|
|
|
1 |
|
|
|
|
2 |
|
2. |
|
|
R1 |
|
1 |
1 |
|
|
R2 |
2 |
2, |
1. |
|
|
. 1:1.
.
. 43. |
|
|
|
, |
1:1 |
|
|
|
|
. |
|
|
, |
|
|
, |
1 |
( |
1) |
2 ( |
2), |
A1 |
2, |
1:1 1 2 2.
: R1 1 A1, R2 2 A2, R1 2 A2.
143
. 1:.
.
. 44. |
|
|
|
, |
1:M |
|
, |
|
|
, |
1 |
( |
1) |
2 ( |
2), |
A1 |
2, |
1:M
1 2 2.
: R1 1 A1, R2 2 A2, 2.
. 1:.
.
. 45. , 1:M
|
|
|
|
n- |
|
|
, |
|
|
, |
1 |
( |
1) |
2 ( |
2), |
A1 |
2, |
1:M
1 2 2.
: R1 1 A1, R2 2
A2, 2 R3 1 & 2.
. :.
.
144
. 46. , 1:M
|
, |
|
|
, |
1 |
( |
1) |
2 ( |
2), |
A1 |
2, |
:M
1 2 2
.
: |
R1 |
|
1 |
A1, |
R2 |
2 |
A2, 2 |
R3 |
|
1 & |
2. |
|
. 47. |
|
|
|
|
|
, |
|
|
, |
1 |
( |
1) |
2 ( |
2), |
A1 |
2, |
:M
1 2 2
.
: |
R1 |
|
1 |
A1, |
R2 |
2 |
A2, 2 |
R3 |
|
1 & |
2. |
145
.
, .. ,
,
(, , ),
..
78:
. 48. 38 MS
Access.
CASE
CASE Computer-Aided Software
Engineering.
,
,
CASE-
.
,
.
, , CASE- (Computer Aided Software/System Engineering). , ,
.
.
146
CASE- ER-.
«» .
. Oracle Designer (Oracle),
Power Desinger (Sybase) .
.
AllFusion AllFusion ERwin
Data Modeler |
AllFusion Process Modeler ( |
BPwin) |
. |
|
Interface Ltd. |
« |
|
» |
AllFusion |
ERwin Data |
Modeler, |
, AllFusion Process Modeler.
. , .
147
:
1. |
|
. |
SQL. |
.: |
. 2010, 228 . ISBN: 5-85582-010-6 |
|
|
|||||||
2. |
. . |
|
|
|
: |
. |
|
. |
6- |
. |
.: |
|
|
|
|
|
, 1998. |
784 . |
|
|
|
|
|
|
|
|
|
|
|
3. |
|
., |
., |
. |
|
|
: |
|
|
|
, |
|
|
|
|
|
. |
|
|
. 2- |
.: |
. |
|
. |
.: |
|
|
|
|
« |
|
», 2000. |
1120 . |
|
|
|
|
|
|
|
|
|
|
|
4. |
|
. . |
|
|
|
|
|
: |
|
|
|
2000 |
: |
. |
|
. / |
. |
|
. . . |
|
|
. |
.: |
|
|
|
|
, |
|
1999. |
479 . |
|
|
|
|
|
|
|
|
|
|
|
|
|
5. |
|
. |
|
|
|
|
|
. 8- |
|
. |
|
.: |
, 2003. |
|
800 . |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6. . . |
|
. |
[ |
|
|
|
]. 2008. URL= |
|
|
|
|
|||
http://www.twirpx.com/file/71205/ |
|
|
|
|
|
|
|
|
|
|
148
N1 «»
:
.
. |
Access. |
.
:
, .
10 . :
, , , , , . -:
X-XXX-XXX-XX-XX,
, , ,
.
.
:
MS Access. -.
N2 «»
:
,
. Access.
:
1
. .
.
:
MS Access.
.
N3 «»
:
149
.
.
:
: |
. |
Access. ,
, 2 (). , 1 .
.
, :
,
,
,
.
:
MS Access.
.
N4 «»
:
.
Access.
:
:
, «»,
, ,
.
:
MS Access.
.
N5 « SQL»
:
SQL. PostgreSQL.
150