综合项目企业仓库管理系统（Integrated enterprise warehouse management system）.doc

综合项目企业仓库管理系统（Integrated enterprise warehouse management system） This article from the love bar 2012 contribution DOC documents may experience poor browsing on the WAP side. It is recommended that you first select TXT, or download the source file to the local view. Integrated project -- enterprise warehouse management system integrated project -- enterprise warehouse management system project -- Part 1 problem description An enterprise to realize the modernization of management to develop a set of warehouse management system, to achieve the following functions: 1, registration materials (in each material before the details of 2), material inventory information registration, registration information storage materials 3, 4 material from the registration information 5, warehouse information registration is required to design database of warehouse management system and realize the database stored in the D:\project directory under the file growth rate of 20%. The second part, environmental requirements Development tools: SQL, Server2000, enterprise edition, PowerDesigner The third part is the problem analysis Material information sheet material Column names Material_no, Material_name, Material_xh, Material_manufacture, Product_dw, Material_price The data types are Varchar (6), Varchar (20), Varchar (6), Varchar (20), Varchar (8), Money Can you empty Not null NOT null null Null Not null Null? The material number (primary key) is automatically generated, and the material name, model specification, manufacturer unit (meter, single, and only) reference price (default 0) is modified Material inventory information sheet Material_kc Column name Material_id Kc_balance Data type Varchar (6) float Can you empty Not Null Null? Specifies the initial balance of the material number (primary key, foreign key) Kc_amout, Kc_pc, Kc_pcyk, Kc_pctime, Stor_no, Amout_onload Float, float, float, Datetime, Varchar (2) float Null, Null, Null, Null, Not, null, Null The number of existing inventory