Between the Cameras

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

Domain

Data Modeling

Difficulty

easy

Seniority

L4

Problem

We run a toll road network where a camera reads a vehicle's license plate when it enters a tolled section and again when it leaves, and the same commuter plate turns up several times a day. Operations needs live traffic volume, the average time a vehicle spends crossing a section, and an alert for any plate that entered but never exited. Model each completed crossing as one record. Design the data model.

Summary

Every plate that goes in should come out. Watch the ones that don't.

Practice This Problem

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