2.3.5 数据处理描述...........................................................................................................................26
2.3.6 遗留问题...................................................................................................................................27
2.4 用户领导审批意见..............................................................................................................................27
3．系统设计报告.......................................................................................................................28
3.1 概述......................................................................................................................................................29
3.1.1 系统设计目标...........................................................................................................................29
3.1.2 系统设计策略...........................................................................................................................29
3.2 计算机系统配置..................................................................................................................................29
3.2.1 硬件配置...................................................................................................................................29
3.2.2 软件配置...................................................................................................................................30
3.3 系统结构设计......................................................................................................................................30
销售管理结构图如图 3-3 所示。.............................................................................................................31
3.4 模块设计..............................................................................................................................................32
订货销售模块说明书，如下表 3-2 所示。...........................................................................................32
3.5 数据库设计..........................................................................................................................................32
3.5.1 数据库逻辑设计.......................................................................................................................32
3.5.2 数据库物理设计.......................................................................................................................33
字段名........................................................................................................................................................34
数据类型....................................................................................................................................................34
字段大小....................................................................................................................................................34
可否为空....................................................................................................................................................34
说明............................................................................................................................................................34
发货单编号................................................................................................................................................34
数字............................................................................................................................................................34
长整型........................................................................................................................................................34
否................................................................................................................................................................34
主键............................................................................................................................................................34
商品编号....................................................................................................................................................34
数字............................................................................................................................................................34
长整型........................................................................................................................................................34
否................................................................................................................................................................34
主键............................................................................................................................................................34
商品数量....................................................................................................................................................34
数字............................................................................................................................................................34
20................................................................................................................................................................34
否................................................................................................................................................................34
金额............................................................................................................................................................34
货币............................................................................................................................................................34
50................................................................................................................................................................34
否................................................................................................................................................................34
发货日期....................................................................................................................................................34
日期/时间...................................................................................................................................................34
10................................................................................................................................................................34
否................................................................................................................................................................34
供应商编号................................................................................................................................................34
数字............................................................................................................................................................34
长整型........................................................................................................................................................34
否................................................................................................................................................................34
主键............................................................................................................................................................34
3.5.3 数据库保证...............................................................................................................................34
xklxll2014-03-28很好，很有用，很强大
