System Design · Netflix · Medium
You are the engineer responsible for shaping the core relational model behind a platform that buys and serves advertising inventory on behalf of advertisers. Produce a normalized schema — the tables, the important columns in each, and the relationships between them — that supports the following hierarchy and behavior: One advertiser may own any number of campaigns. A campaign is made up of one or more ad groups (also referred to as line items). Each ad group holds one or…
Checking your access…