Basic Framework
Implementsystem-designresearch-cardSystem Design

System Design Card 384 — Data Model / Implement

Data Model — BASIC step map

Concern

The data model should fit the access patterns, consistency needs, and entities that matter most. A messaging system may need message records, user preferences, templates, provider receipts, and status history.

The gap between knowing and showing is where interviews are lost.

What Implement means for this concern

In BASIC, the Implement step is where you walk the design into existence in a controlled order, deepening the risky parts first. For Data Model, that means the candidate should make this concern visible at the right moment instead of bolting it on at the end.

Design move

A good move is to transcribe the plan instead of improvising. Tie the concern back to the user flow, the workload, and the dominant trade-off. That keeps the design grounded and makes it easier for the interviewer to follow why a cache, queue, replica, partition, or rate limiter is actually necessary.

Common miss

The miss is treating schema as an afterthought instead of a design core. BASIC helps because the staged flow keeps this concern proportional to the prompt and connected to the rest of the architecture.

BASIC prompt

“When I reach the Implement stage, how does Data Model change the architecture, the trade-offs, or the review checklist?”

A senior signal
Interviewers notice when implementation matches the plan. It demonstrates control. When code diverges from the explained approach, it raises a yellow flag — either the plan was wrong or the candidate can't execute their own designs. Neither reads well.

References

S9 S14 S15

Related in System Design

January 16, 2023

BASIC for system design interviews: the most reliable sequence for thinking at architecture scale

System design interviews are not just “bigger coding interviews.”

April 10, 2025

System Design Card 356 — Requirements Clarification / Breakdown

Every design starts with defining what must be true for the system to be considered successful. A notification system for security alerts is a different system from a marketing…

April 12, 2025

System Design Card 357 — Requirements Clarification / Assess

Every design starts with defining what must be true for the system to be considered successful. A notification system for security alerts is a different system from a marketing…