武汉理工大学《数据库系统概论》课程设计说明书
目 录
1.开发背景..........................................................................................................................................1
1.1 定义.......................................................................................................................................1
1.2 合同分类...............................................................................................................................1
1.3 手工管理的缺陷...................................................................................................................1
1.4 合同管理系统的功能...........................................................................................................1
1.5 特性.......................................................................................................................................1
2.需求分析..........................................................................................................................................3
2.1 理解需求...............................................................................................................................3
2.2 需求分析..............................................................................................................................3
2.2.1 登录模块需求分析....................................................................................................3
2.2.2 签订合同模块需求分析............................................................................................3
2.2.3 执行合同模块需求分析............................................................................................3
2.2.4 查询执行合同模块需求分析....................................................................................4
2.2.5 条件查询合同信息模块需求分析...........................................................................4
3.概念设计..........................................................................................................................................5
3.1 业务流程图...........................................................................................................................5
3.2 数据库分析...........................................................................................................................5
3.3 数据库概念设计...................................................................................................................6
3.3.1.管理员实体................................................................................................................6
3.3.2.签订合同实体............................................................................................................6
3.3.3 执行合同实体............................................................................................................8
4.逻辑设计..........................................................................................................................................9
4.1 管理员信息表(LoginTable)..................................................................................................9
4.2 签订合同信息表(SignTable)................................................................................................9
4.3 执行合同信息表(ExcuteSign)..............................................................................................9
5.物理实现........................................................................................................................................10
5.1 功能结构图.........................................................................................................................10
5.2 用户登录模块.....................................................................................................................10
5.3 签订合同模块.....................................................................................................................11
5.4 执行合同模块.....................................................................................................................12
5.5 查询合同模块.....................................................................................................................12
5.6 条件查询模块.....................................................................................................................12
6.运行与测试....................................................................................................................................14
6.1 登录模块测试.....................................................................................................................14
6.2 签订模块测试.....................................................................................................................14
6.3 执行模块测试.....................................................................................................................14
6.4 条件查询模块测试.............................................................................................................14
7. 心得与体会...................................................................................................................................15
7.1 研制过程.............................................................................................................................15
7.2 对设计评价.........................................................................................................................15
7.3 心得与体会.........................................................................................................................15
8 参考文献........................................................................................................................................16