搜索
数据库课程设计学生作业管理系统计算机科学与工程学院2012年6月数据库课程设计学生作业管理系统小组成员：徐垚、李栋孙扬、黄最圣指导教师：张伟杰专业：软件工程所在单位：计算机科学与工程学院数据库课程设计（报告）I摘要随着信息技术的迅速发展、电脑化教学与远程的网络化教学的普及，给传统的教学方式带来了重大的革命，也给教学改革的实施者们提出了很多新的课题。学校教育信息化普及相当迅速，许多课程都实现了多媒体教学，学生的作业相当大的一部分是数字作业。在实际的教学工作中，教师批改作业的方式大至有三种：一是当场批改，这种方式批改往往达不到一定深度；二是复制到磁盘后逐一批改，这种方式在公共机房频繁使用储存设备，既麻烦又不利于信息安全；三是发送到E-mail中，教师下载后批改，这种方式教师下载E-mail中的作业比较繁琐，而且工作量很大。网上作业在线管理系统是集数字作业的收交、批改和反馈于一体的管理系统，既省力、方便、高效又兼顾了信息安全。本文档主要介绍了一个特定的系统——学生作业在线管理系统。我们运用JSP技术构建一个网上作业提交和批改系统的过程。通过对其系统的可行性研究，需求分析，结构设计等多方面来介绍和设计。本系统采用的是Myeclipse6.0的开发环境和SQL2000的数据库等工具。本系统的主要目标是对于学生的作业进行计算机化的管理。该系统的主要功能包括：管理员用户的功能、教师用户的功能、学生用户的功能等。本文档还描述了B/S模式的概念及特点，JSP的优越性及对通用作业批改系统的分析，该系统主要完成了作业的上传，教师对作业的批改，系统得稳定性高，操作简单。关键词：学生作业在线管理系统；B/S模式；JSP；数据库课程设计（报告）IIABSTRACTWiththerapiddevelopmentofinformationtechnology,computerizedteachingandremotenetworkteaching,givethepopularityoftraditionalteachingmethodofbroughtgreatrevolution,alsogiveteachingreformtheimplementerraisedsomanynewtask.Schooleducationinformatizationpopularity,manycoursesarequitequicklyrealizedthemultimediateaching,Thestudents'workquitebigispartofthedigitalwork.Inactualteaching,theteacherrevisesassignmentstohavethreeways:Oneisthespot,thiswaycorrectscorrectsoftenhitcertaindepth;2itiscopiedtothediskone,andinthiswayaftercorrectingthefrequentuseinpublicgenerator-room,bothdifficultandstoragedeviceagainstinformationsecurity;ThreeissenttotheE-mail,theteacherrevisesafterdownloading.ThiswaytheteacherdownloadE-mailhomework,andworkingalotismoretedious.Onlineassignmentsonlinemanagementsystemissetfordigitalhomeworkcorrectsandfeedbackinto,integratedmanagementsystem,bothenergy,convenient,efficientandbalancedinformationsecurity.Thisdocumentmainlyintroducedaspecificsystem-studentassignmentsonlinemanagementsystem.Weuseasp.nettechnologybuildinganonlineassignmentsandcorrectingthesystemprocess.Throughitsfeasibilitystudy,needsanalysis,structuraldesign,etc.tointroduceanddesign.ThissystemUSESisMyeclipse6.0developmentenvironmentandSQL2000databaseetctools.Thesystem'smaingoalisforstudents'workcomputerizedmanagement.Themainfunctionofthesystemincludes:thefunction,administratorusersthefunction,studentteacherusersthefunctionetc.UserThedocumentalsodescribestheB/Smodel,theconceptandfeaturesofJSPsuperiorityandthegeneralhomeworksystemanalysis,thesystemmainlyfinishthehomeworkassignments,teacherstouploadthegrade,systemmusthighstability,simpleoperation.Keywords:studentassignmentsonlinemanagementsystem；B/Smodel；Jsp数据库课程设计（报告）III目录摘要.....................................................................................................................................................IABSTRACT.............................................................................................................................................II第1章概述.....................................................................................................................................-1-1.1选题的目的和意义.......................................................................................................................-1-1.2本文的工作内容...........................................................................................................................-1-1.3SERVERSQLMICROSOFT简介............................................................................................................-2-第2章需求分析.............................................................................................................................-3-2.1工作流程图...................................................................................................................................-3-2.2数据流图.......................................................................................................................................-3-2.3基本功能.......................................................................................................................................-5-2.4数据字典如下：...........................................................................................................................-5-2.5功能模块划分及设计...................................................................................................................-6-第3章概念结构设计.....................................................................................................................-8-3.1E-R图.............................................................................................................................................-8-3.2表信息.........................................................................................................................................-10-第4章逻辑结构设计...................................................................................................................-12-4.1关系模式....................................................................................................................................-12-4.2范式级别....................................................................................................................................-12-第5章数据库实现.......................