小型超市库存管理系统分析与设计

1小型超市库存管理系统分析与设计摘要企业信息化的快速发展和库存管理信息系统的建立与完善为我国零售超市的发展带了前所未有的机遇。库存管理系统作为企业信息化发展的一个缩影，得到了越来越多的中小超市的关注。当下，小型超市落后的库存管理方式带来的弊病正逐渐显现，畅销商品的短缺货现象和滞销商品的积压问题成为影响小型超市的资金利用率，也是快速响应市场的关键。基于此，本文在研究小型超市库存管理系统的基础上，通过对小型超市库存管理主要业务流程的剖析和小型超市库存管理系统出库、入库、盘点模块的系统设计，依托管理信息系统来改善小型超市的库存管理问题，以信息化库存管理的方式增加小型超市的市场竞争力和可持续发展水平。关键字：小型超市，库存管理，管理信息系统2SmallSupermarketInventoryManagementSystemAnalysisandDesignABSTRACTTherapiddevelopmentofenterpriseinformationandtheestablishmentofinventorymanagementinformationsystemhavebeenbroughtanunprecedentedopportunityforChina'sretailsupermarket.asamicrocosmofthedevelopmentofenterpriseinformationinventorymanagementsystemhasbeenattractedsmallsupermarketsconcern.Now,theshortcomingsofinventorymanagementmethodsbehindaregraduallyemerging,thephenomenonofoutofthegoodsandbacklogofunmarketablegoodsisaffectingsmallsupermarketutilizationoffunds,fastresponsemarkets.Basedonthis,throughresearchoninventorymanagementsystemandsmallsupermarketmajorbusinessprocessanalysis,smallsupermarketinventorymanagementsystemmainmodulesdesign,relyingmanagementinformationsystemstoimproveinventorymanagementproblemforsmallbusinesses,bywayofinventorymanagementinformationtoincreasethemarketcompetitivenessofsmallsupermarketlevelandsustainabledevelopment.Keywords:SmallSupermarket，InventoryManagement，InventoryManagementSystem3目录1引言..............................................................................................................................................41.1研究背景............................................................................................................................41.2研究内容............................................................................................................................41.3研究意义............................................................................................................................42小型超市库存管理系统与数据库概述.......................................................................................52.1基本含义............................................................................................................................52.2系统设计的可行性分析....................................................................................................52.2.1技术可行性分析.....................................................................................................52.2.2经济可行性分析.....................................................................................................52.2.3管理可行性分析.....................................................................................................52.3系统设计的目标................................................................................................................52.4数据库的基本概述............................................................................................................62.4.1数据库的概述……………………………………………………………………………………………………63小型超市库存管理系统业务流程分析.......................................................................................73.1主要业务流程分析............................................................................................................73.1.1商品采购流程分析.................................................................................................73.1.2商品入库流程分析.................................................................................................83.1.3商品出库流程分析.................................................................................................93.1.4库存盘点流程分析.................................................................................................93.2数据流分析......................................................................................................................103.2.1商品信息数据流...................................................................................................103.2.2系统顶层数据流...................................................................................................114小型超市库存管理系统设计.....................................................................................................124.1系统功能需求与模块化设计..........................................................................................124.2系统基本模块设计..........................................................................................................134.2.1用户系统信息管理模块设计...............................................................................134.2.2商品基本信息管理模块设计...............................................................................144.2.3销售管理信息管理模块设计...............................................................................154.2.4进退货信息管理模块设计...................................................................................154.2.5库存盘点信息管理模块设计...............................................................................174.2.6查询统计管理模块设计.......................................................................................174.2.7安全库存信息管理模块设计................................................................................184.2.8用户界面的设计......................................................................................