Design and Implementation of Supermarket Management System Based on Database

In the process of operation, supermarkets are characterized by frequent supply and delivery, a large amount of order data, and frequent staff turnover, but the data generated needs to be managed uniformly. Manual management of these complex data has not adapted to the trend of the development, the realization of standardized data, and automatic management process has gradually become the requirements of the supermarkets that can better manage their business. The supermarket management information system realizes the classification of goods, the recording of suppliers and consumers, the recording of a large number of the order information, and their distribution information. Through the analysis of orders, it promotes the decision-making of supermarket management and sales. At the same time, the supermarket management system also greatly reduces the workload of supermarket order administrators, who can simply query the order information they want to view. In addition, this supermarket management information system also realized the supermarket staff management function, employee administrators can easily complete the supermarket staff information increase, delete, modify, and view tasks. This system is very convenient for managing, inputting, outputting, and finding the data to make the supermarket data specific, visualizations, and rationalization. As for the background database, this system uses Oracle. In the aspect of the software, various configurations in computers including input and output capacity, internal memory, and external memory capacity can meet the requirements of users.

I. Introduction

With the progress of the times, people have applied science and technology to all aspects of life. In this information age, it has become normal to store and manage data in the form of electronic technology. Machines are much more efficient and accurate than manual ones, and it is much safer to store data on computers than to write on paper. The supermarket is an indispensable part of this society. As a bridge between production and consumption, it has a large amount of data to process every day. Under such circumstances, it is particularly important to establish an efficient management system combined with computers. It can not only improve the operation efficiency of supermarkets and allow customers to enjoy more convenient services but also achieve extremely high economic benefits, which is beneficial to promoting economic development. At present, the modernization and upgrading of supermarket management systems are underway. Although most enterprises are trying to digitize information, there are still many problems that need to be solved. Based on building an efficient supermarket data management system, this paper designed this supermarket management system to improve the existing systems.