房地产管理系统sql

中文摘要-I-中文摘要本论文主要论述的是房地产信息管理系统的数据库设计模块的设计和实现。房地产管理系统是针对房地产行业的需求设计和实现的。该系统的主要功能是将房地产发布流程纳入信息化管理，房地产系统数据库模块的主要完成的是房地产信息管理系统流程中数据库设计功能。课题研究过程中，首先对数据库设计模块进行了详尽的需求分析，经分析得到数据库设计模块主要完成登录表、房源信息表、员工信息表、客户信息表等数据库表的设计。之后根据需求提出了数据库设计模块的总体设计方案，并据此进行了详细设计和编码实现。论文中对课题的设计和开发进行了完整地论述。课题的开发主要应用了.NET技术及SQLServer数据库。系统开发完成后，对课题要求的功能设计出测试用例，进行功能测试，测试结果证明房地产信息管理系统数据库设计模块实现了对该系统功能支持，完成了课题的主要任务。关键词：房地产管理系统，SQLServer，.NET第一章绪论-1-AbstractThepresentpapermainelaborationistherealestateinformationmanagementsystemdatabasedesignmoduledesignandtherealization.Therealestatemanagementsystemmanagementsystemisaimsattherealestateprofessionthedemanddesignandtherealization.Thissystemmainfunctionistherealestateissuedtheflowbringsintolinewiththeinformationmanagement,therealestatesystemdatabasemodulemainlycompletesisintherealestateinformationmanagementsystemflowthedatabasedesignfunction.Inthetopicresearchprocess,hasfirstcarriedontheexhaustivedemandanalysistothedatabasedesignmodule,obtainsthedatabasedesignmoduleaftertheanalysismainlytocompletelandsthetable,roomsourcedatabasetabletheandsooninformationtable,staffingformationtable,customerinformationtabledesign.Proposedthedatabasedesignmodulesystemdesignplanafterwardsaccordingtothedemand,andaccordingtotheabovehascarriedonthedetaileddesignandthecoderealization.Inthepapercarriedontothetopicdesignandthedevelopmentcompletelyelaborated.ThetopicdevelopmenthasmainlyappliedNETthetechnologyandSQLServerdatabase.Afterthesystemdevelopmentcompletes,tothetopicrequestfunctionaldesignmeasuredthetestexample,carriesonthefunctiontest,thetestresultprovedtherealestateinformationmanagementsystemdatabasedesignmodulehasrealizedtothismodulefunctiondemand,hascompletedthetopicprimarymission.Keyword:Therealestatemanagessystem,Database,.NET本设计来自：完美毕业设计网：8191040说明：本软件/论文系有偿阅读、使用，完整CAD图纸或源代码请联系客服购买第一章绪论-2-目录中文摘要................................................................................................................IAbstract................................................................................................................1目录........................................................................................................................1第一章绪论.......................................................................................................31.1课题背景.................................................................................................31.2关键技术介绍.........................................................................................41.2.1ASP.NET........................................................................................41.2.2ADO.NET........................................................................................41.2.3SQLServer2000.......................................................................61.2.4SQLServer2000与.NETFramework的框架图....................71.3课题主要工作.........................................................................................7第二章需求分析...............................................................................................92.1房产信息系统数据库设计现状分析.....................................................92.1.1数据库发展..................................................................................92.1.2数据库分离技术的提出..............................................................92.1.3数据库分离技术的应用............................................................122.1.4数据库分离技术结论................................................................132.2房产系统的可行性分析.......................................................................132.3分析功能...............................................................................................14第三章系统的设计............................................................................................153.1系统功能流程图...................................................................................153.2数据库设计.............................................................错误!未定义书签。第四章系统实现与验证......................................................错误!未定义书签。4.1数据库的实现.........................................................错误!未定义书签。4.1.1创建数据库....................................................错误!未定义书签。4.1.2创建数据表....................................................错误!未定义书签。4.1.3创建触发器....................................................错误!未定义书签。4.2系统的实现.............................................................错误!未定义书签。4.2.1用户登录界面..............................................错误!未定义书签。4.2.2房源信息表..................................................错误!未定义书签。第一章绪论-3-4.2.3房产的查询..................................................错误!未定义书签。4.2.4员工的维护..................................................错误!未定义书签。4.2.5员工的维护..................................................错误!未定义书签。4.3系统验证.................................................................错误!未定义书签。4.3.1系统运行环境..............................................错误!未定义书签。4.3.2系统测试......................................................错误!未定义书签。结论...................................