Subscription and Payment Data Model
A medium Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
We run an online education marketplace. Two types of users (students and instructors) can subscribe to different plan tiers. Students pay for access; instructors pay for listing and promotion features. Multiple payment methods are supported. Finance needs month-over-month growth reports and outstanding balance tracking. Design the data model, then write the SQL for MoM subscription growth.
Summary
Two user types. Multiple payment methods. One messy billing table.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision