-
2.
: .
: 230103 ( ).
: . : , , .
: .
:
- .
: .
: 2 .
: , .
:
1. ?
2. ?
:
1. .
2. .
3. .
: .
: , .
: 2 .
: .
:
1. .., .., .. : . .: : -, 2003. 352 .: . ( ).
2. .. .: , 2002. 376 ., . + - .
.
1.
, , , , , .
:
- ()
. .
:
I. ().
C:\ \-31 Books. .
II.
1) Database Desktop ( Delphi). , , .
C:\ \-31\Books, DBD , File | Working Directory DBD. c File | New | Table. ().
:
Fields Name ;
Type ;
Size ( );
Key *, . , , . , .
|
|
:
. | ||||
BookNumb | Short | * | ||
() | Authors | lpha | ||
BookName | lpha | |||
YearPub | Short | |||
VolPages | Short | |||
DatePost | Date | |||
Comment | lpha |
: Required " ( ).
(Save As),
CatalogBooks
III.
. , ( ), ( ) . , , ( ).
"()" "", , .
, , Table Properties Secondary Indexes, , Define, (), () . , (AuthInd, BookInd) ( , ). Define , , (Authors, BookName). .
: ( ) . , .
IV. .
1. DBD Table / Edit Data .
2. :
BookNumb | Authors | BookName | YearPub | VolPages | DatePost | Comment |
.. | 30.06.1970 | |||||
.. | 01.02.1978 | |||||
.. | 20.01.1971 | |||||
. | 15.07.1989 | |||||
.. | 01.11.1977 | |||||
.. | 10.06.2001 | PocketBook | ||||
. | 12.08.1987 | |||||
. | 20.07.1992 | |||||
.. | 15.07.2001 | PocketBook | ||||
.. | 15.07.2001 | PocketBook | ||||
. | 03.05.2003 | |||||
. | 15.04.2003 |
2.
|
|
( 1), :
1. ( .) .
2. , , .
3. 1975 2000 , .
4. , , ( ., ., ..), , IN ( ).
5. , OR.
6. , , NULL.
7. , , COUNT.
8. , .7, , 2 . ( HAVING).
9. (, , , ), 2001 , EXTRACT.
10. (, , , ) . DELAY (). .
:
I. .
1. SQL Explorer .
2. Object\New. .
3. (Path).
4. Apply .
5. Enter SQL SQL , . 1 (. ) . , SQL Explorer. SQL Explorer (.. SQL ), . , .sql ( BksDr.sql) . Edit\Select All, Save to file, .
6. . 2-10 .