Design of management database for Mihiyo company

Abstract

The mihoyo Sales Management System was developed to adjust to the dynamic business environment and maintain a competitive edge. In the context of this era, the mihoyo Sales Management System utilizes a robust database structure to optimize sales operations. In this paper, a management database for Mihiyo company is designed. The customer module stores customer information, linked to orders, payments, and expenses. An order table tracks order details, linked to customers and products. Payment and shipment tables manage transaction and delivery information. The inventory table enables real-time monitoring of stock levels. Financial management tables record sales, payment, and expense data. User tables store information related to different user roles. The system's interface seamlessly interacts with the database, allowing users to access and update information efficiently. The reporting and analytics module analyzes data from the database, facilitating decision-making and performance evaluation. Database testing requires completing relevant test cases and achieving a robust system.