【正文】 過程，簡化操作步驟 create procedure procedure_selet_pro 查詢商供應的產(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)能夠達到模擬完成一次訂單銷售流程的要求。數(shù)據(jù)庫銷售訂單管理系統(tǒng)課程設計 目 錄 1．引言 ................................................................................................................................................................................. 1 編寫目的 ............................................................................................................................................................. 1 參考資料 ............................................................................................................................................................. 1 ............................................................................................................................................................................ 2 業(yè)務描述 ................................................................................................................................................................... 2 需求分析 ................................................................................................................................................................... 2 ............................................................................................................................................................... 3 ........................................................................................................................................................... 4 數(shù)據(jù)庫對象命名規(guī)則 ............................................................................................................................................... 4 數(shù)據(jù)項編碼規(guī)則 ....................................................................................................................................................... 4 ............................................................................................................................................................................ 5 ER 圖 .......................................................................................................................................................................... 5 關系模型 ................................................................................................................................................................... 5 ............................................................................................................................................................................ 6 表匯總 ........................................................................................................................................................................ 6 表 [1]:[ SUPPLIERS 表 ](供應商表 ) ............................................................................................................................ 6 表 [2]:[PRODUCT 表 ](產(chǎn)品表 ) ................................................................................................................................... 7 表 [3]:[SP 表 ](供應商產(chǎn)品供應表 ) .......................................................................................................................... 7 表 [4]:[ ORDERS 表 ](訂單表 ) ..................................................................................................................................... 8 表 [5]:[PO 表 ](產(chǎn)品訂購表 ) ...................................................................................................................................... 9 表 [6]:[ EMPLOYEE 表 ](雇員表 ) .............................................................................................................................. 10 表 [7]:[CUSTOMER表 ](客戶表 )............................................................................................................................... 11 視圖的設計 ............................................................................................................................................................ 11 存儲過程 的設計 ................................................................................................................................................. 12 觸發(fā)器的設計 ..................................................................................................................................................... 29 函數(shù)的設計 ....................................................................................................................................................... 30 ..................................................................................................................................................................... 31 防止用戶直接操作數(shù)據(jù)庫的方法 .................................................................................................................. 31 用戶帳號密碼的加密方法 .............................................................................................................................. 31 角色與權限 .............................................................................................................................................................. 31 ................................................................................................................................................ 32 1 總結(jié) ..................................................................................................................................................................................... 33 附錄 ...............................................................................................................