Journal of Technology and Informatics (JoTI)
Vol. 8 No. 2 (2026): Vol. 8 N. 2 (2026)

Relational Database Model Design for Logistics and Shipment Tracking Systems

Erza Hanif Pramudita Hanggara (Brawijaya University)
Ezekiel Besarianta Prabaswara Sitorus (Brawijaya University)
Aditya Wahyu Wiranatha (Brawijaya University)
Fathan Rafif Ryansyah (Brawijaya University)
Raditya Ramadhan Eka Widhianto (Brawijaya University)
Diva Kurnianingtyas (Brawijaya University)



Article Info

Publish Date
30 Oct 2026

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

Copyrights © 2026






Journal Info

Abbrev

joti

Publisher

Subject

Computer Science & IT Control & Systems Engineering Electrical & Electronics Engineering Engineering Mechanical Engineering

Description

1. Teknologi Informasi : Rekayasaperangkat lunak, Pengetahuan data maining, Mobile Computing, Parallel/Distributed Computing, Kecerdasan Buatan, Tata Kelola dan Manajemen Sistem Informasi, User Interface/ User Experience, Process Management, IT Security, IS Adoption and Evaluation. 2. Sistem ...