ached)andon-timecontrolproblems;severitygreaterrisk,accordingtotherequiredtroubleshooting,registrationform,andsignedbythoseresponsibleforthesecurityoftheunitforthefirstafterescalation.Thirdarticleopenminemanageroncoalmineproductionjobdistrictwithinofsecurityhiddentroubleshooting,andgovernanceandreportfullisresponsiblefor;securityDeputyManagertieManagerwork,theparagraphconstructionteamheadandthebusinessdepartmentheadMember,andrunmaintenancepersonnel,areshouldaccordingtotheirofdutiesrange,onproductionequipment,andfacilities,andsiteenvironment,aspectsofsecurityhiddenforcheckandreport,andbyhiddenrectificationprogrammeforhiddengovernance.Fourthopen-pitminesafetysectionisresponsibleforthesupervisionandinspectionintheproductionareatroubleshooting,managementandreportingofcomprehensivework.Articlescopeandfocusoftheinspectionpersonnelatvariouslevels:1,operatingpersonnelbeforetakingoverandshiftbeforethejurisdictionareatoconductacomprehensiveinspectionofequipment,runningthesquadlea学生信息管理系统数据库实训报告
erondutyduringmajorequipmentoverhaul,beforeandaftertheshifttodesignatedstafftounderstandtheoperationofequipmentintheequipmentandcheckonfocus.2,equipmentrepairequipmenttoselectmaintenancecheckatleasttwiceaweektokeyequipmentanddefectivedevicestoincreasethefrequencyofinspection.Teamleaderdedicatedtothedeviceeverydayoperationofalldeviceswithinthescopeofmaintenancepersonnelunderstandthemaintenanceandinspectionofkeyequipment.Paragraph3,theownerandprofessionalandtechnicalpersonnelshouldbecarriedoutdailyafterworksitevisitinspection...Evening.Controlroom:focusedoncoalseamspontaneouscombustionundertroubleshooting,help,landslide,coalfire,earth-moving,roadcarwallsitesafetysupervision,andconscientiouslyimplementtheminerectificationmeasures.Productiontechnologysection:isresponsiblefortroubleshootingwhetherexistsSupercapacity,andSuperached)andon-timecontrolproblems;severitygreaterrisk,accordingtotherequiredtroubleshooting,registrationform,andsignedbythoseresponsibleforthesecurityoftheunitforthefirstafterescalation.Thirdarticleopenminemanageroncoalmineproductionjobdistrictwithinofsecurityhiddentroubleshooting,andgovernanceandreportfullisresponsiblefor;securityDeputyManagertieManagerwork,theparagraphconstructionteamheadandthebusinessdepartmentheadMember,andrunmaintenancepersonnel,areshouldaccordingtotheirofdutiesrange,onproductionequipment,andfacilities,andsiteenvironment,aspectsofsecurityhiddenforcheckandreport,andbyhiddenrectificationprogrammeforhiddengovernance.Fourthopen-pitminesafetysectionisresponsibleforthesupervisionandinspectionintheproductionareatroubleshooting,managementandreportingofcomprehensivework.Articlescopeandfocusoftheinspectionpersonnelatvariouslevels:1,operatingpersonnelbeforetakingoverandshiftbeforethejurisdictionareatoconductacomprehensiveinspectionofequipment,runningthesquadlea学校：武汉电力职业技术学院 系部：计算机网络技术 班级：11521 实训老师：胡伟
成员：叶燎 李玉鹏 张梅 张洁
一. 课程设计的目的
学生信息管理系统以计算机为工具，通过对教务管理所需的信息管理，把管理人员从繁琐的数据计算处理中解脱出来，使其有更多的精力从事教务管理政策的研究实施，教学计划的制定执行和教学质量的监督检查，从而全面提高教学质量。
（1）本系统是运行在windowsXP操作系统环境下的多台计算机构成
的局域网，主要业务流程如下：
·按某学生某学期，学年考试及补考成绩。
·按每学期各年级班学生考试成绩自动生成补考名单，科目。 ·按每学期各年级学生考试成绩自动生成某课程统计分析表。 ·按同一年级学习成绩进行同一课程不同班级间成绩比较。
（2）功能要求
·学生档案管理： 学生的基本信息
·学生成绩管理： 学习成绩，补考成绩； ·毕业生学籍处理：毕业处理
（3）功能概述
（3.1）学生信息的管理:
即录入、修改、查询、输出学生档案信息，这些信息包括学生家庭住址、联系电话、出生年月等信息。
（3.2）学生成绩管理:
即录入修改、查询、输出学生各门课程的成绩信息，并支持按年级、班级等条件的统计、查询、报表输出。
二、. 设计方案论证
2.1设计思路
（1）提出的问题
erondutyduringmajorequipmentoverhaul,beforeandaftertheshifttodesignatedstafftounderstandtheoperationofequipmentintheequipmentandcheckonfocus.2,equipmentrepairequipmenttoselectmaintenancecheckatleasttwiceaweektokeyequipmentanddefectivedevicestoincreasethefrequencyofinspection.Teamleaderdedicatedtothedeviceeverydayoperationofalldeviceswithinthescopeofmaintenancepersonnelunderstandthemaintenanceandinspectionofkeyequipment.Paragraph3,theownerandprofessionalandtechnicalpersonnelshouldbecarriedoutdailyafterworksitevisitinspection...Evening.Controlroom:focusedoncoalseamspontaneouscombustionundertroubleshooting,help,landslide,coalfire,earth-moving,roadcarwallsitesafetysupervision,andconscientiouslyimplementtheminerectificationmeasures.Productiontechnologysection:isresponsiblefortroubleshootingwhetherexistsSupercapacity,andSuperached)andon-timecontrolproblems;severitygreaterrisk,accordingtotherequiredtroubleshooting,registrationform,andsignedbythoseresponsibleforthesecurityoftheunitforthefirstafterescalation.Thirdarticleopenminemanageroncoalmineproductionjobdistrictwithinofsecurityhiddentroubleshooting,andgovernanceandreportfullisresponsiblefor;securityDeputyManagertieManagerwork,theparagraphconstructionteamheadandthebusinessdepartmentheadMember,andrunmaintenancepersonnel,areshouldaccordingtotheirofdutiesrange,onproductionequipment,andfacilities,andsiteenvironment,aspectsofsecurityhiddenforcheckandreport,andbyhiddenrectificationprogrammeforhiddengovernance.Fourthopen-pitminesafetysectionisresponsibleforthesupervisionandinspectionintheproductionareatroubleshooting,managementandreportingofcomprehensivework.Articlescopeandfocusoftheinspectionpersonnelatvariouslevels:1,operatingpersonnelbeforetakingoverandshiftbeforethejurisdictionareatoconductacomprehensiveinspectionofequipment,runningthesquadlea如何建立学生信息管理系统，采用计算机对学生信息进行管理，进一步提高办学效益和现代化水平。帮助广大教师提高工作效率，实现学生信息信息管理工作流程的系统化、规范化和自动化
（2）可行性分析
管理信息系统的任务事：在充分认识原信息的基础上，通过问题的识别，可行性分析，详细调查，系统化分析，最后完成新系统的逻辑方案设计，或者称逻辑模型设计，逻辑方案事系统分析的任务，解决“做什么”的问题，物理方案事系统设计的任务，解决“怎么做”的问题。开发新系统的要求往往来自于对原有系统的不满，原系统可能事手工系统或者事正在运行的信息系统。由于纯在的问题可能含糊不清，这就要求系统分析员针对各种存在的问题出示要求作出识别，进行问题定义通过可行性分析确定开发系统的必要性。
（3）需求分析
建立学生信息管理系统，帮助广大教师提高工作效率。通过本系统软件，能帮助工作人员利用计算机，快速方便的对学生信息进行管理、输入、输出、查找等操作，使散乱的档案能够具体化、直观化、合理化。 2.2概念结构设计 E-R：（1）毕业生学籍管理（2）学生-选择-课程 2.3逻辑结构设计
学生档案表（学号，姓名，性别，出生年月，家庭住址，联系电话，邮编，密码，民族，籍贯，政治面貌，角色，）主键为学号
课程表（课程代号，选课名称，学分，考核方式，任课老师，课程介绍）主键为课程号 成绩表（学号，课程代号，学分,分数，是否确认，标识）主键为学号和课程名称 成绩单（学号，姓名，语文，英文，数学）主键为学号 教师表（编号，教师序号，教师名称，教师职称）自动编号 Cjb（编号，学号，科目代号，科目1,2,3,4,5,6）自动编号
erondutyduringmajorequipmentoverhaul,beforeandaftertheshifttodesignatedstafftounderstandtheoperationofequipmentintheequipmentandcheckonfocus.2,equipmentrepairequipmenttoselectmaintenancecheckatleasttwiceaweektokeyequipmentanddefectivedevicestoincreasethefrequencyofinspection.Teamleaderdedicatedtothedeviceeverydayoperationofalldeviceswithinthescopeofmaintenancepersonnelunderstandthemaintenanceandinspectionofkeyequipment.Paragraph3,theownerandprofessionalandtechnicalpersonnelshouldbecarriedoutdailyafterworksitevisitinspection...Evening.Controlroom:focusedoncoalseamspontaneouscombustionundertroubleshooting,help,landslide,coalfire,earth-moving,roadcarwallsitesafetysupervision,andconscientiouslyimplementtheminerectificationmeasures.Productiontechnologysection:isresponsiblefortroubleshootingwhetherexistsSupercapacity,andSuperached)andon-timecontrolproblems;severitygreaterrisk,accordingtotherequiredtroubleshooting,registrationform,andsignedbythoseresponsibleforthesecurityoftheunitforthefirstafterescalation.Thirdarticleopenminemanageroncoalmineproductionjobdistrictwithinofsecurityhiddentroubleshooting,andgovernanceandreportfullisresponsiblefor;securityDeputyManagertieManagerwork,theparagraphconstructionteamheadandthebusinessdepartmentheadMember,andrunmaintenancepersonnel,areshouldaccordingtotheirofdutiesrange,onproductionequipment,andfacilities,andsiteenvironment,aspectsofsecurityhiddenforcheckandreport,andbyhiddenrectificationprogrammeforhiddengovernance.Fourthopen-pitminesafetysectionisresponsibleforthesupervisionandinspectionintheproductionareatroubleshooting,managementandreportingofcomprehensivework.Articlescopeandfocusoftheinspectionpersonnelatvariouslevels:1,operatingpersonnelbeforetakingoverandshiftbeforethejurisdictionareatoconductacomprehensiveinspectionofequipment,runningthesquadlea三、实训过程
登录界面设计 表格创建 字段设置 表格数据录入 代码设计编写
系统形成exe文件 及其数据维护 （一）、登录界面设计：
erondutyduringmajorequipmentoverhaul,beforeandaftertheshifttodesignatedstafftounderstandtheoperationofequipmentintheequipmentandcheckonfocus.2,equipmentrepairequipmenttoselectmaintenancecheckatleasttwiceaweektokeyequipmentanddefectivedevicestoincreasethefrequencyofinspection.Teamleaderdedicatedtothedeviceeverydayoperationofalldeviceswithinthescopeofmaintenancepersonnelunderstandthemaintenanceandinspectionofkeyequipment.Paragraph3,theownerandprofessionalandtechnicalpersonnelshouldbecarriedoutdailyafterworksitevisitinspection...Evening.Controlroom:focusedoncoalseamspontaneouscombustionundertroubleshooting,help,landslide,coalfire,earth-moving,roadcarwallsitesafetysupervision,andconscientiouslyimplementtheminerectificationmeasures.Productiontechnologysection:isresponsiblefortroubleshootingwhetherexistsSupercapacity,andSuperached)andon-timecontrolproblems;severitygreaterrisk,accordingtotherequiredtroubleshooting,registrationform,andsignedbythoseresponsibleforthesecurityoftheunitforthefirstafterescalation.Thirdarticleopenminemanageroncoalmineproductionjobdistrictwithinofsecurityhiddentroubleshooting,andgovernanceandreportfullisresponsiblefor;securityDeputyManagertieManagerwork,theparagraphconstructionteamheadandthebusinessdepartmentheadMember,andrunmaintenancepersonnel,areshouldaccordingtotheirofdutiesrange,onproductionequipment,andfacilities,andsiteenvironment,aspectsofsecurityhiddenforcheckandreport,andbyhiddenrectificationprogrammeforhiddengovernance.Fourthopen-pitminesafetysectionisresponsibleforthesupervisionandinspectionintheproductionareatroubleshooting,managementandreportingofcomprehensivework.Articlescopeandfocusoftheinspectionpersonnelatvariouslevels:1,operatingpersonnelbeforetakingoverandshiftbeforethejurisdictionareatoconductacomprehensiveinspectionofequipment,runningthesquadlea
erondutyduringmajorequipmentoverhaul,beforeandaftertheshifttodesignatedstafftounderstandtheoperationofequipmentintheequipmentandcheckonfocus.2,equipmentrepairequipmenttoselectmaintenancecheckatleasttwiceaweektokeyequipmentanddefectivedevicestoincreasethefrequencyofinspection.Teamleaderdedicatedtothedeviceeverydayoperationofalldeviceswithinthescopeofmaintenancepersonnelunderstandthemaintenanceandinspectionofkeyequipment.Paragraph3,theownerandprofessionalandtechnicalpersonnelshouldbecarriedoutdailyafterworksitevisitinspection...Evening.Controlroom:focusedoncoalseamspontaneouscombustionundertroubleshooting,help,landslide,coalfire,earth-moving,roadcarwallsitesafetysupervision,andconscientiouslyimplementtheminerectificationmeasures.Productiontechnologysection:isresponsiblefortroubleshootingwhetherexistsSupercapacity,andSuper