Abstract
In d on the main supermarket management, including stock management, cashier management, inventory management and staff management 4 aspects. System can be completed on the various types of information here, query, add, delete, modify functions. System is the core of marketing, inventory management and receiving for the links between, each table will be linked to amend the impact of other forms Upon the completionthe information age today, the effectiveness of the computer is already known, particularly in the supermarket cash register system is inseparable from the computer, the system complete of the sale or purchase operation, the system will automatically complete the corresponding information changes. Query system is the core of the system based mainly in the number and title of goods, such as query, the purpose is to facilitate users, in order to find faster to the various materials and the basic product quality information. System integrity of the users to add, delete and modify password function, the system used in Microsoft Office Access 2000 to design databases, and use the current good development tools - VB 6.0, it has the most flexible structure of the database, the database applications are good support. This paper introduces the topic of development background, to be completed by the function and development of the process. Focus on the design of the system the focus of design ideas, technical difficulties and solutions.
Key words: Supermarket Management Information System
Chapter 1: Introduction
1.1 social background
resources翻译With modern science and technology in the rapid development of computer technology has infiltrated brother areas, as an essential tool for all sectors, in particular the promotion of Internet technology and the establishment of the information superhighway, so that the IT industry more competitive in the market showed its unique advantages, entered the era of information, and has a huge waiting for the data processing and transmission, which makes the database on the further development and use of it is particularly urgent.
Some of the domestic market as small and medium-sized supermarkets, and their information in the course of the pace to lag behind the large and medium-sized supermarkets, and for these enterprises resource management, storage and processing of information was also an urgent need to adapt to the market competition, it needs to be efficient handling and management methods, and speed up the information supermarkets will be able to process less.
Attachment period, we have adopted in the market survey, for the small and medium-sized supermarkets now on the business and personnel management of the actual needs of the development of this supermarket management system. In the development process, we focused on the current management of the supermarket characteristics and the actual level of technical staff, based on the Windows graphical user interface easy to learn and use of this operating environment, in the system design process, we as a people easy accessibility Machine Interface, allowing users to fully grasp in the short term. We also always give top priority to the accuracy of the system, data integrity and to deal with the validity. On the basis of this optimization code, to speed up the system operation and reduce the system resources of the occupier.
1.2 supermarket background
Supermarkets in China formed in the 20th century, the early 1990s, China has now become an important form of the retail industry for the development of the national economy has p layed an important role. With the high-speed development of supermarkets, its management has become increasingly complex, early in the form of salespersons Zhanguisi already unable to meet existing sales development, and that the urgent need to introduce new management techniques.
Supermarket patterns provide a number of advantages, but in the current situation, it still exists retail companies have been behind the side, such as: You can not effectively manage every commodity, clearing receivables slow, error prone business, it is not appropriate for commodity price adjustment , inventory and low efficiency, but also in day-to-day management of supermarket goods the import and sales of such decision-making to experience mainly, the lack of real-time analysis capabilities, management personnel, the timely transmission of information are not always meet the requirements. Su Che supermarket forms of high-speed development, and its management has become increasingly complex, the need to deal with the day-to-day data also gradually increasing, commercial operation of the intermediate links more and more, the original artificial management has been unable to cope with this complex market . Therefore, in the choice process, I chose the topic of supermarket management system design, relying on the modernization of the computer information processing technology to manage the supermarket, thus saving a large amount of manpower, resources, and improve the working conditions of staff, reduce the labor intensity, Commodities and quickly reflect the import and sales of all kinds of situations, such as the feedback information and analysis so that the management staff of the rapid market changes to make the corresponding decisions, speed up the supermarket business management efficiency. In the information age today, the effectiveness of the computer is already known, particularly in the supermarket cash register system is inseparable from the computer,
the system completed on the main supermarket management, including stock management, cashier management, inventory management and staff management 4 aspects. System can be completed on the various types of information here, query, add, delete, modify functions. System is the core of marketing, inventory management and receiving for the links between, each table will be linked to amend the impact of other forms Upon the completion of the sale or purchase operation, the system will automatically complete the corresponding information changes. Query system is the core of the system based mainly in the number and title of goods, such as query, the purpose is to facilitate users, in order to find faster to the various materials and the basic product quality information. System integrity of the users to add, delete and modify password function, the system used in Microsoft Office Access 2000 to design databases, and use the current good development tools - VB 6.0, it has the most flexible structure of the database, the database applications are good support. This paper introduces the topic of development background, to be completed by the function and development of the process. Focus on the design of the system the focus of design ideas, technical difficulties and solutions.
Commodity Management of the system against the scope of business and job characteristics, design of the stock management, stock enquiries, sales management, sales enquiries, inventory management
and system maintenance six subsystems, six subsystems including the management of major commodities business, the full realization of the purchase of goods, payment, sales, receivables, and inventory management of the computer business, greatly reduce the workload of the staff of shops, and comprehensively improve the management efficiency of the management of goods as well as service quality, and level of the commodity management Business soars to a new level in accordance with the needs of modern commodity management and development, and easy to operate and aesthetically pleasing interface to the user save a lot of valuable time, the full realization of the purchase of goods, payment, sales, receivables and inventory statistics, the computer management business, greatly reduce the workload of the staff of shops, stores and comprehensively enhance the efficiency and service quality management. Supermarkets need to deal with a lot of inventory information, but also always updating product sales information, adding commodity information. Faced with different types of information, the need to rationalize the
database structure to preserve data, the need for effective program structure to support the implementation of various data manipulation. Store automation of product management in Europe and the United States and other countries have already been realized, is the basis of retail management. It can be the most important feature of real-time and accurate control of the shop sales. If we can grasp i
n real time the sales process and sales, can be effective in speeding up the turnover of goods and improve service quality and reduce product prices, such as inconsistent with the problems that have occurred. Customer requirements of the consumer is shopping in the supermarket in the hope that basically can be bought for commodities, but also to ensure that the quality of goods but also enjoy high-quality, convenient service.
Chapter II :feasibility study
2.1 The technical feasibility study
In the IT industry in the employment of staff generally require mastering computer technology, hardware and software has some basis, the use of management software will be familiar with IT products. This is because some of the supermarket staff relatively high quality requirements, from the management to the sales staff below, requires a certain degree of basic computer, the new system put into use, as long as a small number of staff to conduct the training, the function of the system and Basically, the use of the system can run smoothly.
2.2 economic feasibility study
Because sales information through the network transmission distance can be exempted from the restrictions, it can borrow a lot of human and material resources, and facilitate management, which can reduce unnecessary expenditures, while the system can improve the efficiency of supermarket sales, which increased the economic Supermarket benefits, and so on the economy is feasible. (1) supermarket afford systems development costs
Development of the new system is a complex task spacing, it is mainly the investment of human and material investment. For the developers of the system, its major investment in human and material resources or two. If it is our own development system for the staff, or its major investment in human resources, from the investigation to the business needs of the coding system are produced enormous human needs investment. Software enterprises as a short high-tech industries and their employees than general corporate requirements of the request must be high, and the development of the system and more understanding of the software industry, in a self-management system developed in the course of our own relatively easy manpower, Such enterprises will be able to borrow most of the additional expenditure. At the same time on other software products, a high-end industry, whether it is the price or quality of products with relatively high, and the operator product distributors or businesses are required to have strong financial support. Therefore, in the system development process, enterprises are able to assume full development costs.
(2) new enterprise system will bring economic benefits
Is a management system of information, intelligence and advanced management concept of aggregation. The management is a dynamic process, in the course of its operation a number of measures to be taken. Therefore, in the management of access to comprehensive benefits is a cost-effective, it must engage in direct quantitative analysis is more difficult. General the economic benefits of the new system are outlined, the most important is to reduce the performance of enterprise management costs and manpower expenditure. And other food through cumbersome new system to be analysed solution not only saves a great deal of time, but also the decision-making enterprises has provided valuable information for enterprises bring enormous economic benefits. 2.3 operating feasibility study
The system uses a Windows-based graphical user interface, and the system is the operating system we are familiar with, for those who have general computer knowledge can be easy-to-use staff. Supermarkets and the entire management system by the most friendly interface, brief and clear, no need to conduct an in-depth understanding of the database.
Thus, the operation of the system is feasible, it is necessary to develop the system.
Based on the above three areas, the system has a high feasibility of the development, whether it is technically or economically or operationally. Therefore, we can design the system data flow diagram, establish a data dictionary.
Chapter III: system needs analysis
3.1 users workflow
Purchase or sale of goods, the user must Jinhuochan or sale of single-check review and registration; users to obtain purchase, sales, inventory information, it is necessary to the purchase, sales, inventory query and print.
3.2 users business needs
(1) the inventory management software will be tea for management and statistical information, products and product sales Jinhuochan a single input management and statistics;
(2)The management software will be depending on the user's need to purchase, sales, inventory query, and print detailed information;
(3)The management software will provide users with account management tools so that users on the account management, for specific users add, delete users, modify user passwords;
(4)The management software provides enterprise management, enterprise employees can be classified management and the addition of new employees, as well as employees to delete, modify the information into functional.
Chapter IV: detailed design
4.1 Design thinking: (1). System is divided into several relatively independent modules, but these modules to centralized management. (2). Hierarchical modular design thinking process, the entire system is modular in design agencies. Application procedures are as strong operational and scalability. (3). Reasonable data flow design, in the design of applications, relatively independent of the data flow between modules interconnected so that the coupling between modules and lower for the system's operation and improve the security of the system.
4.2. Design principles: In order to make the system fully functional comprehensive, easy to operate, the maximum improve software quality, and to meet the practical needs of users in the design and development process followed, as the following principles:
1), the principle of legality: accounting products based on the work requirements as well as system requirements, in the light of the actual accounting work conducted by the goods such as product, sales and other work.
2); practical principles: product information management for the actual needs, and be able to deal with some special circumstances require, in addition, as far as possible, set aside space for expansion capabilities.
3); accuracy principles: on the importation of relevant information to establish mechanisms seized the wrong time error, allowing users to input timely and accurate legal information (such as matching type, length not exceeding limits, etc.).
4); easy operating principles: to demand the complete system design, friendly interface, easy to operate, suggested that the necessary places.
5); source readability principles: In order to facilitate other design, maintenance personnel understand the code or modify the code after software upgrade maintenance, can be both good code Notes work.
6) optimization principles: In order to achieve the purpose of optimizing and reasonable use of window
s, menus, objects of succession, since the user-defined objects, events, function, reduce unnecessary repetition code, the procedure simplicity, ease of the future maintenance. 7); safety of principle: the system administrator can set up a landing password, password privilege. After the previous design of the whole system we have a preliminary understanding of the various modules and functional differentiation.
Requirements Analysis
1, the system functional analysis
1) the maintenance of basic information
Type the establishment and maintenance, including new types of goods, modification and deletion. Basic information management products: basic commodities including the new information, modification and deletion.
Supplier of information management include: suppliers of new information, modification and deletion.
Administrators information management: the system administrator add, delete and modify password.
2) stock management
Information Management bought goods: commodities stock information including commodity purchase quantity, unit price, suppliers, etc.. Goods bought stock management functions complete registration information, modification and deletion.
Categories Show: According to the merchandise can be a commodity type to view the stock situation.
Inventory update: stock information directly related to changes in inventory changes.
Stock analysis: the current stock list of the largest previous purchase of goods and at least the first several commodities.
Inventory: Inventory list of the current top number of goods and inventory for at least the first several commodities.
3) Sales Management
Marketing information management: marketing information including marketing quantity, unit price, statistics and dates. Merchandising sales information management capabilities registration, modify, and delete.
Categories Show: According to the merchandise can see a certain type of merchandise sales. Update Inventory: sales information directly related to changes in inventory changes.
Sales Analysis: lists the most current sales and sales of goods before at least several of the previous commodity.
4) reported loss management
Information management products reported loss: loss of information on goods, including goods at the number of loss, such as the reasons for reported losses. Commodities reported loss management functions complete registration information reported loss, modification and deletion.
Categories Show: According to the merchandise can be a commodity type to view the reported loss situation.
Update Inventory: loss reported the same information directly related to changes in inventory changes.
Reported loss analysis: the current list at the top loss of several commodities and reported the loss
发表评论