玩转“关系代数“

短命女 2022-08-08 03:21 209阅读 0赞

用实例来说明关系代数：

![Center][]   ![Center 1][]

# 一、 基本关系代数运算 #

## 1、并 ##

R∪S=\{t|t∈R∨t∈S\}

上述例子进行并（R∪S）运算：

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">f</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话形容：取所有。

## 2、差 ##

R-S=\{t|t∈R∧t∉S\}

上述例子进行差（R-S）运算:

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：取不同，R-S，在R中不在S中。

## 3、广义笛卡儿积 ##

R×S=\{t|t=<tn,tm>∧tn∈R∧tm∈S\}

上述例子进行广义笛卡儿积（R×S）运算:

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">R.A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">R.B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">R.C</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">S.A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">S.B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">S.C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：一一对应组合在一起。

## 4、投影 ##

πA(R) =\{t\[A\]|t∈R\}

上述例子进行投影（πA,C(R)）运算:

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：取出它要求的列。

## 5、选择 ##

σF(R)=\{t|t∈R∧F(t)=True\}

上述例子进行选择（σA>B(R)）运算:

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：选择满足条件（A>B）的行

# 二、扩展的关系代数运算 #

## 1、交 ##

R∩S=\{t|t∈R∧t∈S\}=R-(R-S)=S-(S-R)

上述例子进行交（R∩S）运算：

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：在R中也在S中。

## 2、 连接 ##

### (1) θ连接 ###

上述例子进行θ连接（连接的条件是R.A<S.B）:

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">R.A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">R.B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">R.C</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">S.A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">S.B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">S.C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：先进行笛卡儿积运算，再按给定的条件投影。

### (2)自然连接 ###

公式比较复杂，在此省略。

举例：

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
 </tbody> 
</table>

关系R

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">D</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">C</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">d</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
 </tbody> 
</table>

关系S

进行自然连接：

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">D</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">a</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">g</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：选择相同列，比较相同元素组保留，去重，组合。

## 3、除 ##

举例：

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">D</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">h</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">b</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">l</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">c</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">e</span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
  </tr> 
 </tbody> 
</table>

关系R

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">C</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">D</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">d</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">e</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">f</span></p> </td> 
  </tr> 
 </tbody> 
</table>

关系S

进行除（R÷S）运算：

<table> 
 <tbody> 
  <tr> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">A</span></strong></span></p> </td> 
   <td style="background:#9BBB59"> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">B</span></strong></span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">a</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">b</span></p> </td> 
  </tr> 
  <tr> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px"><strong><span style="color:black; background:white">c</span></strong></span></p> </td> 
   <td> <p><span style="font-family:KaiTi_GB2312; font-size:24px; color:black; background:white">k</span></p> </td> 
  </tr> 
 </tbody> 
</table>

自己的话：选择相同的行（R中一行对应S多行），去掉重复的列，留下剩余的列。

我最喜欢的学习方式，就是每学到一个新的东西，看完它的描述之后，我都会用自己的话来为自己描述一遍，可能是几个词，可能是几句话！能够帮助我们理解这个新的东西！

[Center]: https://img-blog.csdn.net/20150429202257409?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvc2hpcWlqaWFtZW5namll/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 1]: /images/20220805/5102794ef3d5443b91bee6d1a95b728c.png

发表评论取消回复

表情：

评论列表（有 0 条评论，209人围观）

还没有评论，来说两句吧...

相关阅读

相关 MATLAB代数

在MATLAB解决基本的代数方程组 solve 命令用于求解代数方程组。在其最简单的形式，solve 函数需要括在引号作为参数方程。例如，让我们在方程求解x， x-5 =

浅浅的花香味﹌/ 2023年10月17日 15:05/ 0 赞/ 44 阅读

相关关系代数优化

数据库 – 关系代数优化（语法树优化）关系代数优化是指通过对关系代数表达式的等价变换操作来提高数据库的查询效率。关系代数有5大基本操作：包括并( Union，U )

Dear 丶/ 2023年01月13日 08:59/ 0 赞/ 98 阅读

相关线性代数笔记【矩阵】

矩阵基础矩阵是一个矩形排列的数表最早人们为了解决方程组求解问题发明了矩阵矩阵由m x n个数aij(i、j都是从1到m、n的整数)排成的m行n列的数表

绝地灬酷狼/ 2022年11月15日 14:20/ 0 赞/ 397 阅读

相关 ER图转关系模型

（1）实体类型的转换将每个实体类型转换成一个关系模式，实体的属性即为关系的属性，实体标识符即为关系的键。（2）联系类型的转换 1. 实体间的关系是1对

冷不防/ 2022年11月13日 04:12/ 0 赞/ 233 阅读

相关玩转“关系代数“

用实例来说明关系代数： ![Center][] ![Center 1][] 一、基本关系代数运算 1、并 R∪S=\{t|t∈R∨t

短命女/ 2022年08月08日 03:21/ 0 赞/ 210 阅读

相关线性代数（1）线性代数需要解决的问题

线性代数的中心问题是求解线性方程组。那什么是线性方程呢？所谓线性方程就是指未知量是一次幂的等式，它的一般形式是ax + by + ... + cz = 0。也就是说线性方程组是

港控/mmm°/ 2022年05月31日 11:26/ 0 赞/ 234 阅读

相关数据库关系代数总结

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ub

灰太狼/ 2022年03月15日 16:30/ 0 赞/ 181 阅读

相关子域，代数闭域，代数闭包

转载自： [https://baike.baidu.com/item/%E5%AD%90%E5%9F%9F/5873902?fr=aladdin][https_baike.b

以你之姓@/ 2022年02月21日 01:18/ 0 赞/ 703 阅读

相关线性代数-行列式

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4

短命女/ 2021年12月13日 04:35/ 0 赞/ 1687 阅读

相关线性代数：方程组

齐次方程组： ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubm

快来打我*/ 2021年11月23日 03:56/ 0 赞/ 391 阅读