Lateral Paths

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

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We run a large tech company where a single transfer can move someone to a new team, a new manager, and a different office all at once, and departments themselves nest into larger divisions and orgs. Today HR keeps only each employee's current department, manager, and office in one table, so every move erases where they sat before. Design a schema that preserves the full movement history and can answer where any employee was on a given past date.

Summary

People switch teams. HR loses track.

Practice This Problem

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