完成课程表

⑴ SQL语句的一道题 三个基本表：学生表(Student)、课程表（Course）、学生选课表（SC）

1. select * from SC
2. select Sname，Sage from Student where Sdept = '计算机'
3. select Sno,Cno,Grade from SC where Grade >= 70 and Grade <= 80
4. select Sname,Sage from Student where Sage between 18 and 20 and Ssex = '男'
5. select top 1 Grade from SC where Cno = 'C01'
6. select max(Sage),min(Sage) from Student
7. select Sdept,sum(Sno) from Student group by Sdept
8. select course.Cname,sum(sc.Sno),max(Grade) from SC
join studet on Student.Sno = SC.Sno
join Course on Course.Cno = SC.Cno
group by course.cname,max(grade)

9. select sum(Cno),avg(Grade) from SC
join Course on Course.Cno = SC.Cno
join Student on Student.Sno= SC.Sno
order by SC.Sno

10. select Stuent.Sno，Stuent.Sname，sum(Grade) A from SC
join Student on Student.Sno = SC.Sno
group by sc.Sno,student.Sname
having A > 200

11. select Student.Sname,Student.Sdept from Student
join Course on Course.Cno = SC.Cno
join SC on SC.Sno = Student.Sno
where SC.Cno = 'C02'

12. select Student.sname,course.cno,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno
where sc.grade >= 80
order by sc.grade desc

13. select cno,cname from
(
select course.cno,course.cname,sun(sno) from student
join course on course.cno = sc.cno
join sc on sc.sno = student.sno
group by cno,cname
having sun(sno) > 0
)

14. ① select student.sname,student.sdept from
(
select student.sname,student.sdept,course.cname from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where course.cname = 'C01'
)

② select student.sno,student.sname from
(
select student.sno,student.sname,student.sdept,sc.grade from sc
join student on student.sno = sc,sno
where student.sdept = '信息' and sc.grade >= 80
)

③ select top 1 student.sname from
(
select student.sname,student.sdept,sum(sc.grade) from sc
join student on student.sno = sc.sno
where student.sdept = '计算机'
group by student.sname,student.sdept
order by
)

15. delete from sc where grade < 50
16. update sc set grade += 5 from sc
join course on course.cno = sc.cn
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from sc
join course on course.cno = sc.cno
where course.cname = 'c01'
)

17. update sc set grade += 10 from sc
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where student.sdept = '计算机' and course.cname = '计算机文化基础'
)

18. create view [A] as
select student.sno,student.sname,student.sdept,course.cno,course.cname,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno

19. create view [A] as
select student.sno,avg(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

20. create view [A] as
select student.sno,sum(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

21. create index A on student(sname)
22. 不会

⑵ 用T-SQL语句完成下列题目。在名称为“教学库”的数据库中有三个表学生表，课程表和成绩表它们的定义如下

1
select b.课程名,isnull(count(*),0)
from 课程表 a,成绩表 b on a.课程号回=b.课程号
group by b.课程名答
2
select a.姓名,b.课程名,c.成绩 from 学生表 a,课程表 b,成绩表 c
where a.学号=c.学号 and b.课程号=c.课程号
and a.性别='女' and b.课程名='计算机基础'
3
这个，你自己添加数据就好啦
4
update 课程表 set 学分=学分+1 where 课程号='001'

5
select * from 课程表 where 课程名 like '计算机%'

⑶ 有一门课在课表里面有,但是在我的计划完成情况里没有是怎么回事

用品德书上的语言来说就是么有毅力，要有毅力懂么？？？你可能满腔热血的说，我回要完成什答么什么，但是呢，当到了那个关头，你又不能做下去了。那说明自制力不够好，还有就是浮躁。那天有人说，现在的年轻人都很浮躁，不能静下心来做一些事。我也觉得是这样，因为我本身就是一个静不下心来做事的人，而且，给自己定了计划，也很多完不成。要是，把每次的侥幸心理都否决掉，让心静一点，多一些执着，那么那些计划我想也是会完成的吧。

⑷ 课程表和消课时管理的软件有吗

这个就是学员课耗和课程表管理的软件，艺训通可以统计学员卡课时情况并且学员自己也可以随时查看到自己的课耗，操作也很简单，你可以自己网络一下！

⑸ 自定义一个触发器，完成课程表course的完整性约束。具体要求为

ALTER trigger Checktextbox
on Course
For insert
AS
BEGIN

IF EXISTS(SELECT * FROM INSERTED WHERE textbox NOT LIKE '%高等教育出版社'
AND textbox NOT LIKE '%清华大学出版社' AND textbox NOT LIKE '%复旦大学出版社'
AND textbox NOT LIKE '%同济大学出版社')
BEGIN
PRINT '不是指定出版社,不能订购!'
ROLLBACK
END
ELSE
PRINT '订购成功'

END

⑹ 怎么完成QQ群里老师助手的课程表

一般来说打开QQ群里面选择相关的选项就可以了，你看一下。

⑺ 各位，k1两周减脂课程表完成了，可以做k2吗

你有能力完成的，可以做

⑻ 数据库实验实验没完成,想把学生课程表数据库带回去到自己计算机上继续做，应该如何处理

整个库的话就用数据库的备份功能，然后在本机恢复就行。单个数据表可以直接导出数据成text文本

⑼ 南京师范大学 动画专业 大学本科四年课程表或者详细的专业课程.求好心人告诉 需要完成调查报告

素描 色彩 编导 分镜 人设 PS 场景 运动规律 平面设计 影视 后期制作 三维 flash 音频制作 表演 造型 毕业创作

⑽ 根据学生表和课程表与成绩登记表的关系来做一个成绩登记表用SQL环境下完成。

--1.
createtablescs
(snointnotnull,
cnointnotnull,
scoreint)
--2.
altertablescsadddtdatetime;
--3
altertablescsaddconstraintpk-scprimarykey(sno,cno);