数据库SQL语句.pptVIP

An Introduction to Database System 专题 关系代数表达式书写 主讲人：刘永磊 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 一些例子 1.查询选修了2号课程的学生的学号。 πSno（σCno=‘2’（SC）） 2.查询至少选修了一门其直接先行课为5号课程的的学生姓名 πSname (πSno (σCpno=5 (Course) SC) πSno，Sname (Student)) ? 3.查询选修了全部课程的学生号码和姓名。 πSno，Cno（SC）÷πCno（Course） πSno，Sname（Student） Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 又有连接，又有除法，好复杂啊！晕！不会写 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 不识庐山真面目，只缘身在此山中。 自然语言 关系代数表达式 从系统外考虑 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 基于人眼目光移动的关系代数表达式书写 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 示例数据库 (a) Student 学生-课程数据库: 学生关系Student、课程关系Course和选修关系SC 学号 Sno 姓名 Sname 性别 Ssex 年龄 Sage 所在系 Sdept 200215121 李勇 男 20 CS 200215122 刘晨 女 19 IS 200215123 王敏 女 18 MA 200215125 张立 男 19 IS Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 课程号 Cno 课程名 Cname 先行课 Cpno 学分 Ccredit 1 数据库 5 4 2 数学 2 3 信息系统 1 4 4 操作系统 6 3 5 数据结构 7 4 6 数据处理 2 7 PASCAL语言 6 4 Course (b) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System ? (c) SC 学号 Sno 课程号 Cno 成绩 Grade 200215121 1 92 200215121 2 85 200215121 3 88 200215122 2 90 200215122 3 80 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. An Introduction to Database System 书写关系代数表达式的步骤 1.“