摘 要
这篇论文主要研究了东北电力大学《 管理信息系统》精品课程网站的开发过程， 目标是向该大学所有学习管理信息系统相关课程的学生提供一个知识交流平台，并为该专业的任课教师建设一个教学资源管理信息系统。整个系统由B/S架构的学生信息服务子系统、数据管理子系统、资源管理子系统、课程信息管理子系统和C/S架构的试题管理子系统、电子习题册组成。
论文在系统的分析设计阶段采用了面向过程的结构化方法，在实施阶段主要使用了动态网页编程语言PHP和程序开发工具PowerBuilder。全文由六个章节：绪论、可行性分析、系统分析、系统设计、系统实施和结论，逐步介绍了精品课网站系统的开发过程。其中的重点的内容包括：选题背景与意义、对现行系统与用户需求的调查与分析、新系统数据流程分析、数据字典设计、系统总体结构设计、数据库设计、用户界面设计和程序设计。
关键词：管理信息系统，精品课网站，试题管理系统，电子习题册
I
ABSTRACT
This paper mainly discusses design and relization of an on-line study website,
whose primary targets are: 1) serving students majored in Management Information System as a communication platform and a resource center; 2) functioning as a resource management tool for professors who teach related courses. The whole system could be divided into two parts. One is a Browser/Server model information system consisting of student information service sub-system, data management sub-system and resource management subsystem.The other is a Client/Server system made up by problem management sub-system and electronic practice book.
In this study, the information system is designed with structured method which orients procedure(not object). After that, the web site is programmed with php language while other C/S sub-systems are realized in PowerBuilder Environment. The whole procedure, including system introduction, feasibility study, system analysis, system design and system programming, is described by this paper in sequenced 6 chapters. The core issues embraces data flow analysis, data dictionary design, system structure design, database design, user interface design and program design.
Key Words：management information system，on-line study website，problem management system, electronic practice book
II
目 录
摘 要 .................................................................................................................................... I ABSTRACT ............................................................................................................................. II 第1章 绪 论 ....................................................................................................................... 1
1.1 选题背景及意义 ......................................................................................................... 1 1.2 国内外发展状况 ......................................................................................................... 1 1.3 论文使用的研究方法与工具 ....................................................................................... 2 1.4 论文的基本思路与逻辑结构 ....................................................................................... 2 1.5 本人所做的工作 ......................................................................................................... 2 第2章 可行性研究.................................................................................................................. 3
2.1 概述 .......................................................................................................................... 3 2.2 现行系统的调查与分析 .............................................................................................. 3
2.2.1业务流程调查................................................................................................... 3 2.2.2信息流程分析................................................................................................... 4 2.2.3计算机应用情况调查 ........................................................................................ 4 2.2.4现行系统存在的主要问题和薄弱环节................................................................ 5 2.3需求调查和分析.......................................................................................................... 5 2.4新系统的方案介绍 ...................................................................................................... 6
2.4.1拟建系统的目标 ............................................................................................... 6 2.4.2系统规划及初步方案 ........................................................................................ 6 2.4.3系统的实施方案 ............................................................................................... 6 2.4.4其它可供选择的方案 ........................................................................................ 7 2.5 环境条件可行性 ......................................................................................................... 7
2.5.1系统外部环境................................................................................................... 7 2.5.2 系统的内部环境 .............................................................................................. 7 2.6 技术可行性 ................................................................................................................ 7 2.7 经济可行性 ................................................................................................................ 8 2.8结论 ........................................................................................................................... 8 第3章 系统分析 ..................................................................................................................... 9
3.1 概述 ........................................................................................................................... 9
3.1.1系统分析的原则 ................................................................................................. 9 3.1.2系统分析的方法 ................................................................................................. 9 3.2现行系统分析 .............................................................................................................10
3.2.1现行系业务流程分析 .........................................................................................10 3.2.2现行系统数据流程分析 .....................................................................................10
III
3.2.3现行系统存在的问题 ......................................................................................... 11 3.3新系统逻辑设计.......................................................................................................... 11
3.3.1新系统目标 ....................................................................................................... 11 3.3.2精品课网站管理信息系统业务流程分析 .............................................................12 3.3.3精品课网站管理信息系统数据流程分析 .............................................................16 3.4数据字典 ....................................................................................................................22
3.4.1数据元素定义 ...................................................................................................23 3.4.2数据存储 ..........................................................................................................26 3.4.3数据流 ..............................................................................................................28 3.4.4处理功能 ..........................................................................................................30 3.4.5外部实体 ..........................................................................................................32 3.5 数据存储结构规范化..................................................................................................33
3.5.1不满足3NF范式的数据存储结构 ......................................................................33 3.6 数据立即存取分析 .....................................................................................................34
3.6.1有关学生信息的立即存取分析 ...........................................................................34 3.6.2有关论坛的立即存取分析 ..................................................................................34 3.6.3有关试题的立即存取分析 ..................................................................................35 3.7系统数据分析 .............................................................................................................36 3.8处理功能描述 .............................................................................................................37 3.9系统分析的遗留问题...................................................................................................40 第4章 系统设计 ....................................................................................................................41
4.1概述 ..........................................................................................................................41
4.1.1系统设计目标..................................................................................................41 4.1.2 系统设计的原则 .............................................................................................41 4.1.3系统设计的方法 ..............................................................................................42 4.2 计算机系统配置 ........................................................................................................42
4.2.1硬件配置.........................................................................................................42 4.2.2软件配置.........................................................................................................43 4.2.3计算机系统的地理分布....................................................................................43 4.2.4网络协议.........................................................................................................43 4.2 系统总体结构设计 ....................................................................................................43 4.3数据库设计................................................................................................................48
4.3.1学生信息服务、数据管理、资源管理子系统数据库设计...................................48 4.3.2试题管理系子统数据库设计.............................................................................52 4.3.3电子习题册管理系子统数据库设计 ..................................................................52 4.3.4课程材料管理子统数据库设计 .........................................................................53 4.4编码设计 ...................................................................................................................53
4.4.1代码设计原则..................................................................................................53 4.4.2代码设计.........................................................................................................54
IV