露天矿库存管理系统中的数据库设计

在露天矿综合管理系统中，库存管理是一个重要环节，采购存储成本占矿山流动成本的15％～20％。所以露天矿物料及设备存储的管理优化是露天采矿优化中的重点。露天矿山仓储管理的现代化是实现矿山企业管理现代化的重要一环。在其数据库应用系统的设计中，数据库的结构设计是应用系统的基础。以库存管理系统的数据库设计为例，讨论了数据库的设计方法和技术，通过需求分析、概念结构设计、逻辑结构设计等方面阐述了库存管理系统数据库设计的全过程。

Design of Open-pit Mine Inventory Management System Database

In the integrated management system of the open-pit mine,inventory management is an important link,purchase memory cost ac-count for 15%～20% of mine current costs. Therefore,open-pit mine of materials and equipment storage management optimization is the fo-cus of optimization of open-cast mining. Open pit mine warehouse management modernization is an important part to achieve the modernization of mining enterprises. In the design of database applying system,database structure design is the basis of application systems. For example, take the database design of inventory management system ,the article discusses the database design methods and techniques,through the needs analysis,concept database design,logical database design,the whole process of database design is described.