Relational Database Design
The Problem
A rapidly growing IT support firm had outgrown disconnected spreadsheets, making staffing visibility, project delivery status, and ticket-billing reconciliation notoriously hard to track and audit.
The Methodology
Constructed normalized entities, bridge tables, enforced referential integrity, and implemented query frameworks for projects, clients, assets, tickets, and employee metadata.
The Impact & Outcome
A unified SQL/Access architecture capable of instantly joining cross-departmental operations data into completely reliable reporting streams.
Key Metric: Replaced chaotic spreadsheet tracking with a relational, strict database built for instant queryability and robust operations scaling.
Database Normalization Ecosystem Report
Below is the public-safe architectural blueprint featuring ERD structures, metadata dictionaries, and standard SQL operational query behaviors.