中文摘要-I-中文摘要本論文主要論述的是房地產(chǎn)信息管理系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì)模塊的設(shè)計(jì)和實(shí)現(xiàn)。房地產(chǎn)管理系統(tǒng)是針對(duì)房地產(chǎn)行業(yè)的需求設(shè)計(jì)和實(shí)現(xiàn)的。該系統(tǒng)的主要功能是將房地產(chǎn)發(fā)布流程納入信息化管理，房地產(chǎn)系統(tǒng)數(shù)據(jù)庫(kù)模塊的主要完成的是房地產(chǎn)信息管理系統(tǒng)流程中數(shù)據(jù)庫(kù)設(shè)計(jì)功能。課題研究過(guò)程中，首先對(duì)數(shù)據(jù)庫(kù)設(shè)計(jì)模塊進(jìn)行了詳盡的需求分析，經(jīng)分析得到數(shù)據(jù)庫(kù)設(shè)計(jì)模塊主要完成登錄表、房源信息表、員工信息表、客戶信息表等數(shù)據(jù)庫(kù)表的設(shè)計(jì)。之后根據(jù)需求提出了數(shù)據(jù)庫(kù)設(shè)計(jì)模塊的總體設(shè)計(jì)方案，并據(jù)此進(jìn)行了詳細(xì)設(shè)計(jì)和編碼實(shí)現(xiàn)。論文中對(duì)課題的設(shè)計(jì)和開發(fā)進(jìn)行了完整地論述。課題的開發(fā)主要應(yīng)用了.NET技術(shù)及SQLServer數(shù)據(jù)庫(kù)。系統(tǒng)開發(fā)完成后，對(duì)課題要求的功能設(shè)計(jì)出測(cè)試用例，進(jìn)行功能測(cè)試，測(cè)試結(jié)果證明房地產(chǎn)信息管理系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)模塊實(shí)現(xiàn)了對(duì)該系統(tǒng)功能支持，完成了課題的主要任務(wù)。關(guān)鍵詞：房地產(chǎn)管理系統(tǒng)，SQLServer，.NETAbstract-II-AbstractThepresentpapermainelaborationistherealestateinformationmanagementsystemdatabasedesignmoduledesignandtherealization.Therealestatemanagementsystemmanagementsystemisaimsattherealestateprofessionthedemanddesignandtherealization.Thissystemmainfunctionistherealestateissuedtheflowbringsintolinewiththeinformationmanagement,therealestatesystemdatabasemodulemainlycompletesisintherealestateinformationmanagementsystemflowthedatabasedesignfunction.Inthetopicresearchprocess,hasfirstcarriedontheexhaustivedemandanalysistothedatabasedesignmodule,obtainsthedatabasedesignmoduleaftertheanalysismainlytocompletelandsthetable,roomsourcedatabasetabletheandsooninformationtable,staffingformationtable,customerinformationtabledesign.Proposedthedatabasedesignmodulesystemdesignplanafterwardsaccordingtothedemand,andaccordingtotheabovehascarriedonthedetaileddesignandthecoderealization.Inthepapercarriedontothetopicdesignandthedevelopmentcompletelyelaborated.ThetopicdevelopmenthasmainlyappliedNETthetechnologyandSQLServerdatabase.Afterthesystemdevelopmentcompletes,tothetopicrequestfunctionaldesignmeasuredthetestexample,carriesonthefunctiontest,thetestresultprovedtherealestateinformationmanagementsystemdatabasedesignmodulehasrealizedtothismodulefunctiondemand,hascompletedthetopicprimarymission.Keyword:Therealestatemanagessystem,Database,.NET目錄-III-目錄中文摘要.IAbstract.II目錄.III第一章緒論.11.1課題背景.11.2關(guān)鍵技術(shù)介紹.21.2.1ASP.NET.21.2.2ADO.NET.21.2.3SQLServer200SQLServer2000與.NETFramework的框架圖.41.3課題主要工作.5第二章需求分析.72.1房產(chǎn)信息系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)現(xiàn)狀分析.72.1.1數(shù)據(jù)庫(kù)發(fā)展.72.1.2數(shù)據(jù)庫(kù)分離技術(shù)的提出.72.1.3數(shù)據(jù)庫(kù)分離技術(shù)的應(yīng)用.102.1.4數(shù)據(jù)庫(kù)分離技術(shù)結(jié)論.112.2房產(chǎn)系統(tǒng)的可行性分析.112.3分析功能.12第三章系統(tǒng)的設(shè)計(jì).133.1系統(tǒng)功能流程圖.133.2數(shù)據(jù)庫(kù)設(shè)計(jì).14第四章系統(tǒng)實(shí)現(xiàn)與驗(yàn)證.164.1數(shù)據(jù)庫(kù)的實(shí)現(xiàn).164.1.1創(chuàng)建數(shù)據(jù)庫(kù).164.1.2創(chuàng)建數(shù)據(jù)表.164.1.3創(chuàng)建觸發(fā)器.184.2系統(tǒng)的實(shí)現(xiàn).224.2.1用戶登錄界面.2