【正文】 銷售訂單數(shù)據(jù)庫管理系統(tǒng)目錄1．引言 ..........................................................................................................................................................................1 編寫目的 .............................................................................................................................................................1 參考資料 .............................................................................................................................................................12．需求規(guī)約 ..................................................................................................................................................................2 業(yè)務描述 .............................................................................................................................................................2 需求分析 .............................................................................................................................................................23．數(shù)據(jù)庫環(huán)境說明 ......................................................................................................................................................44．數(shù)據(jù)庫的命名規(guī)則 ..................................................................................................................................................5 數(shù)據(jù)庫對象命名規(guī)則 .........................................................................................................................................5 數(shù)據(jù)項編碼規(guī)則 .................................................................................................................................................55．邏輯設計 ..................................................................................................................................................................7 ER 圖 ....................................................................................................................................................................7 關系模式 .............................................................................................................................................................76．物理設計 ................................................................................................................................................................10 表匯總 ...............................................................................................................................................................10 表[1][SUPPLIER 表]（供應商表） ...................................................................................................................10 表[2][PRODUCT 表]（產(chǎn)品表） .........................................................................................................................11 表[3][SP 表]（供應關系表） ............................................................11 表[4][EPC 表]（訂單表） ...............................................................12 表[5][EPC_DETAILED 表]（訂單細則表） ........................................................................................................13 表[6][EPLOYEE 表]（雇員表） .........................................................................................................................14 表[7][CUSTOMER 表]（客戶表） .......................................................................................................................15 視圖的設計 .......................................................................................................................................................16 存儲過程、函數(shù)及觸發(fā)器的設計 .................................................................................................................177．總結 ........................................................................................................................................................................23附錄 ..............................................................................................................................................................................2411．引言 編寫目的本文檔是銷售訂單數(shù)據(jù)庫管理系統(tǒng)設計文檔的組成部分，編寫數(shù)據(jù)庫設計文檔的目的是：明確數(shù)據(jù)庫的表名、字段名等數(shù)據(jù)信息，用來指導后期的數(shù)據(jù)庫腳本的開發(fā)，本文檔遵循《SQL SERVER 2022數(shù)據(jù)庫設計和開發(fā)規(guī)范