Entities and Attributes of the Social Media Networks
1. Users: Represents individuals for the social media platform
- UserID(primary key): holds the user id for each user
- Username: holds the username associated with each user
- Password: store the password into the database
- Email: hold the email credentials for each user
2. Post: Represents the post for the users
- PostID(primary key): hold a unique post id for posts
- UserID(foreign key): holds the user id to map with posts
- Content: store the contents of each post
- Media_type: store the type of the posts, i.e., photos, videos, text, etc.
- Visibility: ensure the visibility type of post, i.e., public, private, etc.
3. Shares: Represents the shares for post of users
- ShareID(primary key): store the share id
- Share_name: store the share name
- Share_desc: holds share description of each post
- Share_type: holds share type
4. Permission: Represents permissions for posts of users
- perm_id(primary key): permission id to map with user and posts
- perm_name: holds the permission name
5. Friends: Represents friends of each users
- friend_id(primary key): store the friend id
- friend_name: store the friends name
- friend_username: store the friends username
- friend_add: store the status od friends, i.e., pending, accepted, etc.
How to Design ER Diagrams for Social Media Networks
Social media networks have become an integral part of our daily lives, connecting people around the world and enabling them to share ideas, experiences, and content. It has become increasingly important in today’s world due to its wide–reaching impact on communication, information sharing, and social interactions.
Designing a social media network involves creating a platform that allows users to create profiles, connect with others, share posts, and interact with content.
To build such a platform effectively, it’s important to start with a well-thought-out Entity-Relationship (ER) diagram. In this article, we’ll learn about How to Design ER Diagrams for Social Media Networks with the help of Entity-Relationship (ER) diagrams also the relationship between entities and attributes, and so on.