Design and Implementation of Supermarket Management System Based on Database
Yunqi Li, Yuanlu Nie · 2022
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.