辅料管理系统分析与设计

摘要

随着现代工业的发展，计算机信息管理系统越来越受到企业重视。辅料管理作为信息管理系统的重要组成部分也逐步被人们所重视。在本设计中主要分析了辅料库存管理系统的一些基本功能和需求情况，对系统的需求分析、可行性分析，功能描述、功能分析以及数据库设计等，重点对应用程序的分析设计作了重点介绍。同时对SQL server做出了简单的描述，并设计了该系统所需要的8类表格。该系统完成后将具备如下功能：辅料各种信息的输入，包括入库，出库，还原，需求信息的输入等。以及辅料管理的各种信息查询，修改和维护，设备采购报表的生成，在辅料仓库管理中加入最高储备和最低储备字段，对辅料的物质设备实现监控和报警，企业各个部门的物质需求管理，操作日志的管理，辅料管理系统的使用帮助。

本系统的以上功能会更适合辅料管理的发展情况，将会给辅料管理带来一种更为科学的服务系统，是辅料管理自动化的一面新窗口。也将会是辅料管理员的好帮手。

关键词：辅料管理；系统设计；SQL server

Abstract

With the development of modern industry, computer information management system by more and more enterprises pay attention to. Materials management as a management information system of the important composition department also gradually taken seriously

by people place. This paper mainly analyses the accessories inventory management system of some of the basic function and composition, including the system requirement analysis, system structure, function module partition and database model analysis, focusing on the application's analysis and design are introduced. To the consistency of the data and safety, and the application program function complete, in line with the inventory management system as the typical information management system (MIS) requirements. Also simply introduced SQL database management system of basic function characteristics, this system will have the following function after the completion of the information of all kinds of materials: input, including warehousing, outbound, reduction, demand information input, etc. All of the information management and accessories, modify and maintenance, query the generation of equipment procurement statements in warehouse management, materials to the highest and lowest reserve fields, reserves of accessories material equipment realize monitoring and alarm, enterprise each department's material needs management, operation management, materials of log management system used to help.

The system will be more suitable for the above functions of the management of complementary makings, will give materials management with a more scientific service system, automatic management side of complementary makings is new window. Will also is the good assistant materials.

Key words: materials management; System design; SQL server

目录

摘要........................................................................................................................................... I Abstract ...................................................................................................................................... I I 第1章绪论 (1)

1.1 辅料管理系统 (1)

1.2 国内外现状与发展趋势 (2)

1.3 辅料管理系统研究背景与意义 (3)

第2章辅料管理系统分析 (4)

2.1 企业概述 (4)

2.2系统需求分析和可行性 (4)

2.2.1企业需求分析 (4)

2.2.2系统可行性分析 (4)

2.3 系统业务流程分析 (5)

2.4系统数据流程分析 (6)

第3章辅料管理系统设计 (8)

3.1系统功能设计 (8)

3.1.1基本信息管理 (8)

3.1.2辅料信息管理 (8)

3.1.3辅料仓库操作管理 (8)

3.1.4仓库警示管理 (9)

3.1.5 统计查询管理功能 (9)

3.2 数据库设计 (9)

3.2.1 SQL基础介绍 (9)

3.2.2数据表的设计 (10)

3.3 主页面设计 (14)

3.4 基本信息设计 (14)

3.4.1 供应商设计 (15)

3.4.2 辅料仓库设计 (16)

3.4.3用户设计 (16)

3.5系统主程序流程设计 (17)

结论 (19)

致谢 (20)

参考文献 (21)