. , , ,

,,,

,

,

( )

:

:

:

: .

. .

:

: -1-93

:

1996

.............................................................................................................3

...........................................................................................................4

..............................................................................4

1. .................................................................................5

2. ................................................................................24

2.1

........................................24

2.2 MS ACCESS2.0.

Access..........................................................................24

2.3 ...................................................................................27

2.4 ....................................................29

2.5 ..............................................................33

2.6 .........................................................................33

3. ..........................................................................35

4. ...........................................................................36

5. .............................................................................36

6. .. .............................36

.....................................................................................................39

..........................................................................40

:

: , ,

, : -1-93

: .

. .

1.

1.1

1.2. ..

1.3

1.4

1.5

1.6

1.7

1.8

, ..

1.9 ..

2. -

2.1 1.1, 1.2, 1.3 ꠠ 20.02

2.2 1.4, 1.5 5.03

2.3 1.6, 1.7 19.03

2.4 1.8 9.04

2.5 1.9 16.04

3. 13.02.96 .

: __________________

:__________________

__________________

__________________

() , , (), (). , , , . - , .

. "", . , : , . , - - , - . , .

. : ( ) . . .

, : , , . ( Microsoft Access 2.0, Access 2.0) .

1.

- , , .

- , , :

- ;

- ;

- ;

- ;

( )


)

.1

" " () (enterprise, universe of discourse).

, , . "" ""; , , "" . "" , . (. .2) , "", "" (entity), "" (thing). - , , , , , .. , - . - , "" - , , , .., , .

򠠠 򠠠


,

. 2ࠠ .2

"" "". "" , , , , , . , - , , , . . , , . , - : , - . (. .2)

. , . . .

. :

򠠠 ⠠ ⠠ 堠 -2-93

:

1. . .

2. . . .

- , .

, .

- .

.

.

.3 . . - , . ( , ). , .

. .

, , - . " , ..., , , , ..., , ". : , , . .



堠 堠

.3

, .

, g0, g1, ..., gt, ... , 0, 1, ..., t, ... , gt - g0, g1, ..., gt-1. . . .

, .3.



.4

. . .

, .

, - , . () .

, - , .

:

1. - .

t0 - ;

t0t - t t;

, .

.

.

.

2. - , . , .

j .

t (t1)obt (t2)obt, , :

(t1)obt Ì (t2)obt

(t1)obt Ç (t2)obt = 0

( ), .

:

1. SUP

t1 sup t2 - t1 t2 (() ())

. ,

" t (t1)obt £ (t2)obt

. , - .

:

sup 堠 sup

sup sup sup sup

.5

(. . 6).

sup sup

򠠠 sup

sup

򠠠


sup sup sup sup sup

sup sup

sup sup

. . .

sup sup

.6 . . . .

.

2. PART OF. , PART OF.

ti PART OF tj

.

ti tj.

sup sup


PART OF PART OF


PART OF


PART OF


PART OF


PART OF

. 7

, , , .

(. .8)

sup sup


PART OF PART OF


PART OF PART OF


PART OF PART OF

.8

3. ISA

.. ISA

4. INSTANCE OF (INS)

⠠ INS -1-93

,

name (O1) INS name (O2)

t1 INS t,

t2 INS t,

..........

tn INS t, t

t1,t2...tn, t

.

(INS) ,

PART OF - .

INS

INS INS

INS

蠠 堠

蠠 蠠 蠠

.9

1. PART OF SUP :

t1 SUP t2 ; t2 SUP t3

t1 SUP t3

򠠠 SUP SUP

.10

SUP ; SUP

SUP

INS :

2. t1 INS t2 ; t2 INS t3 ; tn-1 INS tn INS

, tn INS t1

3. t1 SUP t2 ; t2 INS t3

t1 INS t3

SUP ; INS

INS

INS

ꠠ INS


SUP

.11

4. name (O) ISA t1 ; t1 SUP t2

name (O) ISA t2

ISA ; SUP

ISA

(t, ni, ti);

堠 t, ti - ,

ni - ,

( - , ) i=1,..., ,

ni¹nj, i¹j, t, ni: tt (ti)t,

(ni - . - t - t1)

1 2 t ni

{n1t(O1), n2t (O1,..., nkt(O1)}

{n1t(O2), n2t(O2,...,nkt(O2)},

.

:

t ni ti

(, , )

(, , )

(, , )

(, -21-17, )

(, -11-25, )

(ni , ti) COMPONENT OF t

COMPONENT OF , ti t.

COMPONENT OF

COMPONENT OF COMPONENT OF

n1  n3 n2

t1  t3 t2

.12

:

"" (. . . )

t

n1

n2

n3

t1

t2

t3

sup sup

sup sup

.

.

.

ins ins

.

.

.

. . . . . . . . .

. . . . . . . . . . . . . . .

. . . . . . . . .

.

 

{(t, ni, ti)| i=1...k} , " , .

:

t -

t1 -

t2 -

t3 -

t4 -

t5 -

,

{(t, ni, ti)| i=1...k}

X={ti1, ..., tip}

Y={tj1, ..., tjs}

, Y X, t 1, 2 Î tt : ni1t(O1) = ni1t(O2)

. . .

nipt(O1) = nipt(O2),

:

nj1t(O1) = nj1t(O2)

. . .

njst(O1) = njst(O2)

: X={t4, t5, t6} Y={t1, t2,t3}

t

t1 t2 t3 t4 t5 t6

min

 

.

1. (t1Èt2),

(t1Çt2), .

{ ti INS t | i=1,...,k}, È ti , t.

{(ti SUP t)| i=1,...,k}, t=Èti , ti t.

:

= È È

Ç = Ç=

= Ç = 0

2. .

(, , )

t n1 t1

= {, }

t2 =

t3 =

t2 t3 (t/t1)

t

n1

n2

t1

t2

- , t1/(t2,t)

ER -

ER -

(Entity Relationship Diagram)

. - 1983 .

1. ( )

2. ( )

3.

( (, ))

1, 2, ..., n

2) R1, R2, ...,Rn

򠠠



򠠠


񠠠

.13

3. ()

Ei, Ri -

-

.



.14

.15

. 16

. 17

𠠠

.18

.

.


堠 蠠

.19

""

.20


堠 .

. 21


. 22

" " - .

堠 頠


򠠠

. 23

, , .

򠠠


. 24

. - .

(. . 25)


. . . 蠠 . . .


. . .

蠠 . . . 堠 . . .


. . . . . . . . . . . .

. 25.

- , . , .

, .

-

{ - - - - - }

.

sup sup


isa

. 26

, , . .

 

2.

, . " " . , , () .

. , .

2.1

, , :

HARD ( ):

þ : IBM ;

þ : 486 SX-33Mhz, RAM 4Mb, VideoRAM 512Mb, 45 Mb .

HDD, VGA, "";

SOFT:

þ = MS-DOS 5.0 ,

ÿ MS Windows - 95;

þ = ÿ MS Windows 3.xx

( , ÿ MS Windows -95)

þ = MS ACCESS2.0,

ÿ MS Windows 3.xx,

MS ACCESS7.0 for ÿ MS Windows -95;

2.2 MS ACCESS2.0

Access

MS ACCESS2.0 - MicrosoftÒ. - , , MicrosoftÒ ÿ MS Windows 3.xx ÿ MS Windows -95.

ÿ MS Windows, , . .

Access , :

1. ÿ MS Windows;

2. Access- (Program Manager) , Access ( "Microsoft Access";

Access

Access ( ) - Access. . . , . , Access.

Access File (). File () , , Access , .

( Access)

Access , Windows.

Help () .

, - Cue Cards ( ) - , Access.

Wizards () , , Cue Cards . Wizards, - , Access , , .

- ALT+F4 ( ).

Access

Access :

- Access ALT+F4.

- Access.

- Close ().

- . . - .

, , , (. ). , Access . .

, , Access (datasheet).

() Access. . . . , .

 

- . , . - .

Access, . , Access .

. - Access. , , , . Access, , , .

Access .

2.3

, , Access, .

, :

1. . : ,

,

.

2. . : ,

,

.

3. . : ,

,

.

4. -. : ,

.

5. . : ,

.

6. . : ,

,

(, ).

7. . : ,

,

.

8. . : ,

.

, . , .

Access Access New Database (). FileName , , , "Klasses" . Access . , Klasses , Access: (Table), (Query), (Forms), (Report), (Macro), (Module). , . 8 , , . . :

1. Klasses ( )

2. Atribute -

3. Atr_klass -

4. Rod_vid - -

5. Structur -

6. Sv_klass -

7. Type_sv -

8. Code_sv -

, .

2.4

, . , , .

- , - - .

Klasses , , " ". Klasses.

, :

,

,

.

, Access.

1. , (. )

2. . - . .

3. , , ..

4. , . , .

5. .

, " ", :

1. Access.

2. Access . . (klasses.mbd).

 

 

 

.

- () - (Table), (Query), (Forms), (Report). .

- New (), Open (), Design (). New, Access, . ( Table , ).

New, - . . New Table ( ). , TABLE-DESIGN ( ).

, , , , .. , . , 8 , 64 .

. . . . , , " " Tab. Access " ". "" Data Type ( ) . Text (), - . . - "Counter" ().

Tab . . : .

 

, " ", - . Access , .

1. , " ".

2. , .

Access :

TEXT (). .

MEMO (). . 32 000 .

NUMBER (). .

CURRENCY (). .

DATE/TIME (/). .

COUNTER (). .

YES/NO. ().

OLE object ( OLE). , Windows.

Tab. . Access . :

15

15

, , , - .

File Save. Save As ().

Access - Table1 (1). "".

, , - . , , - .

, . . .

- Atribute

Counter

15

15

- Atr_klass

Number

Number

15

- Rod_vid

Number

Number

- Structur

Number

Number

- Sv_klass

Counter

Number

20

- Type_sv

Counter

15

20

- Code_sv

Number

Number

2.5

Access "Klasses.mdb". "". ( , Table). .

. . , , Access .

( ).

"Counter", Access .

.

Access .

Access .

2.6

Access : -- --.

. . . , -- . , , , .

 

(Edit) Relationships ( ).

- "" " ":

1. "" " " , .

2. , .

3. " " " ".

4. .

, , "".

5. , . 27.

6. Relationships. Access , , "".

, Del ( Relationships).

, - .. . . . .

, . , ..

Access Find () Query (), , - ( - ).

. , , Access, Access , , Access.

Access , .

3. ..

1. :

)

)

)

2. :

) SUP

)

3. :

)

)

)

:

1.

2.

3.

4.

5. -

6.

7.

8. -

9.

10.

11.

12.

13.

14.

15.

16.

4.

.. :

1. ..

2. ..

3. ()

4. -

5.

6.

5.

1.

2. ()

3.

4.

5.

6.

7.

8.

9.

10.

11. "", ""

12.

13.

14.

6. ..

-

: .

: . ACCESS2.0.

(. )

 

 

 

 

: ():


SUP SUP SUP

񠠠 _ _


SUP SUP SUP SUP SUP

񠠠 頠 頠 "" ""


ISA ISA ISA ISA

"" "" "" ""

 

PROLOG:

sup("","")

sup("_","")

sup("_","")

sup("","")

sup("_","")

sup("_","")

sup("_","_")

sup("_","_")

sup("","_")

sup("_","_")

sup("","_")

isa("","")

isa("","")

isa("","_")

isa("","_")

isa("","_")

isa("","_")

isa("","_")

isa("_","_")

isa("_","_")

isa("_","_")

isa("","")

isa("","")

isa("","_")

isa("","_")

isa("","")

isa("","")

isa("","")

isa("","")

ACCESS:

1.

1

**

2

**

3

**

4

-

**

5

-

**

2.

1

**

2

**

3

**

3.

1

1

1

2

1

3

4. - (SUP)

1

2

1

3

5. (ISA)

4

5

6.

1

2

**

2

3

**

3

4

**

4

5

**

7.

1

SUP

**

2

ISA

**

8.

1

1

1

2

1

3

2

4

" ; ; " . , , , . MS ACCESS 2.0.

MS ACCESS, .

MS WORD 6.0 for Windows. Epson LX-100.

, .

1. .. ., , , 1989., - 286 .

2. - , , , , , , 1992., - 174.

3. , ACCESS 2 for DUMMIES, , 1996., - 249 .

4. V .

, ( ) : :

 

 

 

! , , , .
. , :