| Customer Relationship Management (CRM), an enterprise business strategy implemented on the corporate level, aims to improve customer-related business activities in terms of efficiency, enhance customer satisfaction, increase customer loyalty, and identify customers’potential value, in order to reduce its operating costs and improve its profitability.In this paper, according to the business requirements of a well-known securities research and consulting firm, we design and implement a CRM system, by using Microsoft ASP. NET technology and MS-SQL Server database, adopting the currently mature multi-tier framework.We first introduce the background of the project, the basic concepts of customer relationship management and the different kinds of CRM systems, and also summarize the significance of the CRM systems for the enterprises.Then we describe the business requirements of the various subsystem respectively. In the part of the system design, with some examples of specific codes, we explain the application of the multi-tier framework to the system design, and brief the system design of different modules one by one, including database design, UI, and some of the key functions.And next the paper introduces the major system implementation process by taking two key pages as samples. At last, it briefs the usage of the system and its possibly future improvement.The CRM system is developed based on the Microsoft’s. Net platform, by using the B/S architecture, thus simplifying the system development and deployment, and reducing system maintenance costs. In the system implementation, we adopt the idea of taking the database as its core, that is, system depends on the SQL Server to achieve all the funcions, from UI presentation, access control, and even processing of a large number of business logic. |