About This Project
Overview
A relational e-commerce backend built in MS SQL covering inventory, orders, and payments, with additional views and queries built out for business-intelligence-style analytics — modeled and diagrammed in Lucidchart.
Motivation
This was a database-design-focused coursework project, and I wanted to go beyond a bare schema into something with real BI-style queries and views on top.
Lessons Learned
Normalization tradeoffs became very concrete here — a fully normalized schema made some of the analytics queries painfully slow, which taught me why selective denormalization exists in real systems.