Design a social network model. We will have users with a mailbox and connections to other users (friends). Users might also post messages or images/videos that can be viewed by other users. • Each user will have a unique ID. Additionally, the first and last names, email address, age, gender will need to be stored. • Each user will be connected to zero or more friends (who are also users). • Users send message to other users. Date and content of each message will be stored. • Users can post zero or more items. • Each item has a unique postId. Time and location of the item will be stored. • Every item belongs to only one user. • An item can be a text or a photo/video. Content of a text, and caption and link of a
Design a social network model. We will have users with a mailbox
and connections to other users (friends). Users might also post messages or
images/videos that can be viewed by other users.
• Each user will have a unique ID. Additionally, the first and last names, email address,
age, gender will need to be stored.
• Each user will be connected to zero or more friends (who are also users).
• Users send message to other users. Date and content of each message will be stored.
• Users can post zero or more items.
• Each item has a unique postId. Time and location of the item will be stored.
• Every item belongs to only one user.
• An item can be a text or a photo/video. Content of a text, and caption and link of a
photo/video will be stored.
Draw an ER diagram for the social network system.
Step by step
Solved in 5 steps with 1 images
