同济大学数据库原理与设计习题课.pptVIP

CREATE TRIGGER instead_of_insert ON course_view INSTEAD OF INSERT AS DECLARE @_cnum CHAR(4), @_cname CHAR(20), @_credits SMALLINT SET @_cnum=(SELECT cnum FROM inserted) SET @_cname=(SELECT cname FROM inserted) SET @_credits=(SELECT credits FROM inserted) INSERT into course VALUES(@_cnum,@_cname,@_credits,NULL,NULL,NULL) 测试触发器： INSERT INTO course_view VALUES(C139,软件开发技术基础,3) (1 行受影响) (1 行受影响) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. course表 视图course_view 测试触发器： INSERT INTO course_view VALUES(C139,软件开发技术基础,3) (1 行受影响) (1 行受影响) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. * * * * * * * * * * * * * * * * * * * * * * * * * * * * 象集（Image Set） 关系R(X , Z), X、Z是属性组，x是X上的取值，定义x在R中的象集为 Zx = { t[Z] | t?R ? t[X]= x } 从R中选出在X上取值为x的元组，去掉X上的分量，只留Z上的分量 * X Z 张军同学所选修的全部课程 x=张军 Zx 姓名 张军 王红 张军 课程 物理 数学 数学 课程 数学 物理 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 除定义 R(X , Y) ? S(Y) = { x | x=r[X] ? r?R ? Yx? y(S)} R(X , Y) ? S(Y) = {tr[X]| tr?R ? Yx? y(S)} R ?S是R中满足下列条件的元组在X属性列上的投影:元组在X上的分量值x的象集Yx包含S在Y上投影的集合中。 * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 设有关系模式： S(snum,sname,age,sex) SC(snum,cnum,grade) C(cnum,cname,teacher) 试用关系代数表达式表达每个查询语句。 检索学习课程号为C2的学生学号与成绩。 * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 检索学习课程为C2的学生学号与姓名。 检索选修课程名为Maths的学生学号与姓名。 检索选修课程号为C2或C4的学生学号。 * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 检索至少选修课程号为C2和C4的学生学号。 检索不学课程号为C2的学生姓名与年龄。 * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 检索学习全部课程的学生姓名。