Enterprise-Style MySQL Database

Enterprise-Style MySQL Database

Academic • Database Systems

About The Project

Designed an EERD and translated it to a relational schema with strict constraints and normalization. Implemented core features—user authentication, transaction handling, and concurrent multi-user management—using stored procedures/functions. Focused on integrity, performance, and real-world business workflows.

Achievements

  • 27% query performance improvement via schema tuning and indexing

  • Robust stored procedures/functions for secure auth and complex operations

  • Enforced constraints & normalization to reduce redundancy and ensure consistency

Links

sunny.sunho.park@gmail.com

unsplash.com/@reddfrancisco
unsplash.com/@reddfrancisco