Global pricing history · Data Modeling scenario

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

You own pricing data at LoopStore, selling the same catalog in many regions and currencies. A price is a value that holds between two dates, in one currency — design a model where the timeline is gap-free and overlap-free and a past order’s price is never rewritten.

your ERD must answer

01The current price of a product in a given currency.
02The price in effect for a product+currency at any past date.
03The price an order was actually charged, stable against later changes.

out of scopeTaxes · promotions · FX conversion · cost/margin

This exercise’s brief could not be loaded.The guided questions and their model answers come from the review service. It looks like it is not reachable — start it with pnpm dev:api and reload.The canvas below still works, so you can model now and run the review once the service is up.

Build starts here

The brief becomes the left drawer. The canvas stays the build surface.Study is done above. Build the tables here, hit review to validate, then use follow-ups to defend the model.

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

68%

You built the model in the Studio. Now defend it.Global pricing history

Design review

The reviewer reads your model.

Desktop only

This scenario runs a full workspace — editor, canvas and results side by side. It needs a laptop or desktop to be usable. Open this page on a bigger screen to start building.

Read the library instead Back to modules

Preparing your workspaceloading the brief, studio & canvas…

buyersellerlistingorder

SCENARIO

You own pricing data at LoopStore, selling the same catalog in many regions and currencies. A price is a value that holds between two dates, in one currency — design a model where the timeline is gap-free and overlap-free and a past order’s price is never rewritten.

your ERD must answer

01The current price of a product in a given currency.
02The price in effect for a product+currency at any past date.
03The price an order was actually charged, stable against later changes.

out of scopeTaxes · promotions · FX conversion · cost/margin

This exercise’s brief could not be loaded.The guided questions and their model answers come from the review service. It looks like it is not reachable — start it with pnpm dev:api and reload.The canvas below still works, so you can model now and run the review once the service is up.

Build starts here

The brief becomes the left drawer. The canvas stays the build surface.Study is done above. Build the tables here, hit review to validate, then use follow-ups to defend the model.

Practice studio

Ctrl/Cmd + C copyCtrl/Cmd + V pasteCtrl/Cmd + Z undoDelete remove

68%

You built the model in the Studio. Now defend it.Global pricing history

Design review

The reviewer reads your model.

Desktop only

This scenario runs a full workspace — editor, canvas and results side by side. It needs a laptop or desktop to be usable. Open this page on a bigger screen to start building.

Read the library instead Back to modules