凱迪進(jìn)銷存系統(tǒng)畢業(yè)論文.doc

I摘要進(jìn)銷存系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開(kāi)發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開(kāi)發(fā)兩個(gè)方面.對(duì)于前者要求建立數(shù)據(jù)一致性和完整性強(qiáng),數(shù)據(jù)安全性好的數(shù)據(jù)庫(kù).而對(duì)于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。經(jīng)過(guò)分析如此情況,我們使用SQLserver2000作為后臺(tái)數(shù)據(jù)庫(kù)，VB作為數(shù)據(jù)庫(kù)系統(tǒng)開(kāi)發(fā)工具,利用其提供的各種面向?qū)ο蟮拈_(kāi)發(fā)工具,尤其是數(shù)據(jù)窗口這一能方便而簡(jiǎn)潔操縱數(shù)據(jù)庫(kù)的智能化對(duì)象,首先在短時(shí)間內(nèi)建立系統(tǒng)應(yīng)用原型,然后,對(duì)初始原型系統(tǒng)進(jìn)行需求迭代,不斷修正和改進(jìn),直到形成用戶滿意的可行系統(tǒng)?！娟P(guān)鍵詞】面向?qū)ο?；企業(yè)資源計(jì)劃；數(shù)據(jù)庫(kù)；管理信息系統(tǒng)IIAbstractStockandsellInfomationManagementSystemisdevelopmenttwoaspectsthattypicalinformationmanagementsystem(MIS),itsdevelopmentincludesprimarilythebackstagedatabaseestablisheswithsupportandtheheadappliesthedevelopmenttwoaspectsoftheprocedure.Establishthedataconsistencytotheformerrequestisstrongwiththecomplete,thethatdatasafetygooddatabase.Butrequestthelatterverymuchtheappliedprocedurefunctioncomplete,easyusageetc.characteristics.Throughtheanalysissuchcircumstance,weusetheACCESSasthebackstagedatabase,andtheVBasdatabasedevelopmenttool,makeuseofitseverykindofthetoolofdevelopmentthatprovidethatfacetotheobject,particularlyisintelligencethatdatawindowwaythisoncanningbeconvenientbutconciselymanipulatesthedatabaseturntheobject,establishintheinashorttimefirstsystemapplicationprototype,then,starttothebeginningprototypesystemproceedingneediterationonbehalf,revisecontinuouslywithimprove,reallyarrivetobecomethecustomersatisfiedcanAsystem.【Keywords】facetotheobject；enterpriseresourceplanning；database；managementinformationsystem.III目錄摘要.IABSTRACT.II第1章緒論.11.1選題背景.11.2論文的意義.11.3論文的目的.11.4國(guó)內(nèi)外研究現(xiàn)狀.2第2章相關(guān)理論研究.32.1管理信息系統(tǒng)的基本含義.32.2管理信息系統(tǒng)的功能.32.3ERP概述.42.4數(shù)據(jù)庫(kù)理論概述.52.5技術(shù)方案的選擇.62.5.1開(kāi)發(fā)環(huán)境.62.5.2性能需求.62.5.3運(yùn)行環(huán)境.7第3章系統(tǒng)分析.83.1系統(tǒng)開(kāi)發(fā)的必要性分析.83.2系統(tǒng)的初步調(diào)查.83.3系統(tǒng)開(kāi)發(fā)的可行性分析.93.4組織結(jié)構(gòu)分析.113.5業(yè)務(wù)流程分析.123.6數(shù)據(jù)流程圖.153.7數(shù)據(jù)字典.173.7.1數(shù)據(jù)項(xiàng)的描述.173.7.2數(shù)據(jù)結(jié)構(gòu)的描述.193.7.3數(shù)據(jù)流的描述.203.7.4處理邏輯的描述.213.7.5數(shù)據(jù)存儲(chǔ)的描述.223.7.6外部實(shí)體的描述.23IV3.8系統(tǒng)開(kāi)發(fā)方法.233.9系統(tǒng)開(kāi)發(fā)計(jì)劃.24第4章系統(tǒng)設(shè)計(jì).254.1總體設(shè)計(jì).254.2輸入設(shè)計(jì).264.2.1輸入設(shè)計(jì)的原則.264.2.2輸入設(shè)計(jì)的內(nèi)容.264.2.3數(shù)據(jù)輸入設(shè)備的選擇.274.2.4輸入屏幕設(shè)計(jì).274.3輸出設(shè)計(jì).284.3.1輸出設(shè)計(jì)的內(nèi)容.284.3.2輸出設(shè)計(jì)的方法.294.3.3輸出設(shè)計(jì)的具體實(shí)施.294.4界面設(shè)計(jì).304.4.1用戶界面的基本功能.314.4.2人機(jī)界面設(shè)計(jì).314.4.3菜單技術(shù).324.