有如下学生数据库:学生关系S,课程关系C,学生选课关系SC和教师关系T,分别如下:

2025-06-26 17:49:54
推荐回答(3个)
回答1:

1.
select Sname,Sdept from S where Ssex='男' and Sage >= 20

2.
select S.Sname,C.Cpno,T.Tname,SC.Grade from S,C,SC,T
where S.Sno=SC.Sno and SC.Cno=C.Cno and C.Tno=T.Tno
and SC.Grade<60

3.
select S.Sno,S.Sname,C.Cpno,SC.Cno,SC.Grade from S,C,SC,T
where S.Sno=SC.Sno and SC.Cno=C.Cno and C.Tno=T.Tno
and S.Sclass=‘22001’

回答2:

1) select sname,sdept from S where Ssex='男' and Sage>=20
2) select sname,Cname,Tname,Grade from s inner join sc on s.Sno=sc.sno inner join c on c.cno=sc.cno inner join T on T.Tno=c.Tno
3) select sno,sname,cno,Grade from s inner join sc on s.sno=sc.sno inner join c on c.cno=sc.cno where
sclass='22001'

回答3:

半路出家,让我直接写sql语句我会,关系代数不懂是什么,我也关注求教学习下。
前面回答的不是sql语句?关系代数是这个?