ZotStreaming

Overview

ZotStreaming is a command-line application backed by a relational database that supports importing data, running queries, and managing workflows across key entities. The goal was to design a coherent schema and build reliable query operations that reflect real product requirements. I focused on translating requirements into a normalized model, implementing query logic cleanly, and handling edge cases that show up in real datasets.

Highlights

• Designed a relational schema that connects core entities cleanly and supports real query needs.
• Implemented reliable import and query workflows with clear command interfaces.
• Handled constraints and edge cases so operations stay correct and predictable.
• Translated product questions into efficient SQL queries.

Tech

Python, MySQL, relational schema design, SQL queries, CLI workflows