D8LoopData Modeling
Marketplace core entities
Model the core entities and relationships behind a growing marketplace.
Start from a blank ERD canvas.
Explore your own domain, interview prompt, or architecture idea without being locked into a predefined scenario.
9 interview-style modeling scenarios.
Marketplace core entities
Model the core entities and relationships behind a growing marketplace.
Fulfillment network
Model warehouses, inventory, shipments, and order fulfillment handoffs.
Creator payout operations
Design the entities behind creator earnings, payout runs, and transfer status.
Subscription warehouse grain
Choose fact and dimension boundaries for subscription reporting.
Support ticket lifecycle
Model tickets, ownership changes, comments, and SLA-relevant status history.
Product analytics identity
Balance users, devices, sessions, and event history for clean analytics joins.
Customer 360 tradeoffs
Balance normalized source design against analytics-ready access patterns.
Global pricing history
Track regional price changes, currency context, and effective-date history cleanly.
Risk and compliance audit
Design an auditable model for reviews, escalations, approvals, and policy evidence.