Supply, Sales and Inventory Management System Based Java and SQL Server

Qinghao Kong, Jirui Hu, Hao Xu

Abstract


The development of the inventory management system mainly includes the establishment and maintenance of the database and the development of the Java. The purpose is to facilitate the store operators to input and modify the data of incoming and outgoing merchandise, customers and suppliers, easy and fast incoming and outgoing merchandise data search, complete incoming and outgoing merchandise receipt and payment fund management, and flexible incoming and outgoing merchandise inventory statistics. This paper presents the detailed design of this management system, with particular emphasis on the database part of the design, including requirement analysis, conceptual structure design, logical structure design, physical structure design, etc., and detailed testing of the system's functions.

Keywords


Supply; Sales and Inventory Management System; Java; SQL Server

Full Text:

PDF

Included Database


References


Zhe Li,and Houhua Shen."Database Design on Teaching Management System Based on SQL Server".Proceedings of 2015 3rd International Conference on Education, Management, Arts, Economics and Social Science (ICEMAESS 2015). Ed. Atlantis Press, 2015, 1127-1131.

Ting Ting Lu. "The Library Information Management System Analysis and Design". Applied Mechanics and Materials 3360(2014): 2198-2201.

Ghlala Riadh. Analytic SQL in SQL Server 2014/2016. Hoboken, NJ, USA: John Wiley & Sons, Inc.,John Wiley & Sons, Inc.,2019.

Fan Jin Zeng and Hui Li and Li Ding. "Database Design of Merchandise Management System Based on SQL Server". Applied Mechanics and Materials 2617(2013): 4728-4731.

Costel Gabriel CORLATAN et al. "Query Optimization Techniques in Microsoft SQL Server". Database Systems Journal V.2(2014): 33-48.




DOI: https://doi.org/10.18686/esta.v8i4.199

Refbacks

  • There are currently no refbacks.


Copyright (c) 2021 Qinghao Kong

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.