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