Abstract
With the development of society, the constant expansion of supermarkets, the increasing number of goods, the information of these goods also increased rapidly, so how to manage the various commodities is particularly important. This study focuses on small supermarket merchandising management. It has five major modules: 1. System management module, used to set permissions on the user management, to distinguish different users and different duties of management rights; 2. Front sales management module, function is to manage the records of retail goods, shifts of the retail staff management, switch management rights, etc.; 3. Inventory data input module, mainly to make storage register after the purchase of goods, and make other information input; 4. Inventory management module, which is mainly to manage inventory data, such as sales data, purchase data, return data, scrap outdated data, existing inventory data, etc.; 5. Statistical report module, which is mainly manage statistical data on retail sales and show reports.
This study adopt the traditional waterfall model (top-down design) to process the structure design to the system, and Systematically analyzed the background and process of software development; First Analyzing the feasibility of the system, software development environment, then introduce the detailed design process of this software, include database design, each module design, the specific interface design and function to achieve. The system developed in windows XP platform, using SQL Server2000 as the background database, and combine the object-oriented programming language Visual Basic to achieve the functions of different modules.
Keyword: goods；sales; storage; inventory; waterfall model
