Something went wrong!
Hang in there while we get back on track
E-Commerce Marketplace Schema Practice
Generates a realistic multi-seller e-commerce marketplace scenario with inventory, orders, payments, and reviews. Tests entity modeling for complex marketplace relationships including multi-seller orders and commission-based payments.
Input
What you provide to the skill
Give me a database schema design practice scenario for an e-commerce marketplace
Output
What the skill generates for you
DATABASE SCHEMA PRACTICE: E-Commerce Marketplace
Scenario: You’re a PM at a growing e-commerce marketplace platform (think Etsy or Amazon Marketplace). Multiple independent sellers can list products, and buyers can purchase from any seller. Design the database schema to support core marketplace functionality.
Core Features to Support:
- Sellers can create storefronts and list products with variants (size, color, etc.)
- Buyers can browse products, add to cart, and checkout
- Orders may contain items from multiple sellers
- Inventory management per product variant
- Product search and filtering (category, price, ratings)
- Order tracking and fulfillment (different sellers ship separately)
- Reviews and ratings for products
- Payment processing (marketplace takes commission, sellers get remainder)
Scale Context:
- 100,000+ sellers
- Millions of products
- High read-to-write ratio (browsing >> purchasing)
Your Task: Design the schema by defining:
- What tables or collections do you need?
- What are the key fields for each?
- What relationships exist between entities?
- Would you use SQL or NoSQL? Why?
- Any special considerations for scaling?
Take 5-10 minutes to design your schema, then share your design.
About This Skill
Practice database schema design for PM interviews with realistic product scenarios and detailed feedback.
View Skill DetailsMore Examples
Advanced Event Sourcing and CQRS Scenario
Generates an advanced banking platform scenario requiring event sourcing with CQRS architecture. Tests understanding of write-side events vs read-side projections, event versioning, schema evolution, and regulatory audit requirements.
Social Media App Schema Evaluation
Evaluates a user-submitted social media schema with users, posts, follows, and likes tables. Demonstrates comprehensive feedback including missing fields, feed generation strategies, relationship cardinality, and PM-relevant trade-offs.