:
2-
10 1/9
:
1-2
, . . (system catalog) (data dictionary). (meta-data) . .
Nokia C7 | 1108010 | |||
Motorola Droid V3 | 1108010 | |||
LG P500 | 1006010 |
(1, 2,)
(, , , , )
(entity) (, , , ), .
, .
.
(relationship) . .
, , , , - , .
, , .
1. (DLLData Definition Language), ..
2. , , (DML Data manipulation Language), . DML: , , , ; , , (SQL Structured Query Language )
3. , ; , ; , ; , ; , .
|
|
4. ( DLL ) - .
.
, , , . , Cobol, Fortran, Ada, Packal SQL, 3- . , , , .
. , . . . ()
. ,
;
;
;
;
, ;
;
;
.
.
.
1.
( Data Administrator) : , , , ,
( Database Administrator) , , , , . .
2.
(.. ) , .
. , . .
3. , .
4. .
, ( ).
|
|
. , .
.
1. .
2. , , . , , . ( ).
3. .
4. .
5. . (.. , )
6. .
7. , , . .
8. .
9. .
10. .
11. .
12. : , .
13. : .
14. .
.
1. .
2. .
3. .
4. .
5.
6. .
7. : .
ANSI American National Standard Institute ( )
SPARC Standards Planning and Requirements committee ( )
1975. ANSI-SPARC .
N |
2 |
1 |
3 :
. , , , , , . , , , . ( ), ( ) . , . , .
, , . .
|
|
- , , .
- , .
- () , .
:
- (object-based) ,
- (record-based),
- .
2 , .
:
, , .
:
- -, ER- (Entity-Relationship model).
- .
- .
-- .
- (relational data model).
-
- .
3
, :
, . , , , n- .
1 | 2 | 3 | n | |
D11 | D12 | D13 | D1n | |
D21 | D22 | D23 | D2n | |
D31 | D32 | D33 | D3n | |
Dm1 | Dm2 | Dm3 | dmn | |
D1 | D2 | D3 | dn |
.
, , . :
1. .
2. .
3. , .
4. .
.
.
() .
:
(1,2.)
. :
(1, 2)
:
1. .
2.
3. .
4. ( )
, , , , , .
4
, .
, .
, .
.
. |
. , . , . , 1, , . , ̻, , . :
|
|
1:
1:1
:1
:
2 : 1- ; 2-
- , . , : .
: .
Nul . : , , . . : , .
,
:
5-6
, , , .
SQL (Structured Query Language).
, , .
8 , 2 :
1.- , , (), .
2. , , , .
R1 R2 R R1 R2.
R1 MINUS R3
R1=(A1,A2,..AN)
R2=(B1,B2,..,BN)
, R1 R2 , , R1 R2.
- , .
2.1 (, , )
R A() R , , A() .
R[A(r)] = {r|r R^A(r) = }
R where ()
2.2
R B R[B] , R, B.
R = {r[B]}
R []
2.3
7
15-16
8
1. . .
- .
- : , , .
- .
- .
- .
-1 .
- .
- 2 .
- .
2.
1NF
. , . :
- *-
( ) .