网上评教系统设计与实现-毕业论文.docVIP

网上评教系统的设计与实现 摘 要 传统的学生评教过程采用由学生填表，手工汇总统计的办法，这样造成工作量大、损耗多、时效性差的弊端。针对如何利用Web技术来解决高校评教中遇到的实际问题，本人设计并实现了基于PHP，SQL Server技术的网上评教系统，以提高评教过程的效率。本文从需求分析开始，在此基础上重点探讨了系统数据分析过程以及数据库设计过程，并就系统各项功能进行了介绍以及说明了其关键的实现方法。 关键词：评教系统；PHP；SQL Server；数据库设计 The Design Implementation of Teaching Assess System on Website ABSTRACT Owing to the traditional assessing manner for teaching process, that is students fill in some forms in which the data then is collected for summary and statistic, there are many disadvantages of massive workloads, a great deal of wastages and low efficiency. To be directed against these problems in the assessing process using the web technology, an Teaching Assess System on website based on the PHP and SQL Server is designed and implemented, for improving the efficiency. This paper emphasizes on discussing the process of data analysis and database design, taking the background of requirement analysis, and elaborates the contents and implementation of every function points. Key Words: Teaching Assess System; PHP; SQL Server; Database Design 目 录 TOC \o 1 引言 PAGEREF _Toc138863606 \h 1 2 需求分析 PAGEREF _Toc138863607 \h 2 2.1 现行数据分析 PAGEREF _Toc138863608 \h 2 2.2 输入数据分析 PAGEREF _Toc138863609 \h 2 2.3 输出数据分析 PAGEREF _Toc138863610 \h 3 2.4 数据流分析 PAGEREF _Toc138863611 \h 5 2.5 数据模型分析 PAGEREF _Toc138863612 \h 5 3 系统实现 PAGEREF _Toc138863613 \h 8 3.1 功能模块设计 PAGEREF _Toc138863614 \h 8 3.2 数据库设计 PAGEREF _Toc138863615 \h 8 3.2.1 关系模式 PAGEREF _Toc138863616 \h 8 3.2.2 物理数据库表 PAGEREF _Toc138863617 \h 9 3.2.3 视图 PAGEREF _Toc138863618 \h 11 4 系统实现 PAGEREF _Toc138863619 \h 13 4.1 初始化评分数据 PAGEREF _Toc138863620 \h 13 4.1.1 生成评教对象表 PAGEREF _Toc138863621 \h 13 4.1.2 生成静态联结表 PAGEREF _Toc138863622 \h 14 4.2 系统首页设计 PAGEREF _Toc138863623 \h 14 4.3 学生评分 PAGEREF _Toc138863624 \h 15 4.3.1 评分权限验证 PAGEREF _Toc138863625 \h 15 4.3.2 获取评分课程 PAGEREF _Toc138863626 \h 15 4.3.3 学生评分 PAGEREF _Toc138863627 \h 15 4.3.4 评分数据的存储 PAGEREF _Toc138863628 \h 16 4.4 指标体系 PAGEREF _Toc13886