5.2 关系模式.............................................................................................................................................................13
5.3 函数依赖集.........................................................................................................................................................14
六、 物理设计.............................................................................................................................................................15
6.1 表汇总.................................................................................................................................................................15
6.2 表 [1]:[表 SUPPLIERS]......................................................................................................................................16
6.3 表 [2]:[表 PRODUCT]........................................................................................................................................17
6.4 表 [3]:[表 SP]...................................................................................................................................................18
6.5 表 [4]:[表 PO]..................................................................................................................................................19
6.6 表 [5]:[表 CUSTOMER].....................................................................................................................................20
6.7 表 [6]:[表 ORDERR]..........................................................................................................................................21
6.8 表 [7]:[表 EMPLOYEE]......................................................................................................................................22
6.9 视图的设计.........................................................................................................................................................22
6.10 存储过程、函数触发器的设计.......................................................................................................................24
6.11 触发器的设计...................................................................................................................................................31
七、 安全性设计.........................................................................................................................................................33
7.1 防止用户直接操作数据库的方法.....................................................................................................................33
7.2 用户帐号密码的加密方法.................................................................................................................................33
7.3 角色与权限.........................................................................................................................................................34
八、 数据库管理与维护说明.....................................................................................................................................34
九、 总结.....................................................................................................................................................................35
十、 代码附录.............................................................................................................................................................35