. , , . . . , - , , . , , .
, . ( , ).
- (-join). - , R S, F. F R. iS.bi, (<, <=, >, >=, = ~). , - - R S.
(equi-join). -. F (=), (equi-join).
(natural join). R S, , .
- R S .
(outer join). . , . , . .
, R, S, .
NULL. , , SQL. , , .. , .
|
|
, . , , NULL.
(semi-join). , R, R S.
, , . .
. , . , R , S , (.. ). = , .. R, S. R, , S.
. , . , , .
- . , .
. . , Branch Staff (. 14).
14
Staff
Branch
, (superkey) .
, , , , .
, , .
R :
. R ;
. .
|
|
. , . Branch. City (, ). . , , ( n) , n . , Tel_No Fax_No .
, , . , -, , . - , . , -. , . , Branch , Staff LName, . , , LName .
, .
-, . , . , , , . , , . Branch Bno, Tel_No Fax_No.
, ( , ) .
, . , n Branch Staff , . Branch n , Staff , . Staff no . , n Staff , .. n Branch. .