Basic Framework
Checksystem-designresearch-cardSystem Design

System Design Card 385 — Data Model / Check

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.

Structure your thinking before structuring your code.

What Check means for this concern

In BASIC, the Check step is where you review the design for bottlenecks, failure modes, security gaps, observability, and cost. 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 review and stress-test before you hand the answer over. 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 Check stage, how does Data Model change the architecture, the trade-offs, or the review checklist?”

From real interviews
Interviewers have limited time. When a candidate self-checks, it means the interviewer can spend their remaining questions going deeper into interesting territory rather than probing for basic correctness. That changes the tone of the entire interview.

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…