DATABASE DESIGN · SQL · PASSION PROJECT BACK TO TECHNICAL

DATABASE DESIGN · SQL · PASSION PROJECT

FinEdu

Not a class prompt. FinEdu is the financial-literacy venture I've carried since founding an investment club in high school and writing a 16-page DECA business plan around making financial education accessible to underserved communities. This is where I gave that mission a real backend.

A normalized relational database (6 tables: Customer, Product, Order, OrderDetail, Instructor, CommunityPartner) modeling how the business would actually run: customers referred by community partners, services delivered by instructors, orders resolved through a many-to-many bridge. Designed to Third Normal Form for data integrity and clean scaling.

Then the queries the business would actually ask: top-selling services, average order value ranked per customer, cumulative spend over time, customers spanning multiple categories, using JOINs, nested subqueries, and window functions (RANK, PARTITION BY).

STACK MySQL · SQL

METHOD ERD and schema design · 3NF normalization · PK/FK constraints · many-to-many resolution via bridge table · complex queries (multi-table JOINs, nested subqueries, window functions)