TMS Database Design Project
Database - University Project MySQL| SQL| ERD| Git| Reverse EngineeringComprehensive database project for a Transportation Management System (TMS) verifying practical proficiency in DDL/DML scripts, database normalization up to 3NF, schema engineering, and a full suite of advanced MySQL queries.
Project Evolution & Overview
The project followed a custom, deliberate execution order: beginning with the structural design and table creation, populating sample logistics data, generating the visual Entity-Relationship diagram through Reverse Engineering, and finally implementing a rigorous query suite.
Key Implementation Aspects
- Structural Design & DDL/DML: Full implementation of table definitions, data manipulation, and integrity constraints.
- Normalization (3NF): Rigorous application of database normalization to ensure scalability and clean relations between vehicles, drivers, contracts, and employees.
- Advanced Query Suite: Implementation of comprehensive MySQL queries covering multi-table joins, subqueries, grouping, aggregate functions, and set operations (such as UNION, INTERSECT, and EXCEPT).
- Reverse Engineering & ERD: Building and verifying visual schema maps directly from developed structures.
Workflow Sequence
- Conceptual Design & Schema Scope
- Data Tables & Sample Data Population
- ER Diagram via Reverse Engineering
- Advanced DDL/DML & Comprehensive Queries
Additional Concepts & Methods
DDL & DML| 3NF Normalization| UNION / INTERSECT| Subqueries & Joins| Constraints