. .
, .
() , , .
, ( ).
.
3 |
1 |
2 |
1: . .
: , , . .
( ): , .
:
1.
2.
3.
. , , , , . .
-301 | . | 25.06.1991 | ||
412 | . | 02.03.1997 | ||
303 | . | 15.04.1999 |
-
-
, . , , .
: , , .
, . .
, . , .
. . . . . \ . ( ) , , - , , , ,. IBM - IMS.
|
|
. . .
. . , , .
: :
1. .
2. .
3. , .
1 2
4 3
-
+ =
IDEF |
R- |
, . :
.
( ).
, , . data flown diagram. . ER ER. . . .
, . , , .
|
|
, .
- , , .
.
MySQl |
,
.
.
, ( ), ( ). : , . .
. . , . ( ).
. . , , . . ( ).
KOD | NAME | ||
25.50 | |||
17.05 | |||
. |
KOD, NAME, SUMM .
KOD 5216, NAME , SUMM 25.50 .
. , . . , .
. : , , .. , , . . , , .
|
|
: , , .
:
1. . . , .
2. . .
3. . , . .
4. , , . .
:
1. .
2. , .
3. , , .
4. , , , .
5. ( ). .
6. , . , , .
.
.
, .
KOD | NAME | SUMM | phone |
KOD | ADRES |
KOD | NAME | SUMM | phone | Group |
KOD | name |
, . . :
, ( ) 0 .
|
|
1 ∞
∞ 1
, .
∞ ∞
∞ |
∞ |
∞ |
∞ |
. , , , .
. .
, . ( ). , , . , . (): . .
. B , , .
.
. ( ) (NULL - ). , ?
. :
. .. ;
- . ( ) , . , , , .. .
, . :
. , .
|
|
. . , , , .1
, , .
U |
- . . , , .
- . .
, .
. 8 :
( )
( )
( )
:
.
.
.
.
, .
.
, .
( ) ( ) . , .
:
, , .
.
(), . . , , . , , , . . : , , , .
, . , , , .
. . , . . . , . - . , , . , , , .
, . .
: , . , , .
.
union , intersect , minus . A where B, , . 1 2
A where C1 AND C2 (A where C1) intersect (A where C2)
A where C1 OR C2 (A where C1) union (A where C2)
A where C1 not C2 (A where C1) minus (A where C2)
, (and, or, not). 1, 2,,an , 1,2,,an. , 1 b1, 2 b2< an bn. - .
, , . . , , ( comp op b) ( comp op const) , const- . Comp-op . , , , .
, . , (=) . . , , . . . , .
. {a1,a2,..,an,b1,b2,,bm}
B {b1,b2,,bn} b1 A b1 B . {aj} , {bj} c b. (,b) B (b).
(), v <v,w> {w} b B.
. : (, ) (), . , .
(, , , ), (_, _, ) . 25. :
1. , _ =_;
2. _>25.
3. C _, _.
, . : _ _ _ _>25. . . .
, , . . , . , . .
Byte | Integer | String | Char | |
M | ||||
N | ||||
K | ||||
RANGE. RANGE IS . . . _ ._.
, . , , . ._=123456. . AND, OR, NOT, IFTHEN. . F var EXIST ( ) var (F) FORALL( ) var (F) .
, . . , . . .
1)EXISTS 2 (C.1_> 2._)
2)FORALL 2 (C.1_> 2._)
1 2 , , 1 2 _ . 2 1 2 . .
. , . .
:
Var.attr , var.
Var , Var.attr1, Var.attr1 Var.attr .
New_name = var.attr; .
. . ( ). ( ).
, . R n- (a1, a2, an) R(ai1:Vi1,ai2:Vi2,aim:Vim) (m<=n). Vij . , R , . Vij aij . Vij .
, . , . , .
. , .