Held to Account

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

junior

Problem

Fidelity's brokerage platform needs a book of record where compliance can reconstruct what any account held on any past trading day, and where one customer may own several accounts while an account may be jointly held by several customers. Design the model so a trade's executed price stays fixed for all time even as the security's quoted price keeps moving.

Practice This Problem

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