目录
1 引言 ....................................................................................................................................1
2 数据库设计 .........................................................................................................................1
2。1。1 需求设计 ......................................................................................................1
1、引言 ........................................................................................................1
2、目标与任务 .............................................................................................1
3、阶段结果 ................................................................................................3
2.1。2 概念设计 ........................................................................................................6
2.1。2。1 目标与任务 ..................................................................................6
2。1.2.2 概念模型设计 .................................................................................6
2.1。3 逻辑设计 ........................................................................................................9
2.1.3。1 目标与任务 .....................................................................................9
2。1。3。2 数据组织 ...................................................................................9
2.1.3。3 数据处理方面 ...............................................................................12
2.1.4 物理设计 .........................................................................................................13
2.1。4 目标与任务 ......................................................................................13
2.1。4。2 数据存取方面 ............................................................................14
2。1。4。3 功能模块 .................................................................................14
2.1.5 数据库实施 .....................................................................................................15
2.1。6 数据库调试与试运行 ....................................................................................16
3 收获与体会 .......................................................................................................................18
4 存在问题与建议 ................................................................................................................18
附录 ......................................................................................................................................18
1．数据字典 ............................................................................................................18
2．存储过程： ........................................................................................................20
3．基本表： ............................................................................................................24
4．视图 ...................................................................................................................27
5．参考资料 ............................................................................................................27
