Designadvanced
60 min
Design an E-Commerce Schema
Design a database schema for a simplified e-commerce platform with users, products (with categories), orders, and order items. Then write 5 business queries: top-selling products, customer lifetime value, abandoned carts, monthly revenue by category, and customers with no orders in 90 days.
Your progress0%
Requirements
Skills you'll use
SQLSchema DesignNormalisationBusiness Queries
Read this first
This task is based on the lesson below. Complete the reading before attempting it.
Go to lessonWhat to expect
- Difficulty
- advanced
- Time
- 60 min
- Steps
- 7
- Type
- Design