急!请大侠们指点,一道数据库的题。写出关系代数表达式~~非常感谢!

急!请大侠们指点,一道数据库的题。写出关系代数表达式~~非常感谢!,第1张

1use database_name
select ssno,ccredit from course c join elective e
on ccon=econ join student s
on ssno=esno
where ccon='c06'
2use database_name
select ssname,csname from course c join elective e
on ccon=econ join student s
on ssno=esno
where ccon='c06'
3select ssname,csname from course c join elective e
on ccon=econ join student s
on ssno=esno
where ccname='ENGLISH'
4select ssno from course c join elective e
on ccon=econ join student s
on ssno=esno
where ccno in('c02','c06')
5select ssno from course c left join elective e
on ccon=econ join student s
on ssno=esno
where ccno in('c02','c06')
6select ssno from course c left join elective e
on ccon=econ join student s
on ssno=esno
where ccno not in('c02','c06')
7select sname from student
8select ssno from course c left join elective e
on ccon=econ join student s
on ssno=esno
where ssno like['s08'%]
呵呵,就这些了

以上就是关于急!请大侠们指点,一道数据库的题。写出关系代数表达式~~非常感谢!全部的内容,包括:急!请大侠们指点,一道数据库的题。写出关系代数表达式~~非常感谢!、、等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!

欢迎分享,转载请注明来源:内存溢出

原文地址:https://54852.com/sjk/9387167.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2023-04-27
下一篇2023-04-27

发表评论

登录后才能评论

评论列表(0条)

    保存