汽車(chē)維修管理系統(tǒng)-于思淼

《汽車(chē)維修管理系統(tǒng)-于思淼》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。

1、軟件學(xué)院課程設(shè)計(jì)報(bào)告書(shū)課程名稱(chēng)數(shù)據(jù)庫(kù)原理及應(yīng)用課程設(shè)計(jì)設(shè)計(jì)題目汽車(chē)修理管理系統(tǒng)專(zhuān)業(yè)班級(jí)軟件工程12-5班學(xué)號(hào)1220010523姓名于思淼指導(dǎo)教師劉臘梅目錄1設(shè)計(jì)時(shí)間················································12設(shè)計(jì)目的················································13設(shè)計(jì)任務(wù)················································14設(shè)計(jì)內(nèi)容······························

2、··················14.1需求分析··············································14.2系統(tǒng)設(shè)計(jì)··············································24.2.1概念結(jié)構(gòu)設(shè)計(jì)········································24.2.2邏輯結(jié)構(gòu)設(shè)計(jì)········································44.2.1物理結(jié)構(gòu)設(shè)計(jì)·································

3、·······64.3系統(tǒng)實(shí)施··············································74.3.1數(shù)據(jù)庫(kù)實(shí)現(xiàn)··········································74.3.2數(shù)據(jù)載入···········································104.4運(yùn)行與測(cè)試···········································114.4.1運(yùn)行與測(cè)試·········································11

4、4.4.2分析···············································125總結(jié)與展望·············································12參考文獻(xiàn)·················································12成績(jī)?cè)u(píng)定·················································131設(shè)計(jì)時(shí)間2014年6月22日-2014年6月29日2設(shè)計(jì)目的數(shù)據(jù)庫(kù)原理及應(yīng)用課程設(shè)計(jì)是軟件工程專(zhuān)業(yè)集中實(shí)踐性環(huán)

5、節(jié)之一，是學(xué)習(xí)完《數(shù)據(jù)庫(kù)原理及應(yīng)用》及《SQLSERVER數(shù)據(jù)庫(kù)》課程后進(jìn)行的一次全面的綜合練習(xí)。其目的在于加深對(duì)數(shù)據(jù)庫(kù)基礎(chǔ)理論和基本知識(shí)的理解，掌握使用數(shù)據(jù)庫(kù)進(jìn)行軟件設(shè)計(jì)的基本方法，提高運(yùn)用數(shù)據(jù)庫(kù)解決實(shí)際問(wèn)題的能力，最終實(shí)現(xiàn)對(duì)于給定的應(yīng)用環(huán)境，構(gòu)造最優(yōu)的數(shù)據(jù)庫(kù)模式，建立數(shù)據(jù)庫(kù)及其應(yīng)用系統(tǒng)，使之能夠有效地存儲(chǔ)數(shù)據(jù)，滿(mǎn)足各種用戶(hù)的應(yīng)用需求（信息要求和處理要求）。同時(shí)，此次設(shè)計(jì)對(duì)于同學(xué)將來(lái)的畢業(yè)設(shè)計(jì)和具體工作實(shí)踐將有重要的意義。3設(shè)計(jì)任務(wù)課程設(shè)計(jì)要求學(xué)生在完成程序設(shè)計(jì)的同時(shí)能夠?qū)懗霰容^規(guī)范的設(shè)計(jì)報(bào)告。嚴(yán)格實(shí)施課程設(shè)計(jì)這一環(huán)節(jié)，對(duì)于學(xué)生基本程序設(shè)計(jì)素

6、養(yǎng)的培養(yǎng)和軟件工作者工作作風(fēng)的訓(xùn)練，將起到顯著的促進(jìn)作用。4設(shè)計(jì)內(nèi)容4.1需求分析（1）數(shù)據(jù)登記把各種手填單據(jù)中的數(shù)據(jù)及時(shí)登記到系統(tǒng)中、并要求能進(jìn)行修改。這些單據(jù)包括修車(chē)登記單、汽車(chē)修理單、零件入庫(kù)單、零件出庫(kù)單。（2）查詢(xún)能查詢(xún)登記單、修理單、汽車(chē)、車(chē)主、修理公、零件庫(kù)存的有關(guān)數(shù)據(jù)。（3）編制并顯示零件訂貨計(jì)劃月報(bào)表。（4）發(fā)票發(fā)票中包括顧客姓名、汽車(chē)牌號(hào)、修理項(xiàng)目、修車(chē)費(fèi)（=修理費(fèi)+零件費(fèi)）。零件費(fèi)=∑（零件價(jià)格×耗用數(shù)量）修理費(fèi)=小時(shí)工資×修理小時(shí)×3（5）統(tǒng)計(jì)修理工工資月報(bào)表某修理工的月工資=（∑小時(shí)工資）×修理小時(shí)14.2系統(tǒng)設(shè)計(jì)4.

7、2.1概念結(jié)構(gòu)設(shè)計(jì)E-R圖是分為兩部分實(shí)體和屬性，每個(gè)實(shí)體可以有多個(gè)屬性，這些屬性用來(lái)表示實(shí)體的性質(zhì)。不同實(shí)體之間可以用關(guān)系進(jìn)行連接，表明各個(gè)實(shí)體之間的內(nèi)在聯(lián)系。實(shí)體和實(shí)體之間的關(guān)系有一對(duì)一的關(guān)系（1：1），一對(duì)多的關(guān)系（1：N）和多對(duì)多的關(guān)系（N：M）。分E-R圖及各個(gè)實(shí)體之間的關(guān)系如下圖所示。電話(huà)姓名編號(hào)客戶(hù)車(chē)牌車(chē)型圖4.1編號(hào)客戶(hù)編號(hào)修理項(xiàng)目登記單登記時(shí)間圖4.22使用數(shù)量所用零件編號(hào)修理單修理耗時(shí)客戶(hù)號(hào)修理工修理項(xiàng)目圖4.3編號(hào)姓名修理工小時(shí)工資電話(huà)圖4.43最低庫(kù)存量編號(hào)零件單價(jià)名稱(chēng)庫(kù)存量圖4.5實(shí)體間的關(guān)系：11登記單登記客戶(hù)1下單

8、1N11N零件登記修理登記修理工圖4.64.2.2邏輯結(jié)構(gòu)設(shè)計(jì)數(shù)據(jù)庫(kù)邏輯設(shè)計(jì)的任務(wù)是將概念結(jié)構(gòu)轉(zhuǎn)換成特定DBMS所支持的數(shù)據(jù)模型的過(guò)程。從此開(kāi)始便進(jìn)入