.
.
S () | |||
SN | NAME | GROUP | SPEC |
P () | |||
PN | PNAME | TEACHER | KAFEDRA |
SP () | |||
PN | NAME | SN | OCENKA |
{SN,PN} {OCENKA}, .
, R - , Y R, Y R Y R.
, SP {SN,PN} SP.
, .
PN NAME SP.
R X Y R Y R Y.
R Y .
PN {PN,NAME,SN,OCENKA}.
R -> Y , R.
R, PN .
, . : {SN,PN}->SP {SN,PN}->NAME {SN,PN}->OCENKA
, R X Y Z, X ->Y Y->Z, , X->Z.
, .
.
. ( ) . , . , , , , . SP NAME, S . . .
|
|
.
:
1- (1);
2- (2);
3- (3);
- ();
4- (4);
5- (5\).
, . , 2, 3, () .
:
1. ;
2. ;
- , , , .
. , . 1 , .
. . , .
SP .
SP | |||
PN | NAME | SN | OCENKA |
SP1() | ||||
OCENKA | SN | SPEC | GROUND | PN |
SN |
SPEC |
Group |
OCENKA |
PN |
, .{GROUP SPEC SN }.
|
|
SP1. INSERT () , . DELETE .
Update , . SP1 SP2,S
SN |
GROUP |
SPEC |
OCENKA |
PN |
SN |
SP2 SP
INSERT SP2, .
, () . , . SP SP2 2 SN {SN,PN}. SP SP2 SN SP1.
SP2 Group -> SPEC . Insert , . SP2 DELETE . UPDATE . , SP2 SG GS.
SG | |
SN | GROUP |
GS | |
SPEC | GROUP |
SPEC |
GROUP |
GROUP |
SN |
( .) 2, 3 .
SG | |
SN | GROUP |
GS | |
SPEC | GROUP |
SG GS 3 SN GROUP.
3 . .
|
|
. . SP1 SP, SG, GS .
SP1 SN,GROUP {SN,PN}. SN, PN . SP1 .
SP, SG, GS .
PR() | ||
PN | GROUP | PZAN |
, , . , .
, . , {PN,PNAME,PZAN} . . : , .
. R {A,B,C} (->->B) .
PN->->PNAM PN->->PZAN.
, , . . . 4 ->-> . R(A,B,C).
, PQ(_) PZ(_);
PQ | |
PN | PNAME |
PZ | |
PN | PZAM |
4 . . , , . P1 ():
P1() | ||
TEACHER | KAFEDRA | PNAME |
. . {TEACHER,KAFEDRA,PNAME} . 4 . . . R {x,y,z} *{x,y,,z}.
. :
|
|
TK = {TEACHER, KAFEDRA}
TP={TEACHER,PNAME}
KP={KAFEDRA,PNAME}
*(TK,TP,KP).
. :
TK | |
TEACHER | KAFEDRA |
TP | |
TEACHER | PNAME |
TP | |
TEACHER | PNAME |
5 , 5 . .
, .
2 . . 3.
3 . . .
, . 4.
4 , . 5.
.
, , . , . .
:
1. . . , .
2. . , . , .
3. . .
4. , , (), , .
.
. , . , . 3.
, , . , . , - .
|
|
( ER- ). ER .
. , ER .
ER , .
, |
.
, - .
- , , , - . . , ( ) ( ).
, . , , , . - .
. , . һ , , , , .
, . , . c .
, , , , . , , .
, ER , . , ER . .
1 ER- c , .
2 . .
, , . .
ER :
. - .
, .
. , . .
. ( 1) , . .
. , ().
, . , , , , , , .
ER :
, - . .
; . , ; , ;
. , . , .( ). \ .
1, . . - .
, ;
, : - . , . ; . 1 ( ) .
: . , , : . , . . , , , ; .
, .
. , , . . .
. . .
(, , , ) : 1 . 2 . begin. Commit, ; ROLLBACK .
COMMIT , . .