Two Wallets
A medium Data Modeling mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
We run an online education marketplace with two user types: students paying for access, and instructors paying for listing and promotion features. Both subscribe to different plan tiers and keep several payment methods on file, each stored as an opaque gateway token plus the card brand and last four digits for display, never full card numbers. Finance also needs to reconstruct how many subscribers we had in any past month, so design the data model behind billing.
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
- Draw your data model on the schema canvas: tables, keys and relationships
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision