机电制造企业管理系统中产品信息数据库设计

Database-Designing of Product Information in ERP System for Middle or Small Enterprise

本文运用数据库设计的一般理论结合机电产品组成特点。工艺流程特点和向量法,建立数据库表。最后利用游标工具和建立的临时数据库表,通过递归得到产品BOM临时表的存储过程的程序流程图。

In article, the database-design theory is applied to finish the database-design. Then data tables are built up. At last there are codes in which procedure and cursor are transferred iteratively to obtain the BOM temporary table.