Информатика 1 курс 1 семестр / informatika_uchebnik_Makarova

. ,

.

:

;

.

.

.

– , ,

, , .

– ,

–

),

.

- , ,

( ), , .

( ) – ,

. , ;

" " . ,

.

– ,

) , , , , (

, ). " " .

19.44.

:

[ ; ; 23.02.1980; 126543]

:

: [ ; ; 23.02.1980]

] = 345234

:

: [ ; ; 23.02.1980]

, 1979 .:

: ] >=01.01.1980 AND

] < 01.01.1981

,

100000 – 200000:

: ] >= 100000 AND

] < 200000

		1.1.80	233244

]:

		12.12.80	123245
		1.1.80	233244

611

6.6.81

553435

. ( )

:

– ,

. , ,

.

, – .

19.45. ( )

( ) .

(

). ,

:

		12.12.80	123245
		1.1.80	233244
		12.1.80	123247
		1.1.80	233244
:
		12.12.80	123245
		1.1.80	233244
		12.1.80	123247

– ,

( ). ,

, , – .

19.46. ( )

( ).

, :

612

		12.12.80	123245
		1.1.80	233244
		12.1.80	123247
		1.1.80	233244
:
		1.1.80	233244

– ,

, . ,

, , – ;

,

– .

19.47. ( –

) (

).

:

		12.12.80	123245
		1.1.80	233244
		12.1.80	123247
		12.1.80	123247
		1.1.80	233244
:
		12.12.80	123245

:

1:1 – – ,

( ). 1: – – ,

,

.

,

1: .

19.48. [

613

], ([ ], [

], [ ]), [ ]

.

,

,

. ,

[ ], .

.

– ,

. " ",

.

19.49. ([ ],

]).

– ([ ], [ ], [ ], [

], [ ], [ ]).

, ,

, .

						12.12.80					123245
						1.1.80					233244
1
2
							.
					12.12.80		123245		1
					12.12.80		123245		2
					1.1.80		233244		1
					1.1.80		233244		2

, .

– , – ,

, ,

:

– ;

–

.

19.50. ,

.

– [ ].

614

						.
			12.12.80			123245
			1.1.80			233244
			12.1.80			123247
		.
1		123245		3
1		233244		4
2		233244		5
2		123245		5

			.		.
		12.12.80	123245	1	123245	3
		12.12.80	123245	1	233244	4
		1.1.80	233244	2	233244	5
		1.1.80	233244	2	123245	5
		12.1.80	123247	,

– ,

,

.

19.51.

( . ).

,

, ,

) .

,

. –

, – .

–

.

:

dBASe- ,

;

, ;

SQL- ,

.

dBASe-

615

, , dBASe, Paradox, FoxPro, Clipper, Rbase .,

, ,

dBASE- (X-Base).

dBASe.

, ( ,

Assist .), ( ),

.

(CREATE, MODIFY, UPDATE, DELETE .).

( ) ,

( ). ,

. (

– 1).

:

, ( ,

);

.

,

:

APPEND BLANK, BROWSE, CHANGE, EDIT, INSERT - , (

);

DELETE – ( ); SEEK, FIND, LOCATE – ;

COPY – ; CONTINUE - .

:

RECORD n – n;

ALL – ;

NEXT n – n , ;

REST – , .

FOR WHILE.

1 ( ) :

, .

, :

2 , : WHILE

] < 1.1.80

, FIELDS,

.

19.52.

DELETE FOR 1 WHILE 2

( ) ,

1. ,

2.

COPY TO FIELDS FOR 1 WHILE yc 2

, 1, 2,

,

.

, ,

616

.

:

, .

19.53.

JOIN WITH FOR FIELDS

,

, . ,

.

,

.

,

:

(DO WHILE .... END DO);

(IF ... ELSE ... ENDIF);

(DO CASE ... OTHERWISE ...ENDCASE) .

dBASE-

,

, ,

.

( )

Q B E (Query By Example),

, , Microsoft Query.

.

.

)

(

).

) ( )

.

, :

–

:

*

+

-

/

– : > ( )

>= ( ) < ( )

<= ( ) <> ( )

= ( ).

– ,

617

:

(AND) – .

(OR) – .(NOT) – .

: BETWEEN – .

IN – .

IS – Null , ( ) (

).

LIKE – .

:

;

, ;

, .

19.55.

1.1.79 –1.1.80 :

1.1.79- 1.1.80 :

QBE

:

QBE ( )

:

Avg – ; Count – ;

– ; Min – ; Sum – .

, .

19.56.

1.1.79 – 1.1.80 :

al .

.

19.57.

618

:

– , today –

.

,

, .

19.58. , 4 5,

( ):

–

. : , , ,

. , 4 5.

QBE ( )

, .

: ONLY – – ,

NO – ,

EVERY – – , EXACTLY – .

SET.

19.59. ,

, 123456

(INSERT),

(DELETE) (CHANGETO).

SQL

SQL

SQL (Structured Query Language) – ,

(ORACLE, dBASE IY, dBASE Y, Paradox, Access

619

.).

SQL

, ,

. SQL , –

, ,

, , . SQL

.

SQL.

SQL

1. .

: , ( ).

.

:

	- ;
1, 2	- ;
	– ;
	– ;
1, 2	- ( );

– .

.

( ):

CONSTRAINT {PRIMARY KEY | UNIQUE |

REFERENCES [( )]}

(

):

CONSTRAINT {PRIMARY KEY ( 1[, 2 [,....]]) | UNIQUE

1[, [, ...]]) | FOREIGN KEY ( 1[, 2 [, ...]]) REFERENCES [( 1 [, 2 [,...]])]}

:

UNIQUE - ( ,

, );

PRIMARY KEY - ( ;

);

FOREIGN KEY – (

);

REFERENCES – .

19.60.

CREATE TABLE

([ ] TEXT,

] TEXT,

] DATETIME,

CONSTRAINT UNIQUE ([ ], [ ], [ ]))

, :

620