基于Oracle的仓库管理数据库系统设计的开发与实现.docVIP

北京邮电大学世纪学院 毕业设计(论文) 题 目 基于Oracle的仓库管理 数据库系统设计 学 号 学生姓名 专业名称 所在系（院） 指导教师 2012年 5 月 30 日 题目 基于Oracle的仓库管理数据库系统设计 摘要 随着现代企业的发展，计算机信息管理系统越来越受到重视。本文简要介绍了SQL语言以及Oracle数据库系统的特点，并详细阐述了仓库管理数据库系统的设计方法。通过Power Designer建立概念结构模型，生成SQL脚本，最终建成数据库。主要包括数据库系统需求分析、概念结构设计、逻辑结构设计以及物理结构设计，最终模拟建立数据库。通过本系统的建立，可使企业的仓库管理更加正规化、科学化，以及方便快捷的实现仓库物资的入库、出库和采购等事项的管理功能。因此，本系统的开发有其特有的技术意义和管理意义。 关键词 Power Designer Oracle 仓库管理 Title Design Of Store Management Database System Based On Oracle Abstract With the development of modern industry, the information management system of the computer is paid more and more attention by enterprise. This article briefly describes the characteristics of the SQL language and Oracle database systems, and elaborated on the design of the warehouse management database system: First, establish the conceptual structure model and physical structure model with Power Designer, then generate the SQL script through the PDM model, finally build the database system. Including system needs analysis of the system, conceptual structure design, the logical structure design and physical structure design, eventually establish a simulation of database system. Using a computer to control information of the warehouse which has advantages that artificial management that can’t catch up with. It is quickly inspectional, easy to search, the credibility is high, and deposit capacities is high, confidentiality good, and also reduce more manpower and material resource. All of this managements can infinitely raise the management efficiency of goods stock and also is a scientific and regular turn, and be in line with world of important condition of the storage management. Therefore, developing a storage management system is necessary. It has its unique technology a