TrackFTS0010

Choose the Relational Model

Medium

Problem

Paradox Shop's order API already serves 800 RPS correctly. Its first-draft order schema contains the required tables but lacks enforceable relationships and integrity constraints, and the order-history lookup by customer is still a full scan against 40 million orders. Complete the schema text, and index the field that lookup depends on.

Required components

Click to add a component to the canvas.

Additional components

Browse by category. Click or drag a component onto the canvas.

Current Production Metrics
Snapshot of the system before any changes.
Traffic
800 RPS
App CPU
73%
Monthly cost
$1,080

Drag components from the library onto the canvas, then drag from a component's right handle to connect it to another.

100%

Design canvas

Sign up to start designing

Sign up free

Premium is free for 58 more days.

$0 / $1,200