安徽工业大学毕业设计(论文)任务书课题名称客户关系管理系统(CRM)的设计与实现学院管理科学与工程学院专业班级信息管理与信息系统姓名学号毕业设计(论文)的主要内容及要求:1.分析研究当前客户关系管理软件现状。2.对系统可行性进行研究3.分析用户的需求,进行需求分析4.对系统总体设计,包括功能分析,业务流程和数据流程分析5.系统详细设计,分析系统流程,主要对数据库进行设计6.系统实现以及界面设计7.系统测试8.毕业论文撰写指导教师签字:摘要随着社会经济和科学技术的发展,企业信息化已经成为企业的迫切需要,CRM正是当代企业信息化的关键之一,通过CRM可以提高企业的管理水平、经济效益。CRM在企业中起到了很大的作用,它改善服务、提高效率、降低成本、扩大销售,不仅将给企业带来意想不到的收益,也将彻底改变企业运行的战略思维。根据所研究的CRM知识和自身的计算机水平,我采用ASP+SQLServer2005方式,采用B/S结构,模拟设计客户关系管理系统,并将其分成了以下五个子系统:客户管理、库存管理、Email管理、服务管理、用户管理。本文以系统分析、数据库设计、系统结构和功能模块设计、系统程序开发这几个方面来全方位的介绍本CRM系统。在整个系统中,为保证系统的安全性,特采用了用户管理模块,根据用户的权限,对其每位用户限定了系统中基本信息的增、删、改的权限。本系统通过维护客户、联系人、活动、销售的基本信息的功能,实现从不同的角度对客户相关信息的查询,以及从不同的角度对所有客户产生的销售额的具体分析,体现每位客户的价值。关键词:CRMB/S模式系统设计SQLServer2005数据库AbstractAlongwiththedevelopmentofthesocialeconomyandthescienceandtechnology,theenterpriseinformationizationalreadybecametheurgentneedofenterprise.CRMwaspreciselyonekeyofthecontemporaryenterprisesinformationization.ItmightenhancetheenterprisemanagementlevelandtheeconomicefficiencybyusingCRM.CRMplayedtheverymajorroleintheenterprise,itimprovestheservice,enhancestheefficiency,reducesthecost,expandsthesale,anditnotonlywillbringtheunexpectedincometotheenterprise,alsocompletelychangethestrategicthoughtoftheenterprisemovement.AccordingtoCRMknowledgewhichstudiesandowncomputerlevel,IuseASPandSQLServer2005waysandadoptB/Sstructuretodesigncustomerrelationsmanagementsysteminsimulation.Ithasdividedintofollowingfivesub-systems:customermanagement,stockmanagement,Emailmanagement,servicemanagement,usermanagement.ThisarticleintroductionthisCRMsystemfromtheseaspectswhicharethesystemanalysis,thedatabasedesign,thesystemstructureandthefunctionmoduledesign,thesystemprogramdevelops.Intheoverallsystem,forthesecurityoftheguaranteesystem,ithasusedtheuseradministrationmoduleespecially.Accordingtouser'sstatus,ithaddefinedthejurisdictionwhichincreases,deletes,changestothebasicinformationtoitseachuserinthesystem.Throughthefunctionwhichmaintenancethebasicinformationofthecustomer,thecontactperson,theactive,theexpendituresandthesales,thissystemrealizestheinquiryofthecustomercorrelateinformationfromthedifferentangle,aswellasconcreteanalysisofthesalesvolumewhichproducestoallcustomersfromthedifferentangle,andmanifeststhevalueofeachcustomer.Keywords:CRMB/SmodeSystemDesignSQLServer2005DataBase目录1.绪论................................................................11.1课题背景.........................................................11.2系统目标.........................................................21.3总体任务.........................................................21.4开发环境简介.....................................................21.4.1ASP简介......................................................21.4.2ASP工作原理..................................................31.5B/S模式概述......................................................31.5.1B/S模式的作用................................................31.5.2B/S模式的优势与劣势..........................................42.系统调查与可行性研究................................................52.1CRM的概念及意义..................................................52.1.1CRM的概念....................................................62.1.2客户关系管理的意义...........................................62.1.3企业实施CRM的意义...........................................72.2可行性研究.......................................................82.2.1系统的可行性分析.............................................83.系统分析............................................................93.1需求分析.........................................................93.1.1市场需求分析................................................103.1.2系统需求分析................................................103.2系统组织结构分析................................................113.3系统流程分析....................................................113.3.1业务流程分析................................................113.3.2数据流程分析................................................123.4数据字典........................................................133.5系统UML建模....................................................183.5.1USECASE分析................................................183.5.2建立系统静态模型............................................233.5.3建立系统动态模型............................................234.系统设计...........................................................244.1系统功能结构设计................................................254.2系统详细设计....................................................264.2.1数据库概念结构设计..........................................264.2.2数据库逻辑设计..............................................274.3代码的功能与设计原则............................................314.4输入输出设计....................................................314.4.1输入设计....................................................314.4.2输出设计....................................................324.5系统配置设计....................................................334.5.1软件配置....................................................334.5.2硬件配置....................................................335.系统实现...........................................................335.1系统环境建立.....................