学生成绩管理数据库建立.docVIP

课程设计报告 课程名称：　 数据库系统原理 　　　 设计题目：　 学生成绩管理数据库的建立 指导教师：　　 　　　　　　 时 间：　2010 ～ 2011　 学年第 二 学期 南京人口学院信息科学系 课程设计课程设计要求SELECT S.NAME FROM S WHERE ((s.sex=男)); 查询结果： 2）SQL语句：SELECT S.* FROM S WHERE (((S.CLASSNO) Not Like 2031)); 查询结果： 3）SQL语句：SELECT C.CNAME, C.XF, C.TNO FROM C WHERE (((C.TNO) Like 1)); 查询结果： 4）SQL语句：SELECT S.* FROM S INNER JOIN G ON S.SNO=G.SNO WHERE G.CNO Like c11 And EXISTS(SELECT * FROM G AS G2 WHERE G.SNO=G2.SNO AND G2.CNO Like c23 ); 查询结果： 5）SQL语句：SELECT S.NAME, S.SNO FROM (S INNER JOIN G ON S.SNO = G.SNO) INNER JOIN C ON G.CNO = C.CNO WHERE (((G.CNO)=c11 Or (G.CNO)=c12 Or (G.CNO)=c21)) GROUP BY S.NAME, S.SNO; 查询结果： 6）SQL语句：SELECT S.NAME, S.SNO FROM S INNER JOIN G ON S.SNO = G.SNO WHERE (((G.CNO)=c13)); 查询结果： 7）SQL语句： SELECT S.SNO, G.CNO, C.CNAME FROM (S INNER JOIN G ON S.SNO=G.SNO) INNER JOIN C ON G.CNO=C.CNO WHERE (((S.SNO) Like s101) AND ((Exists (SELECT * FROM G AS G2 WHERE G.CNO=G2.CNO AND G2.SNO LIKE s102))False)); 查询结果： 8）SQL语句：SELECT C.* FROM C WHERE (((C.CNO) Not In (SELECT G.CNO FROM G))); 查询结果： 9）SQL语句： SELECT S.SNO, Avg(G.GRADE) AS GREAT之平均值, Sum(G.GRADE) AS GREAT之总计 FROM S INNER JOIN G ON S.SNO=G.SNO GROUP BY S.SNO; 查询结果： 10）SQL语句：SELECT S.NAME, S.SNO, Count(G.GRADE) AS GRADE之计数 FROM S INNER JOIN G ON S.SNO=G.SNO WHERE (((G.GRADE)90)) GROUP BY S.NAME, S.SNO HAVING (((Count(G.GRADE))2)); 查询结果： 11）SQL语句： SELECT S.SNO, S.NAME, Sum(G.GRADE) AS GREAT之总计 FROM S INNER JOIN G ON S.SNO=G.SNO GROUP BY S.SNO, S.NAME HAVING Sum(G.GRADE)200; 查询结果： 12）SQL语句： SELECT C.CNAME, C.CNO, Count(G.GRADE) AS GRADE之计数 FROM (S INNER JOIN G ON S.SNO = G.SNO) INNER JOIN C ON G.CNO = C.CNO GROUP BY C.CNAME, C.CNO HAVING (((Count(G.GRADE))10)); 查询结果： 13）SQL语句：SELECT S.NAME, Count(G.GRADE) AS GRADE之计数 FROM S INNER JOIN G ON S.SNO=G.SNO WHERE (((G.GRADE)60)) GROUP BY S.NAME HAVING (((Count(G.GRADE))=4)); 查询结果： 14）SQL语句：SELECT C.TNO, T.NAME, Sum(C.XF) AS XF之总计 FROM C INNER JOIN T ON C.TNO=T.TNO GROUP BY C.TNO, T