Model entities for feed content and shares

Q: Model entities for feed content and shares

This is a System Design interview question from Meta for Data Engineer roles. View the full question and solution on PracHub.

Q: How do I approach System Design interview questions?

System Design questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master system design interviews.

Question

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

Propose a data model for the core feed domain focusing on:
- Users
- Content (supporting text/image/video)
- Interactions between users and content
Identify key entities , relationships , and primary/foreign keys .
In an analytics warehouse context, specify which tables are dimensions vs facts and list a few core fields.
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).

Model entities for feed content and shares

Scenario

Prompt

Solution

Comments (0)