:
1) , (DDL Data Definition Language). DDL , , ;
2) , , , (DML Data Manipulation Language). DML , (query language). , , , . DML (procedural) (non-procedural) , . , , , . DML , , DML , . (Structured Query Language SQL), . (SQL S-Q-L, See-Quel.) SQL 2;
3) :
, ;
, ;
, ;
, , ;
, .
. 11 : .
11.
, .
|
|
1. . , , . , , , . , . , .
2. . . , , . , , . , .
3. . , . . . , , , , . , , /, .
4. . . , .. , . . , , 40 000 , , .
5. . . , . , . , . (, , ). , , , , , , , .
|
|
6. . . , , , , , .
7. . , , . , , ( ), . , . , .
8. . . , , . , .
9. . , , . , , , . , , , . , 400 $, SQL-:
SELECT *
FROM property_for_rent
WHERE type=Flat AMD rent>400;
10. . , . , . , , . , . ( ).
|
|
11. . , . , 40 41 , , . : , . . , .
12. . , . , .
13. . . , . , , , , . .
1. . , , . , , , . , .
2. . , , .
3. . . , . , , . , , .
4. . , , . , , , , . .
|
|
5. . . , , . , .
6. . , , . , - . , .
7. . . , .
, , . , . . , .
, , , , . . , , , . , . , , . , , , .
:
1. .
2. . , . IBM PC, . . , . . .
3. . , .
|
|
4. , , . .
.. (E.F.Codd) 1970 . . :
. , , ;
, . , , .. ;
.
, . 70- IBM -, , (Astrahan), System R, (). . , , , , , , . - . , System R , SQL, ISO (International Organization for Standardization) , , 80- (DB2 SQL/DS IBM, ORACLE ORACLE Corporation).
, , INGRES (INteractive GRaphics REtrieval System), ( ) , System R. INGRES , System R. INGRES, .
Peterlee Relational Test Vehicle IBM, , (Todd, 1976). , System R INGRES. , , , .
70- 80- . , , . Access FoxPro Microsoft, Paradox Visual dBase Borland, R:Base Microrim.
, .
, , , -, .