Employee Transfer Tracking System

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

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.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.