学生成绩管理系统(数据库课程设计)

上传者: saber_wtq | 上传时间: 2019-12-21 21:01:39 | 文件大小: 6.75MB | 文件类型: 7z
题目:成绩管理系统 按照目前湖工大的成绩管理情况,设计成绩管理系统后台数据库。要求系统可以存储学生基本信息,和课程基本信息,学生选课情况以及课程得分(考试后进行补录)。课程有必修,选修和公选不同类型。各学院学生只能选修该专业的选修课。公选课可以大范围选修。且补考,重新成绩要单独对待。可以根据学分统计发放学位信息。并提供学位信息查询(包括已经发放的学位证查询,以及没有发放的学位,要显示给该生还需多少学分,什么类型课程多少学分的提示。) 策略分析题目: 1按照学生学号,查询该生所有的课程选择及得分情况,并进行平均分,绩点计算。显示该生三类课程的门数和平均分。(必修,选修和任性课),其中任选课程若不及格不计入。 2按照课程号,查询该课程所有学生的得分情况,并进行平均分,方差等计算。按照成绩进行排序。 3根据班号,统计该班学生的不及格的全部信息。 资源包含: 14页详细的课程设计报告书、powerDesigner生成数据库的概念、物理、逻辑模型工程文件、C++——Qt编写的可视化数据库管理系统、 数据库工程文件(需要自己附加进Sql sever)、完成题目要求的数据库查询语句、Excel表格形式的数据库的数据

文件下载

资源详情

[{"title":"( 76 个子文件 6.75MB ) 学生成绩管理系统(数据库课程设计)","children":[{"title":"计算3班_王天奇 湖工大学生成绩管理系统","children":[{"title":"导入的excel数据","children":[{"title":"academy.xlsx <span style='color:#111;'> 8.28KB </span>","children":null,"spread":false},{"title":"course1.xlsx <span style='color:#111;'> 10.24KB </span>","children":null,"spread":false},{"title":"class.xlsx <span style='color:#111;'> 8.97KB </span>","children":null,"spread":false},{"title":"score1.xlsx <span style='color:#111;'> 12.73KB </span>","children":null,"spread":false},{"title":"说明.txt <span style='color:#111;'> 64B </span>","children":null,"spread":false},{"title":"student1.xlsx <span style='color:#111;'> 22.45KB </span>","children":null,"spread":false},{"title":"teacher.xlsx <span style='color:#111;'> 10.17KB </span>","children":null,"spread":false}],"spread":true},{"title":"数据库文件","children":[{"title":"stuManagement_log.ldf <span style='color:#111;'> 8.00MB </span>","children":null,"spread":false},{"title":"查询语句3.sql <span style='color:#111;'> 385B </span>","children":null,"spread":false},{"title":"查询语句2.sql <span style='color:#111;'> 676B </span>","children":null,"spread":false},{"title":"stuManagement.mdf <span style='color:#111;'> 8.00MB </span>","children":null,"spread":false},{"title":"查询语句1.sql <span style='color:#111;'> 315B </span>","children":null,"spread":false}],"spread":true},{"title":"应用系统编程","children":[{"title":"StudentManagement","children":[{"title":"StudentManagement.sln <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"StudentManagement","children":[{"title":"addstudlg.cpp <span style='color:#111;'> 822B </span>","children":null,"spread":false},{"title":"course_tab.ui <span style='color:#111;'> 3.59KB </span>","children":null,"spread":false},{"title":"addcoursedlg.h <span style='color:#111;'> 445B </span>","children":null,"spread":false},{"title":"addstudlg.h <span style='color:#111;'> 412B </span>","children":null,"spread":false},{"title":"mainwindow.ui <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"StudentManagement.vcxproj.user <span style='color:#111;'> 631B </span>","children":null,"spread":false},{"title":"add_scoredlg.h <span style='color:#111;'> 390B </span>","children":null,"spread":false},{"title":"class_tab.cpp <span style='color:#111;'> 3.51KB </span>","children":null,"spread":false},{"title":"Resources","children":null,"spread":false},{"title":"stu_tab.h <span style='color:#111;'> 988B </span>","children":null,"spread":false},{"title":"course_tab.cpp <span style='color:#111;'> 4.19KB </span>","children":null,"spread":false},{"title":"add_scoredlg.cpp <span style='color:#111;'> 665B </span>","children":null,"spread":false},{"title":"class_tab.ui <span style='color:#111;'> 3.02KB </span>","children":null,"spread":false},{"title":"teacher_tab.ui <span style='color:#111;'> 3.41KB </span>","children":null,"spread":false},{"title":"addcoursedlg.ui <span style='color:#111;'> 3.06KB </span>","children":null,"spread":false},{"title":"StudentManagement.vcxproj.filters <span style='color:#111;'> 9.27KB </span>","children":null,"spread":false},{"title":"course_tab.h <span style='color:#111;'> 926B </span>","children":null,"spread":false},{"title":"score_tab.ui <span style='color:#111;'> 3.29KB </span>","children":null,"spread":false},{"title":"mainwindow.cpp <span style='color:#111;'> 631B </span>","children":null,"spread":false},{"title":"add_classdlg.h <span style='color:#111;'> 378B </span>","children":null,"spread":false},{"title":"score_tab.cpp <span style='color:#111;'> 3.79KB </span>","children":null,"spread":false},{"title":"add_scoredlg.ui <span style='color:#111;'> 2.80KB </span>","children":null,"spread":false},{"title":"addstudlg.ui <span style='color:#111;'> 3.03KB </span>","children":null,"spread":false},{"title":"GeneratedFiles","children":[{"title":"Debug","children":null,"spread":false},{"title":"Release","children":null,"spread":false}],"spread":false},{"title":"x64","children":[{"title":"Release","children":[{"title":"StudentManagement.Build.CppClean.log <span style='color:#111;'> 4.93KB </span>","children":null,"spread":false},{"title":"StudentManagement.log <span style='color:#111;'> 3.42KB </span>","children":null,"spread":false},{"title":"StudentM.B12702AD.tlog","children":[{"title":"cl.command.1.tlog <span style='color:#111;'> 69.63KB </span>","children":null,"spread":false},{"title":"custombuild.read.1.tlog <span style='color:#111;'> 11.47KB </span>","children":null,"spread":false},{"title":"CL.read.1.tlog <span style='color:#111;'> 1.18MB </span>","children":null,"spread":false},{"title":"custombuild.command.1.tlog <span style='color:#111;'> 41.43KB </span>","children":null,"spread":false},{"title":"link.read.1.tlog <span style='color:#111;'> 24.07KB </span>","children":null,"spread":false},{"title":"link.write.1.tlog <span style='color:#111;'> 10.38KB </span>","children":null,"spread":false},{"title":"CL.write.1.tlog <span style='color:#111;'> 49.40KB </span>","children":null,"spread":false},{"title":"link.command.1.tlog <span style='color:#111;'> 14.67KB </span>","children":null,"spread":false},{"title":"StudentManagement.lastbuildstate <span style='color:#111;'> 248B </span>","children":null,"spread":false},{"title":"custombuild.write.1.tlog <span style='color:#111;'> 17.51KB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":false},{"title":"main.cpp <span style='color:#111;'> 790B </span>","children":null,"spread":false},{"title":"stu_tab.cpp <span style='color:#111;'> 3.74KB </span>","children":null,"spread":false},{"title":"mainwindow.qrc <span style='color:#111;'> 70B </span>","children":null,"spread":false},{"title":"add_teacherdlg.ui <span style='color:#111;'> 2.90KB </span>","children":null,"spread":false},{"title":"stu_tab.ui <span style='color:#111;'> 3.40KB </span>","children":null,"spread":false},{"title":"mainwindow.h <span style='color:#111;'> 570B </span>","children":null,"spread":false},{"title":"teacher_tab.cpp <span style='color:#111;'> 3.61KB </span>","children":null,"spread":false},{"title":"add_teacherdlg.cpp <span style='color:#111;'> 531B </span>","children":null,"spread":false},{"title":"teacher_tab.h <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"add_classdlg.cpp <span style='color:#111;'> 553B </span>","children":null,"spread":false},{"title":"addcoursedlg.cpp <span style='color:#111;'> 639B </span>","children":null,"spread":false},{"title":"add_teacherdlg.h <span style='color:#111;'> 414B </span>","children":null,"spread":false},{"title":"class_tab.h <span style='color:#111;'> 1010B </span>","children":null,"spread":false},{"title":"score_tab.h <span style='color:#111;'> 990B </span>","children":null,"spread":false},{"title":"add_classdlg.ui <span style='color:#111;'> 2.27KB </span>","children":null,"spread":false},{"title":"StudentManagement.vcxproj <span style='color:#111;'> 82.75KB </span>","children":null,"spread":false}],"spread":false},{"title":"StudentManagement.sdf <span style='color:#111;'> 22.31MB </span>","children":null,"spread":false},{"title":"x64","children":[{"title":"Release","children":null,"spread":false}],"spread":true},{"title":"StudentManagement.v12.suo <span style='color:#111;'> 56.50KB </span>","children":null,"spread":false}],"spread":true},{"title":"应用系统环境说明.txt <span style='color:#111;'> 91B </span>","children":null,"spread":false}],"spread":true},{"title":"湖工大学生管理系统Power Designer","children":[{"title":"湖工大学生成绩管理系统数据库生成sql语句-未修改.sql <span style='color:#111;'> 8.60KB </span>","children":null,"spread":false},{"title":"湖工大学生成绩管理系统逻辑结构模型.ldb <span style='color:#111;'> 63.47KB </span>","children":null,"spread":false},{"title":"湖工大学生成绩管理系统概念模型.cdm <span style='color:#111;'> 80.04KB </span>","children":null,"spread":false},{"title":"湖工大学生成绩管理系统概念模型.cdb <span style='color:#111;'> 78.80KB </span>","children":null,"spread":false},{"title":"湖工大学生成绩管理系统数据库生成sql语句-修改版.sql <span style='color:#111;'> 6.16KB </span>","children":null,"spread":false},{"title":"湖工大学生成绩管理系统逻辑结构模型.ldm <span style='color:#111;'> 79.12KB </span>","children":null,"spread":false},{"title":"湖工大学生管理系统物理结构模型.pdm <span style='color:#111;'> 167.46KB </span>","children":null,"spread":false},{"title":"湖工大学生管理系统物理结构模型.pdb <span style='color:#111;'> 103.56KB </span>","children":null,"spread":false}],"spread":true},{"title":"数据库课程设计报告.docx <span style='color:#111;'> 1.32MB </span>","children":null,"spread":false},{"title":"数据库课设图片.docx <span style='color:#111;'> 2.22MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • Rami2024 :
    非常具有参考价值
    2019-06-19
  • weixin_44331917 :
    还可以 需要这东西
    2019-06-05
  • hhxq001 :
    正需要这个,希望是功能完整的版本。
    2019-01-09

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明