Scenario: A social media platform tracks users and their posts. Each user can have multiple posts, and each post can have multiple comments. How would you model this relationship in an ERD?
- Many-to-Many
- Many-to-One
- One-to-Many
- One-to-One
The appropriate relationship for this scenario is Many-to-Many. Each user can have multiple posts, and each post can have multiple comments from different users. It reflects the complex interactions between users, posts, and comments on a social media platform.
Loading...
Related Quiz
- In NoSQL databases, _______ consistency model ensures that all updates are immediately visible to all clients.
- Which of the following statements best describes denormalization?
- _______ is the process of reorganizing table and index data to improve query performance and reduce contention in a database.
- ER diagram tools enable users to create visually appealing _______.
- Partitioning helps in _______ the data across different storage devices or servers.