毕业设计（论文）-店药物管理系统.docVIP

装 装 订 线 河北大学工商学院2008级本科生课程设计论文 药店药物管理系统 摘　要 如今，科学技术飞速发展，电脑基本上已经进入家家户户，生活中好多问题都有了电脑的帮助，但小型药店药品管理仍是人工管理，信息处理时工作量大、容易出现错误，针对这一情况，我设计了药店药品管理系统，用以提高人们买药时的效率，减小药店工作人员的工作量，提高管理水平。它包括药店药品的购进管理、药品的出售管理、药品的存储管理等几大功能模块，并提供了对各个功能模块的查询、更新、统计等功能。以上这几种功能基本上是通过存储过程来实现的。 该系统开发由系统需求分析阶段（设计出该药店药品管理系统的业务流程图、各阶层的数据流图和数据字典）、概念设计阶段（设计分E-R图，生成全局E-R图）、逻辑设计阶段（将E-R模型转换为关系模型、模型优化）、数据库实施阶段（数据的载入、应用程序的编码和调试）、系统调试和测试阶段等阶段组成。它的实现是通过SQL SERVER 2000这一软件来实现的。 关键词：药物；购进药物；药物出售；药物存储；关系数据库  Pharmacy Drugs Management System ABSTRACT Today, the rapid development of science and technology, computer basically has entered into every family, life a lot of problems with the help of computer, but small pharmacy drugs management is still artificial management, information processing work, and prone to errors, in view of this situation, and I designed a pharmacy drugs management system, in order to improve the efficiency of the people to buy medicine, reduce the enterprise staff work and enhance the level of management. It includes a pharmacy drug buys the sale of the drug management, management, drug store management and so on several big function module, and provide the modules of the inquiry, update, statistics, and other functions. This function is basically through several storage process. The system developed by system demand analysis stage (design the pharmacy drugs management system business flow chart, all sectors of the data flow graph and data dictionary), concept design phase (design points e-r chart, generate global e-r chart), logic design stage (will e-r model transformation for relation model, model optimization), database implementation stage (data load, the applications code and commissioning), system commissioning and testing phase of stage. It is through the realization of the SQL SERVER 2000 this software to realize. Key words: drugs; Purchase drugs; Drug sells; Drug storage; Relational database 目　录 TOC \o 1-3 \h \z \u HYPERLINK file:///G:\\张晶\\目%20%20录.doc \l _Toc295329650#_Toc295329