达州博瑞实业有限公司人事信息管理系统的设计与实现

【作者】 唐瑜；

【导师】 罗克露； 陈文述；

【作者基本信息】 电子科技大学 ， 软件工程， 2007， 硕士

【摘要】 随着信息技术在管理上深入和广泛的应用,管理信息系统(MIS)的实施在技术上已逐步成熟。MIS是一个不断发展的新型学科,任何一个单位要生存要发展,要高效率地把内部活动有机地组织起来,就必须建立与自身特点相适应的MIS。本文论述了MIS的基本原理和一个真实MIS的开发过程。通过分析达州博瑞实业有限公司的人事管理过程,创建了一套行之有效的计算机管理人事信息的方案,设计并实现了以信息关系为中心的一个小型MIS软件。系统包括对员工的档案、出勤和工资等进行高效自动的管理。具体论述了企业人事信息管理系统的结构、系统开发的基本原理和一些使用说明。系统分析部分主要介绍了可行性分析和需求分析;系统设计部分介绍了系统功能设计、数据库设计和代码设计;系统实现部分说明了几个主要模块的算法,本系统界面友好,操作简单,比较实用。论文的主要工作是:1)设计一种提供决策支持的MIS,在设计和实现过程中应用流行的或者先进的数据库系统,设计了优秀的查询和统计功能。2)尝试利用小型关系数据库系统,管理和分析数据,支持决策。3)论述了SQL查询优化的必要性和方法。4)实现对人事信息的一系列有特色的操作:批量删除修改、数据重排及打印功能等。更多还原

【Abstract】 With the information technology in the management more and more used, the implementation of the management information system is gradually becoming mature in technology. The management information system is a new major which develops unceasingly. Any company must establish the management information system which adapts with own characteristics if they want to survive , develop and organize the internal activity organically with high efficiency.This article introduces a process of developing a management information system with the strategy of“the overall plan from the top to bottom ;the application and development from bottom to top under the Basic6.0 . By analyzing the management of Dazhou Borui Co., Ltd , we found a set of effective plans of managing personnel information by computer to solve the problem of the insufficiency of man-power management. We designs and realizes a small information management system software taking the information relations as a center. The system includes staff’s file, duty and wages. It specifically elaborated the structure of enterprise personnel information management system, the basic principle and the method of system development and some operating instructions as well. It includes feasibility analysis, service flow analysis and so on. The system design mainly introduces the system function design, the database design and the code design. The system realization explains several main module algorithms. This system horizon is friendly and the operation is simple and quite practical.The main work focus on:1) Designing one kind of MIS to provide the policy-making support; Applying popular or advanced database system in the design and the realization process, designing the outstanding inquiry and statistical function.2.) Attempting to use small relational database system to manage, analyze data and support the decision-making.3) Illustrating the necessary and method of inquiry optimization of SQL. 4) Carrying out a series of special operation on human resource: deleting data in batches, data sorting and printing.更多还原