1、需求分析阶段...........................................................................................................................................................3
2、概念结构设计阶段...................................................................................................................................................3
3、逻辑结构设计阶段...................................................................................................................................................4
4、物理设计阶段...........................................................................................................................................................4
5、数据库安全及维护设计阶段...................................................................................................................................4
6、实施阶段...................................................................................................................................................................4
一、引言.........................................................................................................................................................................7
1.1 编写目的..............................................................................................................................................................7
1.2 参考资料..............................................................................................................................................................7
二、 需求规约............................................................................................................................................... ............. ...8
2.1 业务描述..............................................................................................................................................................8
2.2 需求分析..............................................................................................................................................................9
三、 数据库环境说明................................................................................................................................... ............. ...9
四、 数据库的命名规则............................................................................................................................. ............. ...10
4.1 数据库对象命名规则........................................................................................................................................10
4.2 数据项编码规则.................................................................................................................................................11
五、 逻辑设计............................................................................................................................................. ............. ...12
5.1 ER 图..................................................................................................................................................................12
5.2 关系模型............................................................................................................................................................12
六、 物理设计............................................................................................................................................. ............. ...13
6.1 表汇总................................................................................................................................................................13
6.2 表[1]:[ SUPPLIERS 表](供应商表)......................................................................................................................13
6.3 表[2]:[ PRODUCT 表](产品表)............................................................................................................................14
6.4 表[3]:[ SP 表](供应商产品供应表)...................................................................................................................14
6.5 表[4]:[ ORDERS 表](订单表)..............................................................................................................................15
6.6 表[5]:[ PO 表](产品订购表)..............................................................................................................................16
6.7 表[6]:[ EMPLOYEE 表](雇员表)..........................................................................................................................16
6.8 表[7]:[ CUSTOMER 表](客户表)..........................................................................................................................17
6.9 视图的设计........................................................................................................................................................17
6.10 存储过程的设计..............................................................................................................................................18
6.11 触发器的设计...................................................................................................................................................22
七、 安全性设计......................................................................................................................................... ............. ...23
7.1 防止用户直接操作数据库的方法....................................................................................................................23
7.1.1 用户标识和鉴定..............................................................................................................................................23
7.1.2 存取控制..........................................................................................................................................................23