目 录
1 绪 论..................................................................................................... 1
1.1
1.2
1.3
1.4
项目简介 ......................................................................................................1
设计目的 ......................................................................................................1
设计内容 ......................................................................................................1
应用范围 ......................................................................................................1
2 需求分析 .............................................................................................. 2
2.1 数据需求 ......................................................................................................2
2.2 事务需求 ......................................................................................................2
2.3
2.4
2.5
2.6
详细功能分析 ..............................................................................................2
数据字典 ......................................................................................................3
开发运行环境 ..............................................................................................3
安全保障 ......................................................................................................3
3 概念设计 .............................................................................................. 4
3.1 实体及联系抽象 ..........................................................................................4
3.2 E-R 图 ...........................................................................................................4
3.3 关系模式 ......................................................................................................6
4 逻辑设计 .............................................................................................. 7
4.1 各表功能 ......................................................................................................7
4.2 各表结构 ......................................................................................................7
4.3 表关系图 ......................................................................................................8
5 物理设计 .............................................................................................. 9
5.1
5.2
5.3
5.4
物理存储 ......................................................................................................9
完整性约束 ..................................................................................................9
视图设计 ......................................................................................................9
触发器设计 ................................................................................................10
6 系统实现与维护 ................................................................................ 11
6.1 模块 1 ......................................................................................................... 11
6.2 模块 2 .........................................................................................................17
6.3 模块 3 .........................................................................................................28
7 总 结............................................................................................... 337
7.1 系统实现程度 ..........................................................................................337
7.2 问题及难点 ..............................................................................................337
7.3 收获与体会 ..............................................................................................337
