Investigation and designing a comprehensive supply chain database for Walmart

Research Article
Open access

Investigation and designing a comprehensive supply chain database for Walmart

Jinheng Li 1* , Yilin Lin 2 , JiaXuan Ren 3
  • 1 University of Illinois at Urbana-Champaign    
  • 2 Shanghai Ocean university    
  • 3 University of Utah    
  • *corresponding author Jinheng2@illinois.edu
Published on 26 February 2024 | https://doi.org/10.54254/2755-2721/43/20230799
ACE Vol.43
ISSN (Print): 2755-273X
ISSN (Online): 2755-2721
ISBN (Print): 978-1-83558-311-1
ISBN (Online): 978-1-83558-312-8

Abstract

In light of the rapid progression of digital technology, fierce competition, and the ever-shifting demands of consumers, the contemporary retail sector is continually evolving. This underscores the critical need to embrace digital solutions. This study seeks to aid Walmart, one of the world's largest retailers, in improving supply chain efficiency, optimizing inventory management, and enhancing the overall customer experience by creating a comprehensive supply chain database. Specifically, we employ the core entity method to identify Walmart's key entity, which is the "product," and ascertain its associated entities. Subsequently, we establish relational models based on the attributes and relationships of each table, considering real-world scenarios, such as one-to-many and many-to-many relationships. We employ normalization techniques to ensure the proper utilization of functional dependencies and candidate keys for each entity. This guarantees that the designed tables adhere to the principles of the First, Second, and Third Normal Forms, preserving data integrity while minimizing redundancy. Furthermore, we create a set of logical database commands, illustrated through flowcharts, and rigorously test their functionality and efficiency. Lastly, we explore potential directions for future research. The successful implementation of this design relies on robust data management practices and a reliable database system tailored to meet Walmart's specific needs. This results in a logically structured and standardized supply chain database. The research findings underscore the vital importance of a well-conceived supply chain database in addressing the challenges faced by large-scale retail operations like Walmart supermarkets.

Keywords:

Walmart, Supply Chain Management, Database Design, Core Entity

Li,J.;Lin,Y.;Ren,J. (2024). Investigation and designing a comprehensive supply chain database for Walmart . Applied and Computational Engineering,43,8-16.
Export citation

References

[1]. Banker S 2021 Walmart’s Massive Investment In A Supply Chain Transformation Forbes

[2]. Pillai A R and Jolhe D A 2020 Market Basket Analysis: Case Study of a Supermarket. In Advances in Mechanical Engineering (pp. 727–734) Springer Singapore. https://doi.org/10.1007/978-981-15-3639-7_87

[3]. Parra X et al. 2022 Chronological evolution of the information-driven decision-making process (1950–2020). J. Knowl. Econ. DOI: 10.1007/s13132-022-00917-y

[4]. Wang T J et al 2017 Accounting For the Benefits Of Database Normalization Journal of Information Systems Education 28(1) 1-12

[5]. Machines IJCSNS International Journal of Computer Science and Network Security 21(9)

[6]. Lee M L et al 2002 Designing functional dependencies for XML. In Advances in Database Technology—EDBT 2002: 8th International Conference on Extending Database Technology Prague, Czech Republic, March 25–27, 2002 Proceedings 8 (pp. 124-141). Springer Berlin Heidelberg.

[7]. Yao H et al 2002 FD/spl I. bar/Mine: discovering functional dependencies in a database using equivalences. In 2002 IEEE International Conference on Data Mining, 2002. Proceedings. (pp. 729-732). IEEE.

[8]. Arman N 2006 Normalizer: A case tool to normalize relational database schemas.

[9]. Lucchesi C L and Osborn S L 1978 Candidate keys for relations. Journal of Computer and System Sciences, 17(2), 270-279.

[10]. Eessaar E 2016 The Database Normalization Theory and the Theory of Normalized Systems: Finding a Common Ground

Cite this article

Li,J.;Lin,Y.;Ren,J. (2024). Investigation and designing a comprehensive supply chain database for Walmart . Applied and Computational Engineering,43,8-16.

Data availability

The datasets used and/or analyzed during the current study will be available from the authors upon reasonable request.

Disclaimer/Publisher's Note

The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of EWA Publishing and/or the editor(s). EWA Publishing and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content.

About volume

Volume title: Proceedings of the 2023 International Conference on Machine Learning and Automation

ISBN：978-1-83558-311-1(Print) / 978-1-83558-312-8(Online)
Editor：Mustafa İSTANBULLU
Conference website: https://2023.confmla.org/
Conference date: 18 October 2023
Series: Applied and Computational Engineering
Volume number: Vol.43
ISSN：2755-2721(Print) / 2755-273X(Online)

© 2024 by the author(s). Licensee EWA Publishing, Oxford, UK. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license. Authors who publish this series agree to the following terms:
1. Authors retain copyright and grant the series right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this series.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the series's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this series.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See Open access policy for details).

References

[1]. Banker S 2021 Walmart’s Massive Investment In A Supply Chain Transformation Forbes

[2]. Pillai A R and Jolhe D A 2020 Market Basket Analysis: Case Study of a Supermarket. In Advances in Mechanical Engineering (pp. 727–734) Springer Singapore. https://doi.org/10.1007/978-981-15-3639-7_87

[3]. Parra X et al. 2022 Chronological evolution of the information-driven decision-making process (1950–2020). J. Knowl. Econ. DOI: 10.1007/s13132-022-00917-y

[4]. Wang T J et al 2017 Accounting For the Benefits Of Database Normalization Journal of Information Systems Education 28(1) 1-12

[5]. Machines IJCSNS International Journal of Computer Science and Network Security 21(9)

[6]. Lee M L et al 2002 Designing functional dependencies for XML. In Advances in Database Technology—EDBT 2002: 8th International Conference on Extending Database Technology Prague, Czech Republic, March 25–27, 2002 Proceedings 8 (pp. 124-141). Springer Berlin Heidelberg.

[7]. Yao H et al 2002 FD/spl I. bar/Mine: discovering functional dependencies in a database using equivalences. In 2002 IEEE International Conference on Data Mining, 2002. Proceedings. (pp. 729-732). IEEE.

[8]. Arman N 2006 Normalizer: A case tool to normalize relational database schemas.

[9]. Lucchesi C L and Osborn S L 1978 Candidate keys for relations. Journal of Computer and System Sciences, 17(2), 270-279.

[10]. Eessaar E 2016 The Database Normalization Theory and the Theory of Normalized Systems: Finding a Common Ground

For authors
Guide for authors Policies for authors Aims and scope Subscription Open access policy
For editors
Policies for editors Editorial board
For reviewers
Policies for reviewers Privacy policy

Cookies are used by this site.
Copyright © 2024 EWA Publishing, its licensors, and contributors. All rights reserved, including text and data mining, AI training, and similar technologies.