Employee Transfer Tracking System

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

senior

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?

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write your data modeling solution with real code execution
4. Get instant feedback and a hire/no-hire decision