Model entities for feed content and shares

Q: Model entities for feed content and shares

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.

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

Quick Overview

Scenario

Prompt

Solution

Comments (0)