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're a large tech company with 80,000 employees across 30 offices. People transfer between departments, change managers, and relocate to different offices. HR currently stores everything in a single employee table and loses history every time someone moves. Can you design a schema that tracks the full movement history?
Summary
People switch teams. HR loses track.
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