毕业论文(设计)题目名称:设备管理系统设计与实现学生姓名:学号学院:专业年级:指导教师:职称讲师写作时间:2011年04月10日II设备管理系统设计与实现摘要在现代化大型企业信息化管理体系建设中,设备管理信息系统被看作是重中之重。这不仅因为设备管理的各项制度、流程涉及的点多面广,而且作为企业从生产、市场、成本、物料、人事管理到设备管理的全过程计算机管理中的最后一环,直接关系到企业在市场中的综合竞争力。本次毕业设计任务是通过开发企业设备管理系统,学习用VisualStudio2005开发基于C/S的数据库系统。采用VisualStudio2005和SQLServer等软件为开发工具。系统设计通过对设备信息采集的流程和传统管理方法进行分析,按照数据库设计原则设计出达到第三范式的的各数据表,在数据库的物理设计中采用SQLServer实现数据库的管理,完成对数据库中表的基本操作。使用VisualStudio2005开发工具,实现设备信息管理、辅助表管理、组织管理、关系转化管理、数据导入导出、数据传送、数据维护、信息查询、打印等主要功能模块。同时本系统还是用了Office办公软件,实现对各类表格信息以Word形式导出以及把Word文档中的数据导入系统中的功能。在指导老师的帮助下,已经基本上成功地实现了设计任务书的要求。使得设计的数据库系统能够实现一般数据库的管理。关键词:设备管理系统;Client/Server模式;数据库;VisualStudioIIIEquipmentManagementSystemDesignandImplementationABSTRACTInmodernizedlarge-scaleenterprise'sinformation-basedmanagementsystemconstruction,themanagementinformationsystemoftheequipmentisregardedasthemostimportantthing.Thisnotmerelybecauseeverysystem,equipmentofmanagement,pointsthatprocedureinvolvemanypiecewide,andisregardedasenterprisesfromproduction,market,cost,supplies,personnelmanagementtothelastringinthewholeprocesscomputermanagementofmanagementoftheequipment,concernthesynthesizedcompetitivenessthatenterprisesareinthemarketdirectly.Thegraduationprojecttaskmanagementsystemisthroughthedevelopmentofbusinessequipment,learntouseVisualStudio2005todevelopdatabasesystemwhichisbasedonC/S.UseVisualStudio2005andSQLServerandothersoftwareasdevelopmenttools.Systemdesignisthroughtheanalysisoftheprocessofinformationcollectiondevicesandtraditionalmanagementmethods,inaccordancewiththedesignofadatabasedesignprinciplestoachievethethirdparadigmofthevariousdatatablesinthedatabaseusedinthephysicaldesignofdatabasemanagementofSQLServertocompletethedatabasethebasicoperationofthetable.UseVisualStudio2005asdevelopmenttoolstoachievedeviceinformationmanagement,auxiliarytablemanagement,organizationmanagement,relationshiptransformationmanagement,dataimportandexport,datatransfer,datamaintenance,informationsearching,printingandothermajorfunctionalblocks.Atthesametime,thissystemalsousetheofficesoftwarewhichhashelpedtoachievefunctionslikeoutputvariousformsofexportinformationasWordandinputthedataoftheWorddocumentsintothesystem.Inguidingtheteacher'shelp,hasbeenlargelysuccessfulinachievingthedesignrequirementsofthemissionstatement.Makesthedesignofthedatabasesystemtoachievethegeneraldatabasemanagement。Keywords:EquipmentManagementSystem;C/S;Database;VisualStudioIV目录第一章绪论...................................................................................................................................11.1研究背景.................................................................................................................................11.2研究目的.................................................................................................................................11.3研究的意义............................................................................................................................2第二章系统需求分析.................................................................................................................32.1系统目标.................................................................................................................................32.2设备管理系统的背景分析.................................................................................................32.3开发设备管理系统的必要性............................................................................................3第三章系统可行性分析............................................................................................................53.1技术可行性............................................................................................................................53.2经济可行性............................................................................................................................53.3操作可行性............................................................................................................................5第四章系统总体设计.................................................................................................................74.1软件定义.................................................................................................................................74.2系统目标设计.......................................................................................................................74.3系统功能分析........................................................................................................................74.4系统组成部分.......................................................................................................................84.5设备管理系统开发环境简介.............................................................................................9第五章数据库设计...................................................................................................................115.1概念设计...............................................................................................................................115.2逻辑设计.............................................