SQL
Car Transport Management System
During my undergraduate studies in an Introduction to Database course, I led a team of four in developing a project titled "Car Transport Management System."
Project Overview
Led a team of four during my undergraduate Introduction to Database course to develop a "Car Transport Management System." The project focused on designing and implementing a structured relational database system to manage vehicle transport operations efficiently while applying core database design principles.
Objectives
- Design a relational database to manage car transport operations.
- Ensure data integrity, consistency, and optimized performance.
- Apply theoretical database concepts in a real-world system design.
- Document the full development lifecycle following best practices.
My Responsibilities
- Led and coordinated a team of four members to ensure timely and quality project delivery.
- Designed the database schema and developed a comprehensive Entity-Relationship (ER) diagram.
- Executed 100+ DDL and DML statements for database creation, manipulation, and querying.
- Applied normalization techniques (up to 3NF) to maintain data integrity and reduce redundancy.
- Utilized window functions and relational algebra concepts to optimize queries and improve performance.
- Prepared detailed technical documentation covering system architecture and database design decisions.
Key Insights
- Strengthened understanding of relational database design and normalization principles.
- Improved query optimization skills using advanced SQL concepts.
- Enhanced leadership and collaboration skills through team management.
Impact
- Successfully delivered a fully functional database system meeting academic and technical requirements.
- Demonstrated practical application of database theory in system development.
- Built a strong foundation for future roles in Data Engineering and Database Management.
