1、 大型数据库课程设计大型数据库课程设计 课程设计说明书课程设计说明书 学 生 姓 名 :XX 班级 : 学号 : 指 导 教 师 :XX 所属系(部) :信息系 二一七年六月二一七年六月 I 摘摘 要要 企业人事管理信息系统是一个现代化的企业在竞争中立于不败之地的必要部分, 它能够为查询人事信息提供充足的信息和快捷的查询手段。 一些公司一直以来使用传 统人工的方式管理文件档案,这种管理方式存在着许多缺点,如:效率低、保密性差, 另外时间一长,将产生大量的文件和数据,这对于查找、更新和维护都带来了不少的 困难,而且容易丢失。 使用计算机对企业人事信息进行管理,具有手工管理所无法比拟的优点。例如:
2、 检索迅速、查找方便、可靠性高、存储量大、保密性好、寿命长、成本低等。这些优 点能够极大地提高企业人事管理的效率,也是企业的科学化、正规化管理,与世界接 轨的重要条件。 此次的企业人事管理系统是采用 SQL Server2005 作为开发数据库的工具。企业 人事管理系统的具体功能可以根据用户的需要来分配, 但主要还是包括企业人事的信 息添加,删除,修改,查找,同时也包括权限的分配,职务的调动等。在企业人事管 理系统中,用户能够方便的企业人事进行信息的检索与处理。 关键词:关键词:人事管理;数据库;查询手段;SQL Server2005。 II AbstractAbstract The busi
3、ness enterprise personal management information system is a modern enterprise in the necessary part of the competition, it is able to provide the personnel information query sufficient information and quick inquiry method. Some companies have been using the traditional artificial way management docu
4、ment file, this management way has many shortcomings, such as: low efficiency, poor confidentiality, another time a long, will produce a large number of documents and data, to find, update and maintain all bring a lot of difficulties, and easy to lose. The use of computer to manage enterprise person
5、nel information has the advantages that manual management cannot compare. For example: quick search, easy to find, high reliability, large storage, good confidentiality, long life, low cost, etc. These advantages can greatly improve the efficiency of enterprise personnel management, also is the scie
6、ntific and regularization management of the enterprise, and the important condition of the world. The enterprise personnel management system is used as a tool to develop database in SQL server 2005. The specific function of enterprise personnel management system can be allocated according to the needs of users, but mainly include the enterprise personnel information to add, delete, modify, search, also including the distribution of the authority at the same time, job transfer, et