銷(xiāo)售訂單數(shù)據(jù)庫(kù)管理系統(tǒng)-展示頁(yè)
2025-04-21 11:03本頁(yè)面
【正文】 ...............................................................................1 參考資料 .............................................................................................................................................................12．需求規(guī)約 ..................................................................................................................................................................2 業(yè)務(wù)描述 .............................................................................................................................................................2 需求分析 .............................................................................................................................................................23．?dāng)?shù)據(jù)庫(kù)環(huán)境說(shuō)明 ......................................................................................................................................................44．?dāng)?shù)據(jù)庫(kù)的命名規(guī)則 ..................................................................................................................................................5 數(shù)據(jù)庫(kù)對(duì)象命名規(guī)則 .........................................................................................................................................5 數(shù)據(jù)項(xiàng)編碼規(guī)則 .................................................................................................................................................55．邏輯設(shè)計(jì) ..................................................................................................................................................................7 ER 圖 ....................................................................................................................................................................7 關(guān)系模式 .............................................................................................................................................................76．物理設(shè)計(jì) ................................................................................................................................................................10 表匯總 ...............................................................................................................................................................10 表[1][SUPPLIER 表]（供應(yīng)商表） ...................................................................................................................10 表[2][PRODUCT 表]（產(chǎn)品表） .........................................................................................................................11 表[3][SP 表]（供應(yīng)關(guān)系表） ............................................................11 表[4][EPC 表]（訂單表） ...............................................................12 表[5][EPC_DETAILED 表]（訂單細(xì)則表） ........................................................................................................13 表[6][EPLOYEE 表]（雇員表） .........................................................................................................................14 表[7][CUSTOMER 表]（客戶(hù)表） .......................................................................................................................15 視圖的設(shè)計(jì) .......................................................................................................................................................16 存儲(chǔ)過(guò)程、函數(shù)及觸發(fā)器的設(shè)計(jì) .................................................................................................................177．總結(jié) ........................................................................................................................................................................23附錄 ..............................................................................................................................................................................2411．引言 編寫(xiě)目的本文檔是銷(xiāo)售訂單數(shù)據(jù)庫(kù)管理系統(tǒng)設(shè)計(jì)文檔的組成部分，編寫(xiě)數(shù)據(jù)庫(kù)設(shè)計(jì)文檔的目的是：明確數(shù)據(jù)庫(kù)的表名、字段名等數(shù)據(jù)信息，用來(lái)指導(dǎo)后期的數(shù)據(jù)庫(kù)腳本的開(kāi)發(fā)，本文檔遵循《SQL SERVER 2022數(shù)據(jù)庫(kù)設(shè)計(jì)和開(kāi)發(fā)規(guī)范》 。本文檔的讀者對(duì)象是需求人員、系統(tǒng)設(shè)計(jì)人員、開(kāi)發(fā)人員、測(cè)試人員。 參考資料表 資料名稱(chēng) 作者 文件編號(hào)、版本《數(shù)據(jù)庫(kù)系統(tǒng)概論》 王珊、薩師煊 2022 年 5 月第 4 版《數(shù)據(jù)庫(kù)設(shè)計(jì)入門(mén)經(jīng)典》鮑威爾 2022 年 3 月第 1 版《數(shù)據(jù)庫(kù)原理》 克羅恩科 2022 年 6 月第 1 版
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1