目录
摘要 .............................................................................................................I
1 需求分析..................................................................................................1
1.1 系统目标设计................................................................................1
1.2 系统功能分析 ...............................................................................1
1.3 功能模块分析 ..............................................................................2
1.4 系统全局数据流图.....................................................................3
1.5 数据字典.......................................................................................3
2 概念结构设计........................................................................................7
2.1 构成系统的实体型 ......................................................................7
2.2 工资管理系统E-R图...................................................................7
3 逻辑结构设计........................................................................................9
3.1逻辑结构简介................................................................................9
3.2 关系模型......................................................................................9
4物理模型设计 ........................................................................................11
4.1定义数据库...................................................................................11
4.2 创立表 .........................................................................................11
4.3 创立存储过程............................................................................14
4.4 创立触发器 ................................................................................17
总结...........................................................................................................19
