摘 要
论文主要介绍了传统事业单位的工资管理方法以及传统工资管理所存在的缺陷与弊端，进而得出使用基于计算机上的工资管理信息系统的必要性。在事业单位以往的工资录入中，计算、合计等需要通过大量的手工完成，数据量多，处理速度慢，而且极易出错，导致工作效率低。为了解决这一矛盾，利用计算机来进行工资的管理，是十分必要的。论文重点论述了工资管理信息系统的组成与每个模块的功能。设计工资管理信息系统主要从模块组成、数据连接、功能实现、应用意义等方面着手。模块组成主要包括该工资系统的主要组成模块以及每个模块所要达到的功能。
工资管理的每个模块基本上脱离不了数据，所以在数据库设计的时候，要充分考虑数据的高效，减少数据冗余，保证系统的运行速度。设计过程主要以上面的分析的重点作为依据。首先进行基础数据的采集，然后进行工资的核算等。当然作为一个工资管理信息系统，其重要的一个方面是实现工资项目的自定义添加，该系统通过多个工资项目共存于一个数据表中来实现工资项目的自定义添加。在朝这个思想靠近的过程中，在许多小的细节上还存在着很多缺陷。
本系统采用Microsoft的Access来设计数据库，并使用当前优秀的开发工具:Microsoft Visual Basic，它有着最为灵活的数据库结构，对数据库应用有着良好的支持。论文主要介绍了本系统的开发背景，所要完成的功能和开发的过程，重点的说明了系统设计的重点、设计思想。
关键词：工资管理;信息管理系统;数据库;Microsoft Visual Basic.
I
Abstract
Thesis introduces traditional salary office procedure and traditional salary of Business unit manages the defect and drawback existed mainly, and then draws and use the necessity based on the management information system of salary on the computer. In Business unit long before, addition about salary needed a lot of work. Quantity of data is much, speed of dealing with data was slow it leaded to inefficiency, tedious and efficiency is not high, in order to solve this contradiction, it is very essential to make use of computer to carry on the management of the salary.
Thesis describes salary composition and each function of module of the management information system especially. Design salary the management
information system make up from module mainly, data connect, function realize, use respects, such as meaning, etc. not to set about. The module makes up the main main composition module including this salary system and function reached of each module. Each module of management of the salary can not break away from the data basically, so when the database is designed, is it considers data high-efficient, reduce datum
redundant fully to want. Speed of operation of the security system. I adopt ACCESS in database, lie in it and VB's compatibility is good.
Thesis is it writes salary design process of the management information system with VB with ACCESS to expound the fact finally. Design process as basis with above focal point of analysis mainly. Carry on the collection of the basic data at first, and then carry on the checking and calculating etc. of salary. Certainly as the management information system of a piece of salary, an important respect of it is to realize the adding self-definingly of project of the salary, system this realize salary project
self-defining to add through coexisting in a data list in a lot of salary projects. While close towards this thought, still there are a lot of defects on a lot of little details.
The system uses Microsoft Access to design the database, and uses current outstanding development kit: Microsoft Visual Basic，It has the most nimble database structure, and has the good support to the database application. The paper mainly introduced this topic development background, complete function and development process. The key explanation is system design, key point, design thought.
Key word: The salary; Information system; RDBMS; Microsoft Visual Basic.
II
目 录
第1章 绪 论 .......................................................................................................... 1
1.1 选题背景 ................................................................................................... 1 1.2 课题来源及意义 ....................................................................................... 1 1.3 系统基本达到的目标及结论 ................................................................... 2 第2章 可行性分析 ................................................................................................ 3
2.1可行性研究 ................................................................................................ 3
2.1.1 技术可行性 .................................................................................... 3 2.1.2 经济可行性 .................................................................................... 3 2.1.3 操作可行性 .................................................................................... 3 2.2 软、硬件配置及结构 ............................................................................... 4
2.2.1 硬件配置 ........................................................................................ 4 2.2.2 软件配置 ........................................................................................ 4 2.3 设计方法 ................................................................................................... 4 2.4 系统结构 ................................................................................................... 5
2.4.1 C/S模式简介 .................................................................................. 5 2.4.2 C/S模式的优点 .............................................................................. 5
第3章 系统需求分析 ............................................................................................ 6
3.1 需求分析的任务 ....................................................................................... 6 3.2 系统数据流图的创建 ............................................................................... 6 3.3 数据字典的创建 ....................................................................................... 8 第4章 系统概念结构设计 .................................................................................. 10
4.1 系统结构设计 ......................................................................................... 10 4.2 系统E-R图设计 ..................................................................................... 10 第5章 系统逻辑结构设计 ................................................................................ 13
5.1系统逻辑结构设计主要任务 .................................................................. 13 5.2 E-R图转换成关系模型 ........................................................................... 13 5.3 数据模型的优化 ..................................................................................... 17 第6章 数据库的物理实现 ................................................................................ 19
6.1 数据库的物理设计的内容和方法 ......................................................... 19 6.2 数据库表的创建 ..................................................................................... 20
III