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