SQL Relational Database

This project involved designing and implementing a fully normalized relational database for a tattoo studio’s client intake and booking workflow. I developed the schema from scratch in MySQL, modeling core entities such as clients, artists, tattoo requests, session types, and reference imagery while enforcing data integrity through primary keys, foreign keys, and unique constraints.

The database structure includes a many-to-many relationship between requests and session types, implemented through a junction table to preserve normalization and eliminate redundancy. I also wrote a Python-based ETL pipeline using SQLAlchemy and pandas to clean raw CSV intake data, standardize column names, deduplicate records, and load the data into the appropriate relational tables while maintaining referential integrity.

To support iterative development and testing, I implemented a controlled truncation workflow that safely resets tables while handling foreign key dependencies.

This project strengthened my understanding of relational schema design, normalization principles, constraint management, and building structured data pipelines that transform messy real-world intake data into a reliable, quarriable database system.