搜索
（毕业设计）题目：学生成绩查询系统的设计与实现系院：xxxx学生姓名：xxx学号：xxx专业：xxx年级：xxx完成日期：xxx指导教师：xxx1摘要学生成绩查询系统成为教育单位不可缺少的部分,它的内容对于学校的决策者和管理者来说都至关重要,以其便捷性被越来越多的老师、学生所接受，所以学生成绩查询系统应该能够为用户提供充足的信息和快捷的查询手段｡可以说它完全是为学生朋友服务的系统,并且适用于各所高校｡对于本系统,我们需要实现以下一些以下主要功能:1.学生查询功能:为了方便学生查找成绩等信息,将所有信息按照需要进行分类｡这样学生就能很方便的找到自己需要的信息｡2.添加功能:管理员可以通过填写表格的形式输入学生成绩等相关信息｡系统可以自动避免重复信息｡3.修改功能:管理员可以对数据库中的信息进行修改｡系统能够通过管理员给出的条件查找出所要修改的信息,对修改后的信息进行保存,并自动查找是否是重复信息｡4.删除功能:管理员可以对数据进行删除操作｡系统能够通过管理员给出的条件查找出要删除的信息,并提示是否确定删除,如果确定删除,则把相关信息从数据库中删除掉｡5.管理员查询功能:管理员可以通过条件选择查询所有信息,并进行排序｡6.根据设计的数据库管理成绩数据，其中包括数据流程图的绘制，分析数据字典和设计数据库结构。关键词:成绩；查询；在线；数据字典2ABSTRACTStudentachievementasaneducationunitInquirySystemindispensablepartofthecontentofitspolicy-makersandmanagersofschoolsarecrucialtoitsconveniencehasbeenagrowingnumberofteachersandstudentstoaccept,sostudentperformanceinquiriessystemshouldbeabletoprovideuserswithsufficientinformationandefficientquerycan｡meansthatitisafriendserviceforstudentsofthesystem,andappliestoallcollegesanduniversities.Forthissystem,weneedtoachievethefollowingmainfunctionsofthefollowing:1.Theinquiryofstudents:Inordertofacilitatestudentstofindsuccess,andotherinformation,allinformationrequiredinaccordancewiththeclassification.Sostudentscaneasilyfindtheinformationtheyneed.2.Addfunction:administratorscanfilloutaformthroughtheformofinputinformationsuchasstudentachievement.systemtoavoidduplicationofinformationcanbeautomatically.3.Revision:thedatabaseadministratorcanmodifytheinformation.Systemadministratorscanfindouttheconditionsaregiventomodifytheinformationontherevisedinformationtopreserveandautomaticallylookforiswhetherornottorepeatinformation.4.Deletefunction:Anadministratorcandeletethedata.Systemadministratorscanfindouttheconditionsgiventothedeletionofinformationandtipstodeterminewhetherornottodelete,deleteifitisdeterminedthat,whileinformationremovedfromthedatabase.5.Queryadministrator:Theadministratorcanchoosetoqueryalltheconditionsfortheadoptionofinformationandsort.6.Accordingtothedesignofdatabasemanagementperformancedata,includingdataflowdiagramdrawing,datadictionaryanddatabasestructuredesign.Keywords:Performance；Query；On-line；DataDictionary目录1绪论...............................................................................................................................................................31.1成绩查询系统发展及现状............................................................................................................31.2成绩查询系统的发展目标............................................................................................................31.3成绩查询系统的服务整合............................................................................................................42系统需求分析............................................................................................................................................52.1开发背景.............................................................................................................................................52.2需求分析.............................................................................................................................................52.2.1需求信息的收集.......................................................................................................................62.2.2需求信息的整理......................................................................................................................72.3系统功能架构....................................................................................................................................82.4系统功能模块....................................................................................................................................83系统设计....................................................................................................................................................103.1软硬件配置.......................................................................................................................................103.1.1硬件配置..................................................................................................................................103.1.2软件配置..................................................................................................................................103.2系统功能设计..................................................................................................................................103.3业务流程图........................................................................................................................................113.4数据流程图........................................................................................................................................113.5数据字典...........................................................................................................................................134数据库设计...............................................................................................................................................154.1对数据库软件SQLSERVER的相关说明.................