Design
Optimizing Inventory for a São Paulo D2C Cosmetics Brand
Overview
What this challenge is about.
You are given a CSV file with raw sales, inventory, and supplier data. Your task is to design an E/R diagram, create the normalized relational schema in 3NF, populate it with sample data, and write SQL queries to: (1) list products with stock below reorder point, (2) calculate turnover rate per product, (3) identify top 5 slow-moving items. Success means a clean schema, correct SQL, and a short report with recommendations. Constraints: use only SQLite or PostgreSQL, no external libraries.
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.
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.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.