E-Commerce Database System
Designed and implemented a relational ecommerce database with a team to model inventory, customers, sales, and employees.
Problem
The system needed accurate relationships between stores, products, staff, and transactions to reflect real retail operations.
Solution
Created normalized relational models and connected them to a frontend interface so users could query and interact with the dataset.
Architecture
- Relational schema with core retail entities and key relationships.
- Query patterns linking inventory, sales, customers, and staffing data.
- Database integration with a React frontend for end-to-end interaction.
Tech Stack
SQLReactJavaScript