Model entities for feed content and shares
Company: Meta
Role: Data Engineer
Category: System Design
Difficulty: hard
Interview Round: Onsite
## Scenario
You are designing the data model for a social app’s **News Feed** that shows multiple content types (text, image, short video). Users can interact with content (view, like, comment, share).
## Prompt
1. Propose a **data model** for the core feed domain focusing on:
- **Users**
- **Content** (supporting text/image/video)
- **Interactions** between users and content
2. Identify key **entities**, **relationships**, and **primary/foreign keys**.
3. In an analytics warehouse context, specify which tables are **dimensions** vs **facts** and list a few core fields.
4. Follow-up: extend the model to support **sharing** (a user shares a piece of content to another user, to a group, or to an external channel).
Quick Answer: This question evaluates a candidate's competency in data modeling and system design for feed and interaction domains, covering entity-relationship modeling, schema design for multi-format content, interaction events, and sharing semantics.