摘要随着互联网技术的高速发展，计算机技术不断深入各行各业，各大高校也开始使用计算机来解决教学问题。现阶段，各高校教师在出卷的过程中面临着试题库中试题数量少，试题质量不高的问题，在加大教师工作量、降低教学效率的同时，也严重影响了教学质量的测评。88527

因此，实现基于网络的通用试题库系统的设计，我们可以通过教师上传试题来实现对各高校之间试题的共享，又通过试题审核员审核试题保证试题质量。这不但缓解了教师的教学压力，也为学生提供了一个巩固课程知识的平台。

本文主要是对基于网络的通用试题库的数据库设计。通过对试题库系统的需求分析、概念结构设计、逻辑结构设计，使用MySQL数据库来设计数据库物理结构，包括表、索引、视图、触发器等，来达到数据库的操作和使用者的要求。

毕业论文关键字：试题库； 数据库；设计； MySQL

Abstract With the rapid development of Internet technology, computer technology continues to go all walks of life, the major colleges and universities have begun to use computers to solve teaching problems。 At present, the university teachers in the course of the volume in the face number of the questions in the test database, the test quality is not high, the increase in the workload of teachers, reduce the efficiency of teaching, but also a serious impact on the evaluation of teaching quality。           

Therefore, the design of the general question bank system based on the network, can pass the teacher to upload the test question, realizes the question sharing between colleges and universities, guarantees the question quality through the auditor audit question。 This not only alleviates the pressure of teachers' teaching, but also provides a platform for students to consolidate their knowledge。           

This paper is mainly about the database design of general tl question bank system based on the network。 Based on the test database system needs analysis, concept structure design, logic structure design, the use of MySQL database to design the database physical structure, including tables, indexes, views, triggers and so on, to achieve the operation of the database and user requirements。

Keyword：question bank system; database; design; MySQL

目录

第一章 引言 1

1。1 系统开发背景 1

1。2 系统开发的意义 1

第二章 系统需求分析 1

2。1 处理对象及组织 1

2。2 信息处理及系统功能 2

2。2。1 业务流程的调查 2

2。2。2 数据流程的建立 4

2。2。3 数据字典的建立 4

第三章 数据库结构源Y于Y优E尔Y论L文W网wwW.yOueRw.com 原文+QQ752018.766 的设计 6

3。1 数据库概念结构设计 6

3。1。1 分E-R图的建立 6

3。1。2