房地产信息管理系统的设计与开发
摘要:MIS(Management Information System)就是信息管理系统,在强调管理,强调信息的现代社会中它变得越来越普及。MIS是一门新的学科,它跨越了若干个领域,比如管理科学、系统科学、运筹学、统计学以及计算机科学。在这些学科的基础上,形成信息收集和加工的方法,从而形成一个总很交错的系统。
房地产信息管理系统是典型的信息管理系统(MIS),是为房地产开发公司或者是中介公司管理房屋出租、出售信息资料而设计的信息管理系统,包含有后台数据库和前台应用程序系统两大部分,后台数据库要求数据的一致性和完整性、安全性,用以储存单位工程文档资料及相关信息,前台应用程序系统要求应用程序功能完备、易于使用和界面友好等。经过全面分析,确定数据库采用Microsoft SQL Server 2000,开发工具为Delphi 7.0,利用Microsoft公司的ADO(ActiveX Data Object,ActiveX数据对象)访问和操作数据库服务器中的数据。
本文基于Delphi和SQL SERVER开发实现公司信息管理,促进其经营活动和内部管理的规范化,系统开发遵循系统工程思想和技术,在系统的需求分析阶段,通过实地调研及资料查询,充分了解用户需求,得到反映公司业务流程及信息需求的数据流图和数据字典;在系统总体设计阶段,设计了系统概念模型,得到对应的关系模式和数据表。根据系统处理需求,得到了系统的功能设计,包括系统前、后台功能设计,有企业文化、公司动态、公司新闻、楼盘展示、在线交流,以及工程管理、销售管理和人事管理等;在详细设计与实现阶段,主要负责了对人事管理和在线交流两个功能进行编码、调试与集成,实现了对当前登录用户的密码修改,以及用户档案管理和权限管理查询、新增、修改和删除等功能,基本达到用户的要求。 关键词:数据库;信息管理系统;Delphi;SQL SERVER
Develop and Design Real Estate Information Management System
Abstract:MIS which we often mentioned in a society, which emphasizes in management science and information science, MIS is becoming more popular . MIS is a new discipline, it across several areas, such as management science, systems science, research, statistics and computer science. In the base of these disciplines, it formed a way of information collection and processing, thereby forming complex system. Real estate information management system is a typical Information management system is designed for the real estate development company. It can help the company manage the problems of housing rental, sale and management information, it contains two part, one is background database and the other is foreground application, background database request the data is consistency 、integrity and safety further it must have files of storage the project files and relevant information, and foreground application must have easy-to-use interface. After a series of analysis .So I determine use the Microsoft SQL Server 2000 for database and use the Delphi 7.0 for developing and make use of Microsoft Corporation Ado (ActiveX Data Object. ActiveX data object) visited data in the database server.
To achieve the development of Web-based information management to promote their business activities and internal management. Systems development thinking and follow the software engineering technology, the system's needs analysis stage, through field research and information enquiries, fully aware of user needs, reflected the company business processes and information needs of the data flow charts and data dictionary in the system design stage, Design concept model of the system, get the corresponding relations between the models and data sheets. According to system processing requirements, has the function of the system design, including the system before the background of functional design, corporate culture, News, Company News, the event display, online exchange, and project management, sales management and personnel management in the detailed design And implementation phase, the exchange of personnel management and online functions of the two codes, and integration mode, and on the current logged-on user's password editing and file management and user rights management query, add, edit and delete functions. Basic to the user’s requirements.
Keywords: database; information management system; Delphi, SQL SERVER