搜索
I北京理工大学珠海学院课程设计报告2011—2012学年第1学期题目:学生选课系统的数据库设计学院：商学院专业班级：09信管4班学号姓名：090802041005xx指导教师：xxx成绩：时间：2011年12月18日II北京理工大学珠海学院课程设计任务书2011～2012学年第1学期学生姓名：xxx专业班级：09信息管理与信息系统指导教师：xxx工作部门：商学院一、课程设计题目学生选课系统的数据库设计选课系统的设计1）统计出至少有三名学生选修的课程的平均分，统计项包含课程编号和平均分2）在选课数据库中，统计出选修课程超过或等于2门以上的学生信息3）统计出平均分在90分以上的学生的信息，并将结果按平均分降序排列为每个实体表和关系表创建合适的索引（聚簇索引、复合索引）、主码、外码；创建学院类别取值范围为商学院、外国语学院、计算机学院、信息科技学院，并与相应的列绑定；通过触发器定义选课的成绩不能从选课中修改，修改专业的同时修改班级人数，在学生表中删除学生的同时，删除选课表中的信息；创建视图studentview（学生信息表），sc_view（学生成绩表），cs_view（学生课程表）；存储过程execPro_基本信息功能的验证，存储过程execPro_班级信息的验证：（查询不同“班级编号”的所有学生信息）事务的创建（同时更新“姓名”和“所属班级”列信息，否则数据保持不变）III摘要随着社会的发展，学生的人数和课程的种类急速增加，传统的选课管理模式已经无法满足当前的实际需求，为此，我们开发了学生选课管理系统。本人结合学生选课管理的实际需要，完成了对学生选课管理系统的需求分析、功能模块划分、数据库模式分析等，并由此设计了后台数据库以及前台应用程序。文中首先对课题背景，数据库基础理论和SQL语言进行了简单的讨论；接着，学生选课管理系统进行了详细分析，划分了具体的功能模块；最后，给出了学生选课系统应用程序的设计过程，以及每个功能模块的核心代码。系统可以实现学生选课的一些重要功能，如：课程的添加、删除，信息查询、选课、生成课表，以及学生选课管理人员、用户个人信息的维护等。关键词管理系统；数据库；SQLServer2000IVAbstractWiththedevelopmentofsociety,thenumberofstudentsandthetypeofcourseincreasedsharply,thetraditionalcoursesmanagementmodecannotmeetcurrentdemand,therefore,wedevelopthestudents'coursesmanagementsystem.Iaccordingtostudentsofthepracticalneedofcoursesmanagement,completethecourseforstudentsofthemanagementsystemrequirementsanalysis,functionmodulepartition,databasemodelanalysis,etc,andhasdesignedthebackenddatabaseandforegroundapplication.Thispaperfirsttothisbackground,databasebasictheoryandSQLlanguagearediscusseddevelopmenttools,students'courseselectionmanagementsystemareanalyzedindetail,dividingaspecificfunctionmodule;Finally,wegivethestudents'electivecoursesystemapplicationdesignprocess,andthecoreofeachfunctionmodulecode.Thesystemcanrealizethecourseofsomeimportantfunctionstudents,suchas:courseadd,delete,informationquery,courses,andtheformationofschedule,andthestudents'coursesmanagementpersonnel,andthemaintenanceofcustomerinformation.Keywords：managementsystem;Database;SQLServer20005目录1．引言····························································································62.需求分析阶段···············································································62.1引言·····················································································62.2需求分析阶段的目标与任务·······················································92.2.1处理对象········································································92.2.2处理功能及要求·······························································92.2.3.安全性和完整性要求·······················································102.3需求分析阶段成果···························································102.3.1体会与收获··································································102.3.2学生选课管理系统业务流程图··········································112.3.3选课管理系统数据字典···················································112.3.5处理逻辑描述·······························································133概念设计阶段··············································································133.1引言···················································································133.2任务与目标··········································································143.3阶段结果·············································································144．逻辑设计阶段··············································································174.1逻辑设计的任务和目标····························································174.2数据组织·············································································174.2.1将E-R图转换为关系模型················································174.2.2模型优化······································································184.2.3数据库模式定义·····························································185．数据库实施阶段···········································································205.1建立数据库、数据表、视图、索引·············································205.1.1建立数据库··································································205.1.2建立数据表··································································205.1.3建立视图·····································································225.1.4建立索引···································································235.1.5建立触发器································································246．数据统计····················································································287．实习心得····················································································3061．引言本文以高校选课管理系统管理系统开发过程为背景，全文分为目录、需求分析、概要设计、逻辑设计、物理设计，以及系统的实现等全过程。在程序设计与调试上采用了自上而下，逐步细化，逐步完善的原则。采用结构化的功能模块设计系统功能，可读性好，易于扩充。基本功能全面，系统可读性好，易于维护、更新，安全性好。2.需求分析阶段2.1引言进行系统设计，首先要对系统的现状进行分析。根据系统的目标、需求和功能，制定和选择一个较好的系统方案，从而达到一个合理的优化系统。每个学校都有图书馆，最初由于图书数量和种类较少，人工手动管理比较方便和灵活。随着社会的发展，图书的数量和种类越来越多，人工手动管理会降低工作的效率，希望建立一个图书管理系统，是为了解决人工手动管理图书信息在实践的问题，从而达到系统化、规范化、标准化的水平。该系统的建立不但给管理者带来了方便，也节省了工作时间从而提高了工作效率。需求分析是在于要弄清用户对开发的数据库应用系统的确切要求。数据库设计的第一步是明确数据库的目的和如何使用，也就是说需要从数据库中得到哪些信息。明确目的之后，就可以确定您需要保存哪些主题的信息（表），以及每个主题需要保存哪些信息（表中字段）。在构造系统时，首先从需求出发构造数据库表，然后再由数据库表结合需求划分系统功能模块。学生选课排课系统用于根据教学计划、教师资源、教师资源等，制定每学期的课程表及相关信息，面对的