设有三个关系: S(S#,SNAME,AGE,SEX) SC(S#,C#,SCORE) C(C#,CNAME,TEACHER) 用关系代数表达式和SQL语句检索学号为S3学生所学课程的课程名与任课教师名。
A、πCNAME,TNAME(σS#='S3'(SC⋈C)) SELECT CNAME,TEACHER FROM SC WHERE SC.C#=C.C# AND S#=’S3’
B、πCNAME,TNAME(σS#='S3'(SC⋈C)) SELECT CNAME,TEACHER FROM SC, C WHERE S#=’S3’
C、πCNAME,TNAME(σS#='S3'(SC×C)) SELECT CNAME,TEACHER FROM SC, C WHERE SC.C#=C.C# AND S#=’S3’
D、πCNAME,TNAME(σS#='S3'(SC⋈C)) SELECT CNAME,TEACHER FROM SC, C WHERE SC.C#=C.C# AND S#=’S3’;