【正文】 過程，簡化操作步驟 create procedure procedure_selet_pro 查詢商供應(yīng)的產(chǎn)品 snumber char(32) as 23 if not exists(select s_number from Suppliers where S_number=snumber ) print39。該產(chǎn)品庫存不足不予以訂購 39。你輸入的客戶不存在 39。 create view view_orders 12 as select c_number,count(o_number)總數(shù) from orders group by c_number。 總的來說，本數(shù)據(jù)庫系統(tǒng)能夠達(dá)到模擬完成一次訂單銷售流程的要求。數(shù)據(jù)庫銷售訂單管理系統(tǒng)課程設(shè)計(jì) 目 錄 1．引言 ................................................................................................................................................................................. 1 編寫目的 ............................................................................................................................................................. 1 參考資料 ............................................................................................................................................................. 1 ............................................................................................................................................................................ 2 業(yè)務(wù)描述 ................................................................................................................................................................... 2 需求分析 ................................................................................................................................................................... 2 ............................................................................................................................................................... 3 ........................................................................................................................................................... 4 數(shù)據(jù)庫對象命名規(guī)則 ............................................................................................................................................... 4 數(shù)據(jù)項(xiàng)編碼規(guī)則 ....................................................................................................................................................... 4 ............................................................................................................................................................................ 5 ER 圖 .......................................................................................................................................................................... 5 關(guān)系模型 ................................................................................................................................................................... 5 ............................................................................................................................................................................ 6 表匯總 ........................................................................................................................................................................ 6 表 [1]:[ SUPPLIERS 表 ](供應(yīng)商表 ) ............................................................................................................................ 6 表 [2]:[PRODUCT 表 ](產(chǎn)品表 ) ................................................................................................................................... 7 表 [3]:[SP 表 ](供應(yīng)商產(chǎn)品供應(yīng)表 ) .......................................................................................................................... 7 表 [4]:[ ORDERS 表 ](訂單表 ) ..................................................................................................................................... 8 表 [5]:[PO 表 ](產(chǎn)品訂購表 ) ...................................................................................................................................... 9 表 [6]:[ EMPLOYEE 表 ](雇員表 ) .............................................................................................................................. 10 表 [7]:[CUSTOMER表 ](客戶表 )............................................................................................................................... 11 視圖的設(shè)計(jì) ............................................................................................................................................................ 11 存儲過程 的設(shè)計(jì) ................................................................................................................................................. 12 觸發(fā)器的設(shè)計(jì) ..................................................................................................................................................... 29 函數(shù)的設(shè)計(jì) ....................................................................................................................................................... 30 ..................................................................................................................................................................... 31 防止用戶直接操作數(shù)據(jù)庫的方法 .................................................................................................................. 31 用戶帳號密碼的加密方法 .............................................................................................................................. 31 角色與權(quán)限 .............................................................................................................................................................. 31 ................................................................................................................................................ 32 1 總結(jié) ..................................................................................................................................................................................... 33 附錄 ...............................................................................................................