What the Clock Remembers

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

mid

Problem

AFRY's finance team bills clients each month for the hours consultants log against engineering projects, and a consultant's hourly rate gets renegotiated every few quarters. Model the time logs, projects, clients, and consultants so an invoice from last spring still reflects the rate that was in effect when the work was done, even after that rate has since changed. The same model should let finance total billed revenue per project per month.

Practice This Problem

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