建立选修课程号为c2课程的学生信息的视图，视图包含...

选项

A. CREATE VIEW v1 SELECT s#,sname,sex,cname,teacher,grade FROM S,SC,C WHERE S.s#=SC.s# AND SC.c#=C.c# AND c#='c2'

B. CREATE VIEW v1 AS SELECT s#,sname,sex,cname,teacher,grade FROM S,SC,C WHERE c#='c2'

C. CREATE VIEW v1 AS SELECT s#,sname,sex,cname,teacher,grade FROM S,SC,C WHERE S.s#=SC.s# AND SC.c#=C.c# AND c#='c2'

D. CREATE VIEW v1 AS SELECT s#,sname,sex,cname,teacher,grade FROM S,SC,C WHERE S.s#=SC.s# AND c#='c2'

正确答案：

名词解析

CREATE VIEW v1 AS SELECT s#,sname,sex,cname,teacher,grade FROM S,SC,C WHERE S.s#=SC.s# AND SC.c#=C.c# AND c#='c2'

建立选修课程号为c2课程的学生信息的视图，视图包含学号、姓名、性别和选修的课程名、教师名和该课程成绩。