, . :
, , ;
, ;
.
. , 70-, , . , 80- .
, ( ) ( ), . . , . .
, , , , .
. , , , ( ""), "" (, , ). ( , , Ingres/Postgres).
. . , . . .
|
|
() . . . . .
, . , , . ().
, .
-. . 9 - R. R ( ) D i, () K j (). R, {Di}, () D1*D2*..*Dn
- (. . 1) (1, 2,...). d . Di. j. R .
R={j}, J=1- m j={d1j, d2j,dnj},
n ; ;
j ;
m , .
.9. -
. , , , . "", .
. , "" , , ( , ).
: , . " " " " , . , , 1 V.7 .
, . { , ( , )}. "" - . , 6-. , ( , , , ). ( ) .
|
|
, ( ) , . . :
WORKER [ WORKER-ID, NAME, HOURLY-RATE, SKILL-TYPE, SVPV-ID]
: SKILL-TYPE SKILL
SVPV-ID WORKER
ASSIGNMENT [ WORKER-ID, BLDG-ID, START-DATE, NUMBER-OF-DAYS]
: WORKER-ID WORKER
BLDG-ID BVILDING
BVILDING [ BLDG-ID, ADRESS, TYPE, QLTY-LEVEL, STATVS]
SKILL [ SKILL- TYPE, BONUS-RATE, HOURS-PER-WEEK]
, . , , { , , , . "" ( , ). , "" , .. , "" . , .
, . , , "-" "-", , . , . , .
. -. -. . : . .
, , -; . " ", " ". , . .
, .
, ( ) , .
-. - , . , , .
, , , . , .
|
|
, -. .
, ( ) . . . , , .