1、商业企业人事数据库管理系统设计1资料内容仅供参考，如有不当或者侵权，请联系本人改正或者删除。II资料内容仅供参考，如有不当或者侵权，请联系本人改正或者删除。中文摘要当前 , 世界范围内的信息技术革命发展迅速。数据库技术的发展使数据库管理上了新的台阶, 几乎所有的信息管理系统都以数据库为核心 , 数据库系统在计算机领域的应用越来越广泛, 数据库系统本身也越来越完善。随着计算机应用的发展, 数据库系统也在不断更新、发展和完善。数据库与应用彼此独立、以一定的组织方式存储在一起、彼此互相关联、具有较少冗余、能被多个用户共享的数据集合。在市场经济的大环境中, 越来越多的认识逐渐认识到用计算机数据技术进行
2、名类管理、交流的便捷。其中最实际的应用是商业企业的人事计算机档案管理。随着网络技术的普及和发展 , 如何利用计算机技术整合企业信息系统数据资料, 提高数据资源的管理水平和效率迫在眉睫。数据库资源的整合、统一已经成为发展的必然趋势。数据库系统的应用, 能够使管理工作的效率的得到很大的提高 , 特别是人员管理、工资管理、报表统计等方面。企业能够经过数据库从不同的角度对数据进行日常更新、维护 , 极大提高了数据更新的及时性和准确性。本人经过对商业企业人事数据库系统流程的全面剖析, 从工作安排的基础上分析 , 可对企业设定的职位进行全面的管理和调整 : 建立员工档案库 , 录入人员数据 , 记录所有员
3、工的基本信息 , 并可输出跟人资料 , 建立全面的信息资料卡 , 减少重复录入 , 便于查询检索 : 可查看员工在企业工作期间的所有信息。跟踪所有员工从进入企III资料内容仅供参考，如有不当或者侵权，请联系本人改正或者删除。业到离职全过程的历史记录, 包括薪资变动、职位变动、奖惩情况等 ; 为能快速方便的从众多数据中定位某一个员工 , 提供灵活便捷的定位查询功能 ; 统计每位员工的月出勤结果并提供给薪资系统进行结算 ; 制定评估计划 , 对员工进行周期性考核、 评估 , 选择评估对象与评估规则 ; 记录员工在生产中的业绩评估情况 , 分析员工的业绩改进情况。关键词 : 数据库开发 ; 信息管理
4、 ; 数据查询 ; 触发器 ; SQLIV资料内容仅供参考，如有不当或者侵权，请联系本人改正或者删除。AbstractCurrently, the worldwide information technology revolution is developing rapidly. The development of database technology, database management on a new level, almost all of the information management systems are the core of the database, the
5、database system in the computer field has been widely applied, the database system itself is also more sophisticated. With the development of computer applications, database systems are constantly updated, developed and refined. Database and application independent of each other to be stored togethe
6、r in a certain tissue, associated with each other, with less redundancy, and can be shared by multiple users data set. In a market economy environment, more and more come to realize that understanding the data using computer technology to name class management, communication convenience. One of the
7、most practical application is a commercial enterprise personnel computer file management. With the popularization and development of network technology, how to use computer technology to integrate enterprise information system data, improve data resource management level and efficiency imminent. Dat
8、abase resource integration, unification has become an inevitable trend of development. Database system applications that can make the management of efficiency has beenV资料内容仅供参考，如有不当或者侵权，请联系本人改正或者删除。greatly improved, especially in personnel management, payroll management, reports, statistics and so o
9、n. Enterprises can use the database to the data from different perspectives daily updates, maintenance, greatly improving the timeliness of data updates and accuracy.I passed the personnel database system for commercial enterprises a comprehensive analysis of the process from analysis on the basis o
10、f the organization of work, you can set the position of the enterprise to conduct a comprehensive management and adjustment: Create archives staff, data entry staff to record basic information about all employees , and output information with people, to establish a comprehensive information card, re
11、duce duplication of entry, ease of retrieval queries: employees in the enterprise can view all of the information during the work. Track all employees from entering businesses to leave the whole process of historical records, including payroll changes, job changes, incentives, etc.; was able to quic
12、kly and easily locate the data from a certain number of employees, providing flexible and convenient location query function; statistics each results of monthly attendance of employees and provided to the payroll system for settlement; develop evaluation plan for staff cyclical assessment, evaluation, selection, evaluation and assessment of the object rules; records of employee performance appraisal in the production, analysis of employeeVI资料内容仅供参考，如有不当或者侵权，请联系本人改正或者删除。performance improvement.Key words: Database development; Information Management; data query; trigger;SQLVII
