摘 要
随着小超市规模的发展不断扩大，商品数量急剧增加，有关商品的各种信息量也成倍增长。超市时时刻刻都需要对商品各种信息进行统计分析。而大型的超市管理系统功能过于强大而造成操作繁琐降低了小超市的工作效率。
超市管理系统是市场上最流行的超市上常用的系统之一，它主要包含以下几个模块：系统权限的设定、原始数据录入、数据的汇总及查询等。从而，实现对进货、销售及员工信息等实现全面、动态、及时的管理。
而近几年来，零售业面对的市场竞争压力日益增加。能否拥有一套迅速灵敏、功能强大的零售市场分析系统，有针对性地制定政策，适时根据市场需要排放货物，显得越来越重要，基于“超市管理系统”其上的数据挖掘应运而生。本文只象征性的介绍了关于数据挖掘中的关联规则的初步知识，而具体数据挖掘在系统上的应用将在我同伴的论文中进行详细介绍。挖掘“超市管理系统”数据库中顾客购买不同货物的关联性，避免了脱离市场、脱离需求，盲目排放货物所造成的损失，节省了资金，提高了效益。
本文系统的分析了软件开发的背景以过程；首先介绍了软件的开发环境，其次介绍了本软件的详细设计过程：数据库的设计、各个模块的设计和实现，以及具体界面的设计和功能。
关键字：超市；管理信息系统。
Abstract
Expands unceasingly along with the small supermarket scale development, the commodity quantity sharp growth, related commodity each kind of information content also becomes time of growth. The supermarket in needs to carry on the statistical analysis all the time to commodity each kind of information. But the large-scale supermarket management system management system function too was formidable creates the operation tediously to reduce the small supermarket working efficiency.
The supermarket management system management system is in the market on the most popular supermarket one of commonly used systems, it mainly contains following several modules: System jurisdiction hypothesis, primary data input, data compiling and inquiry and so on. Thus, realizes to the inventory, the sale and the staff information and so on realizes comprehensively, dynamic, the prompt management.
In resent years，supermarket faced on the competition of market。It is more and more important to whether we own an agility and powerful analysis system upon which we can make correct policy and bring forward some sales promotion on time。So we develop a data mining system base on supermarket Management System。This paper introduce how to apply the association rule of data mining to mine how to combine the strategy，so we avoid being devoicing from market and requirement and the loss and save money and improve efficiency.
This article system analysis software has developed background by process; first introduced the software development environment, next introduced this software detailed design process: Database design, each module design and realization, as well as concrete contact surface design and function.
Key words: Supermarket; Management Information System.
2
目 录
绪 论............................................................................................................................ 1
1.1社会背景 ............................................................................................................................. 1 1.2超市背景 ............................................................................................................................. 1
第二章 系统可行性研究............................................................................................ 2
2.1 技术可行性研究 ................................................................................................................ 2 2.2 经济可行性研究 ................................................................................................................ 2 2.3 操作可行性研究 ................................................................................................................ 2
第三章 系统需求分析................................................................................................ 3 第四章 系统概要设计................................................................................................ 4
4.1 设计思想 ............................................................................................................................ 4 4.2 设计原则 ............................................................................................................................ 4 4.3 业务流程分析 .................................................................................................................... 4 4.4系统数据流分析 ................................................................................................................. 6
4.4.1超市管理系统总数据流向 ...................................................................................... 6 4.4.2进货管理子系统数据流向 ...................................................................................... 7 4.4.3销售管理子系统数据流向 ...................................................................................... 8 4.4.4人事管理子系统数据流向 ...................................................................................... 9 4.4.5库存管理子系统数据流向 ...................................................................................... 9 4.5 数据字典 .......................................................................................................................... 10 4.6 功能需求 .......................................................................................................................... 12 4.7 运行需求 .......................................................................................................................... 12
第五章 系统详细设计.............................................................................................. 12
5.1 系统功能结构图 .............................................................................................................. 12 5.2 系统功能设计 .................................................................................................................. 13 5.3 系统数据库设计 .............................................................................................................. 14 5.4模块功能设计 ................................................................................................................... 17
5.4.1. 系统登录模块 ...................................................................................................... 17 5.4.2. 进货管理模块 ...................................................................................................... 18 5.4.3. 销售管理模块 ...................................................................................................... 20 5.4.5. 超市职工管理模块 .............................................................................................. 24 5.4.6. 供货商信息管理模块 .......................................................................................... 28 5.4.7. 系统维护模块 ...................................................................................................... 30
第六章 系统测试运行.............................................................................................. 33
6.1 模块测试 .......................................................................................................................... 33 6.2 整体测试 .......................................................................................................................... 33
第七章 基于数据挖掘的超市管理系统.................................................................. 34 结 论.......................................................................................................................... 35 致 谢.......................................................................................................................... 36 参考文献...................................................................................................................... 36
3