Skip to content
Back to challenges
Many-to-Many and Bridge TablesConcept Challengeintermediate30 min

Account-ownership bridge

Build an account-owner bridge that preserves ownership periods and allocation weights for ARR reporting.

How this preview works
Preview this problem before signing in. Sign in to save progress and submit work.

Concept

many-to-many-modeling

The primary modeling idea this problem reinforces.

Requirements

5

Business needs the model must satisfy.

Read the concept guide: Bridge tables
Scenario

Revenue operations wants ARR by owner team. Enterprise accounts can have multiple owners at the same time, ownership can change mid-quarter, and each ownership period has an allocation percentage.

Why this matters

Once account ownership carries dates and split credit, it stops behaving like a plain attribute. Without bridge grain, ARR either double counts or loses historical ownership.

Requirements
  • Keep accounts and owners as separate reusable dimensions.
  • Add an account-owner ownership bridge.
  • Add account, owner, allocation, and effective-from columns to the bridge (the floor: a correctly allocated, time-variant bridge).
  • Grade up by closing each ownership window with an effective-to, so expired splits stop joining current metrics.
  • Declare N:1 relationships from the bridge to both dimensions through surrogate keys.
Read-only starter workspace
Inspect the authored starting ERD, then open the workspace to edit and run the checks. Saving your progress needs a free account.

Template

Account ownership starter workspace

The model users start from in the full workspace.

Entities

3

Seeded tables visible in the public preview.

Dialect

postgresql

Generated SQL target for this starter model.

Mini Map

This preview is read-only. Open the workspace to edit and verify; saving needs a free account.

Open workspace

Try the question first.

The discussion has other people's approaches and solutions. Give it a real attempt before you read them.