《数据库课程设计-工资管理系统》.doc

目 录 第一章 绪论··················································3 1.1 背景···················································31.2 意义···················································31.3 开发工具···············································4 第二章 需求分析·············································42.1 系统需求描述···········································4 2.2 目标系统分析······················52.3 数据流程图（E—R图）···································52.4 数据字典···············································6 第三章 系统总体设计········································73.1 系统功能描述············································73.2 功能模块划分············································8 第四章 数据库设计··········································84.1 创建数据库··············································84.2 设计表结构··············································94.3 T—SQL语句创建表·······································11 4.4 T—SQL语句查询表中的信息·······························134.5T—SQL语句创建索引·····································134.6 T—SQL语句创建视图·····································14 4.7 T—SQL语句创建游标·····································154.8 T—SQL语句创建存储过程·································164.9T—SQL语句创建触发器····································184.10 T—SQL语句查询········································19 第五章 设计总结·············································22 参考文献·····················································24致谢·····················································25 摘 要随着信息时代的发展,过去的人工的管理已经不能满足企业公司的人事管理,而工资管理作为企业公司人事管理的一项重要工作,工作量大且繁琐，财务管理工作人员需要很大的耐心。本系统要对学校教师工资管理的日常的工资发放进行数据输入，并对各项工资条款进行计算。汇总各项数据生成企业员工工资数据库的后台，打印工资报表。 经过一个学期对sql server 2000的学习，同学们都认为真正的学到了有用知识，可能有一些人学的不够理想，但无论如何，这些知识都为我们的下一步学习打下了坚实的基础。做这么一个课程设计，一方面是为了检查我们一个学期来我们学习的成果，另一方面也是为了让我们进一步的掌握和运用它，同时也让我们认清自己的不足之处和薄弱环节，加以弥补和加强 关键字： 管理信息系统，数据库，工资管理，实体关系图（E-R图），数据字典，数据流程图，存储过程，视图，触发器绪 论 1.1背景 随着计算机技术的飞速发展,计算机在企业管理中的应用越来越普及,利用计算机实现企业工资的管理显得越来越重要.对于大中型企业来说,利用计算机支持企业高效率完成劳动人事管理的日常事务,是适应现代企业制度要求、推动企业劳动人事管理走向科学化、规范化的必要条件；而工资管理是一项琐碎、复杂而又十分细致的工作，工资计算、发放、核对的工作量很大，一般不允许出错，如果实行手工操作，每月发