(41)--公共基础计算机二级Office高级应用.pptVIP

4.4.2关系代数运算四、关系代数?关系代数的运算并、差、交、笛卡儿积投影、选择、连接、除4.4.2关系代数运算考试内容：由R和S得到T是什么运算ABCa1b1c1a1b2c2a2b2c1ABCa1b1c1a1b2c2a1b3c2a2b2c1ABCa1b2c2a1b3c2a2b2c1RST1、并（Union）ABCa1b1c1a1b2c2a2b2c1ABCa1b1c1a1b2c2a1b3c2a2b2c1ABCa1b2c2a1b3c2a2b2c1RSR∪S（1）两个关系列个数必须一致（2）并运算结果：列数不变；记录为两个表中的记录之和并去掉重复的2.差(续)ABCa1b1c1a1b2c2a2b2c1ABCa1b1c1ABCa1b2c2a1b3c2a2b2c1RSR-S（1）两个关系列数必须一致（2）差运算结果：列数不变；记录为属于关系R而不属于S的记录。3.交(续)ABCa1b1c1a1b2c2a2b2c1ABCa1b2c2a2b2c1ABCa1b2c2