【正文】 是“名稱”和“聯(lián)系方式”。有兩種單子需要出庫處理，分別是“批銷單”和“進(jìn)貨退貨單”，它們與“出庫”之間也是一對多聯(lián)系。此圖是一種面向問題的數(shù)據(jù)模型，是按照用戶的觀點(diǎn)對數(shù)據(jù)建立的模型。所以分為入庫處理和出庫處理，處理完的數(shù)據(jù)存入數(shù)據(jù)庫中。由此可見，開發(fā)此軟件在操作上是可行的。 時(shí)間可行性 軟件的時(shí)間可行性是指軟件在時(shí)間跨度上的實(shí)際范圍，本系統(tǒng)不存在千年蟲問題，具有良好的兼容性，可以在以后很長時(shí)間內(nèi)使用。 (3) 技術(shù)分析：相關(guān)技術(shù)的發(fā)展是否支持這個(gè)系統(tǒng)。根據(jù)客戶提出的系統(tǒng)功能、性能及實(shí)現(xiàn)系統(tǒng)的各項(xiàng)約束條件，從技術(shù)的 角度研究系統(tǒng)實(shí)現(xiàn)的可行性。 在澄清了問題定義之后，分析員應(yīng)該導(dǎo)出系統(tǒng)的邏輯模型。從而讓書店的工作人員從繁雜，枯燥的計(jì)算處理中解脫出來，把計(jì)算處理任務(wù)交給計(jì)算機(jī)去做從而提高工作效率，避免人為失誤。因?yàn)閳D書銷售系統(tǒng)中將涉及到很多的面對數(shù)據(jù)庫的操作，而這方面剛好是 Delphi的強(qiáng)項(xiàng)。 是基于控件和面向?qū)ο蟮木幊坦ぞ撸c Window 操作系統(tǒng)緊密的結(jié)合，強(qiáng)大的數(shù)據(jù)庫技術(shù)支持，而且還支持 ADO 技術(shù)，迅捷的編譯速度，同時(shí)還兼?zhèn)?Visual Basic 易學(xué)靈活的特點(diǎn)。這時(shí)，手工管理圖書信息就變得非常麻煩，特別是查詢圖書庫存或者變動(dòng)圖書的一些基本信息，這些工作一天需要做好幾遍，手工處理就更加的繁瑣。然而在我國還是一個(gè)新興的領(lǐng)域。最終系統(tǒng)能夠完成信息的輸入輸出，數(shù)據(jù)的修改、刪除、查詢和統(tǒng)計(jì)以及打印報(bào)表和圖表等功能，使用戶操作起來方便快捷。行業(yè)的快速發(fā)展必然導(dǎo)致市場競爭的加劇，要想在激烈的市場競爭中謀求發(fā)展，客觀上要求企業(yè)必須加強(qiáng)內(nèi)部管理、提高運(yùn)營效率。為了加快圖書銷售的信息科學(xué)化進(jìn)程，盡快建立和完善現(xiàn)代企業(yè)的信息化管理機(jī)制，我結(jié)合本次畢業(yè)設(shè)計(jì)的題目開發(fā)了圖書超市銷售系統(tǒng)。 關(guān)鍵字 信息管理系統(tǒng)，數(shù)據(jù)庫， 圖書 銷售系統(tǒng) ， ， SQL Sever2021 圖書銷售系統(tǒng) II Abstract The booming development that is along with the market economy, every trade be placed in the period that a high speed fast development of the profession, cause market peted by all means of add huge, to think that seek the development in vigorous market petition, objective top, request the business enterprise enhances the inner part the management and increases to carry camp efficieney. For the sake of quickly the scientific progress in information of the books sale establishes as soon as possible to turn to manage the mechanism with the information of the perfect and modern business enterprise, I binative a topic for graduating design, developped the books the sale the system. This system guides the bottom with the method at the theories that manage the information system, the adoption database technique text discussed first the graduate design chooses a background, purposes with the meaning, then described the terrace of development, database technique with each from of advantage, expatiateds the need analysis, total design of the system and realizes immediately after with circulate and end system can plete the information inputs and output, the modification of the data, delete, search with statistics and print the statement with chart etc. function, use the door operate the convenience fast. Key word Information management system Database Books Sale System 圖書銷售系統(tǒng) III 目 錄 摘 要 ............................................................................................................................ I Abstract.......................................................................................................................... II 2 小型書店圖書銷售系統(tǒng)分析 .................................................................................. 5 可行性分析 ...................................................................................... 5 技術(shù)可行性 ................................................................................................. 6 經(jīng)濟(jì)可行性 .............................................................................................. 6 時(shí)間可行性 .............................................................................................. 6 操作可行性 .............................................................................................. 6 系統(tǒng)流程分析 ............................................................................... 6 數(shù)據(jù)流程分析 ............................................................................... 7 系統(tǒng) ER 圖說明 ............................................................................. 8 3 圖書銷售系統(tǒng)的總體設(shè)計(jì) .................................................................................... 9 系統(tǒng)模塊總體設(shè)計(jì) ....................................................................... 9 數(shù)據(jù)庫設(shè)計(jì) .................................................................................. 10 數(shù)據(jù)分析 ................................................................................................... 11 數(shù)據(jù)庫設(shè)計(jì)注意事項(xiàng) .............................................................................. 11 數(shù)據(jù)庫的詳細(xì)設(shè)計(jì) ..................................................................... 11 4 圖書銷售系統(tǒng)實(shí)施及詳細(xì)設(shè)計(jì) ............................................................................ 15 系統(tǒng)登陸界面設(shè)計(jì) ..................................................................... 15 系統(tǒng)主窗 體設(shè)計(jì) ......................................................................... 16 采購管理模塊的實(shí)現(xiàn) ................................................................. 17 供應(yīng)商資料模塊設(shè)計(jì) .............................................................................. 17 進(jìn)貨模塊設(shè)計(jì) .......................................................................................... 20 財(cái)務(wù)管理模塊的實(shí)現(xiàn) ................................................................. 22 客戶往來帳目明細(xì)模塊設(shè)計(jì) ................................................................. 22 收款結(jié)算模塊設(shè)計(jì) .................................................................................. 22 統(tǒng)計(jì)分析模塊的實(shí)現(xiàn) ................................................................. 23 書籍進(jìn)貨排行榜模塊設(shè)計(jì) ....................................................................... 23 書籍綜合分析報(bào)表模塊設(shè)計(jì) ................................................................. 24 圖書銷售系統(tǒng) IV 內(nèi)部管理模塊的實(shí)現(xiàn) ................................................................. 24 切換用戶模塊設(shè)計(jì) .................................................................................. 24 個(gè)人記事本模塊設(shè)計(jì) .............................................................................. 25 個(gè)人密碼更改模塊設(shè)計(jì) .......................................................................... 25 5 圖書銷售系統(tǒng)的測試與維護(hù) ................................................................................ 26 系統(tǒng)的測試 .................................................................................. 26 系統(tǒng)測試的實(shí)施 ......................................................................... 27