Every Line Remembered
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
You are handed the transactional database behind a retail chain: orders, customers, products, stores (some of them digital storefronts with no physical location), and employees, where a single order spans several line items, each for a different product. Redesign it as a dimensional warehouse that keeps every line item as its own record, so product-mix, per-line sales, and customer-behavior reporting stays a simple roll-up. Watch two quirks the source carries: product identifiers get reused when a retired item relaunches, and a sale must keep showing the customer's address as it stood on the order date even after the customer later moves.
Summary
Customers move, products relaunch, and some stores have no address. Reshape the tables so nothing gets forgotten.
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