Claim Missing Document
Check
Articles

Found 1 Documents
Search

Relational Database Model Design for Logistics and Shipment Tracking Systems Erza Hanif Pramudita Hanggara; Ezekiel Besarianta Prabaswara Sitorus; Aditya Wahyu Wiranatha; Fathan Rafif Ryansyah; Raditya Ramadhan Eka Widhianto; Diva Kurnianingtyas
Journal of Technology and Informatics (JoTI) Vol. 8 No. 2 (2026): Vol. 8 N. 2 (2026)
Publisher : Universitas Dinamika

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37802/

Abstract

Efficient and reliable shipment tracking is essential for modern logistics, where managing large volumes of real-time transportation data remains a significant challenge. This study proposes a normalized relational database model to support structured logistics data management and shipment tracking using Entity Relationship Diagrams (ERDs) and Structured Query Language (SQL). The methodology involved analyzing a Transportation and Logistics dataset comprising 6,880 records and 32 attributes, identifying entity relationships, and applying normalization up to the Third Normal Form (3NF). The resulting database was implemented in Microsoft SQL Server and evaluated using simulated datasets containing 10,000, 100,000, and 1 million records. Experimental results demonstrated that complex queries could be executed in approximately 6 seconds for 1 million records. Furthermore, integrating a dedicated GPS_Ping table provides a structured mechanism for storing time-stamped shipment location observations, supporting location-based tracking data management. The proposed model reduces data redundancy, strengthens relational data integrity, and supports scalable query processing. These findings demonstrate the potential of a normalized relational database architecture as a foundation for developing scalable logistics information systems and reliable shipment tracking applications