Optimizing Inventory for a São Paulo D2C Cosmetics Brand
Overview
What this challenge is about.
Optimizing Inventory for a São Paulo D2C Cosmetics Brand. Intermediate challenge in design. Designing real products under real constraints, earn a blockchain...
The Brief
What you'll do, and what you'll demonstrate.
Design a normalized database and write SQL queries to optimize inventory levels and reduce stockouts and overstock.
This is not a design exercise. It is the work a product designer does between a brief and a shipped interface. That distinction matters to every hiring manager who has seen candidates redesign Spotify's homepage and none who have worked under real product constraints.
When you finish, you will have something most graduates do not: a real-world deliverable, verified by Ewance, that you can show to a hiring manager and say "I did this. Here is the proof."
Earning criteria — what you'll demonstrate
- Apply normalization up to 3NF
- Create E/R diagrams from business requirements
- Write complex SQL queries with joins, aggregations, and subqueries
- Translate business problems into database queries
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Aligned coursework coming soon.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
- Sql
Query, transform, and analyze relational data to extract meaningful business insights.
- Database Design
Apply database design to solve real industry problems and demonstrate production-level capability.
- Normalization
Apply normalization to solve real industry problems and demonstrate production-level capability.
- Erd
Apply erd to solve real industry problems and demonstrate production-level capability.
- Data Analysis
Analyze real datasets, build models, and communicate findings that drive decisions.
Careers
Career paths this challenge builds toward
Completing this challenge demonstrates skills that transfer directly to these roles: