Model advertiser intake database schema
Company: Netflix
Role: Software Engineer
Category: System Design
Difficulty: hard
Interview Round: Onsite
Design the data model for an advertiser intake system (similar in spirit to an F1-backed schema). Identify core entities—organization, account, user/seat, campaign, ad group, creative, budget/flight, targeting, frequency-cap policy, billing, approvals—and define key fields and relationships. Provide ERD-level tables with primary/foreign keys; discuss normalization vs denormalization, multi-tenancy and row-level security, configuration versioning and auditability, soft deletes, idempotent imports, and how the schema supports validation and partial onboarding.
Quick Answer: Model advertiser intake database schema evaluates requirements, scale assumptions, API/data design, architecture, trade-offs, failure modes, and rollout in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.