Fresh Products Application Information Management System

Abstract

There has been a pronounced increase in online shopping since the start of the COVID-19 pandemic. Online supermarkets are one of the critical topics of research today. Today there is a wide range of online supermarket apps available nationally and internationally, and good progress has been made in transporting goods. However, there are still research gaps in managing food waste and fresh produce. Therefore, the research theme of this paper is to establish an information management system for a new production software. The methodology of this paper is as follows: firstly, the author analyses the functional requirements of the system, secondly the structural framework of the system is designed based on the requirements analysis, then the ER diagram is completed based on the understood data requirements, processing requirements, security and integrity requirements of the users and administrators, the database is created, tables are created, data is inserted, and finally the desired query functions are achieved through MySQL. Finally, the web design for the background management of product additions, user registration accounts, and login accounts was conducted by compiling HTML and CSS in VScode software. This paper has achieved the target query function. However, the query database steps are still slightly complicated, not convenient and fast enough, and the operational requirements of the administrator are also relatively high.