Project Showcase

Highlight of my featured works

Database Trasporindo

Database / SQL Design 2025

A relational database design and implementation project for Trasporindo Export Documents. Normalized up to 3NF and implemented with MySQL to manage export documentation.

Unnormalized Sample Data Database Normalization Process ERD Trasporindo Database ERD Trasporindo Database

🎯 What I Learned

  • Applied database normalization (UNF → 3NF)
  • Designed ERDs for export documentation
  • Implemented SQL tables with PK–FK relationships

🛠 Tech Stack

  • MySQL / MariaDB
  • SQL Workbench / phpMyAdmin
  • ERD Tools

📌 Evaluation / Next Step

The Trasporindo database project achieved its goal of removing anomalies and improving accuracy by normalizing data to 3NF. ERD and SQL scripts provide a solid foundation for managing export documents. Next steps include adding triggers for validation, stored procedures, and possibly a frontend integration for real-time export operations.

View on GitHub