Download pdf
Investigation related to database design for letter of credit
- 1 Shenzhen University
* Author to whom correspondence should be addressed.
Abstract
The "Letter of Credit" is a fundamental payment mechanism in global trade, and its efficiency has significantly declined due to the impact of the COVID-19 pandemic. This document delves deeply into the development and execution of a comprehensive database for managing Letters of Credit (L/Cs). It is designed with a real-world case study derived from the International Settlement Department of the Bank of China. The central goal of this database is to enhance the efficient management and simplification of the complex procedures inherent in L/C transactions. The development process follows a systematic approach, commencing with the establishment of three fundamental assumptions to delineate the scope of the study. Subsequently, the database design progresses through stages involving Entity-Relationship Diagram (ERD) development, relational model construction, and normalization procedures. These steps collectively culminate in the creation of an intelligently structured database comprising thirteen distinct tables. In conclusion, this paper not only delves into the design and implementation of the L/C database but also showcases its practicality through real-world scenarios. The database, fueled by meticulous design and thoughtful implementation, is poised to revolutionize the management of L/C operations, offering enhanced efficiency and accuracy in international trade transactions.
Keywords
Letter of Credit, Database Design, SQL
[1]. Jiang Q 2017 The internal logic of issuing letters of credit (China Foreign Exchange 20 3)(In Chinese).
[2]. Pan H J 2023 The Future Development of Electronicization of Letter of Credit Documents (In Chinese) China Foreign Exchange (04) p 56-57
[3]. Pan H J Li W L and Wang L Y 2023 Exploration of Letter of Credit Presentation Modes in the Era of Pandemic (In Chinese) China Foreign Exchange (06) p 56-57
[4]. Yang S 2010 Exploring the Development Issues of Domestic Letters of Credit in China: A Ten-Year Perspective on Domestic Letter of Credit Business from the Bank of China (In Chinese) Modern Busines (2) p 37-36
[5]. Types of Letters of Credit 2006 Chinese Rural and Township Enterprises (08) p 28 (In Chinese)
[6]. Meng Y 2012 Study on the transformation between ER model and relational model (In Chinese) Journal of Information Engineering University 13(001) p 124-128
[7]. Wang Y Z 2022 Design of Library Information Management System Based on MySQL (In Chinese) Computer Programming Skills and Maintenance (01) p 93-95+116
[8]. Sun Y 2023 Research on Redundant Information Resolution in Cloud Computing Environments (In Chinese) Yangtze River Information Communication 7 p 91-94
[9]. E-Learning and Digital Media 2020 Volume 17 Issue 3 PP 199-217
[10]. Cai H Guo Z and Xiao H 2018 Exploration of Application Scenarios for Blockchain + Domestic Letter of Credit (In Chinese) Financial Electronics (04) p 72-74
Cite this article
Guo,Y. (2024). Investigation related to database design for letter of credit . Applied and Computational Engineering,43,17-25.
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
© 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).