Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What would be the most efficient ER diagram to organize a database using MySQL that includes these features. Show diagram please. Thanks in advance. Your

What would be the most efficient ER diagram to organize a database using MySQL that includes these features. Show diagram please. Thanks in advance. image text in transcribed
Your site will support the following operations: 1. Register a new user 2. Follow a user 3. Unfollow a user 4. Block a user 5. Unblock a user 6. Post a new message by a user 7. Reply to a message 8. Like a message 9. Share a message (re-tweet) 10. Unlike a message 11. Delete a message 12. Read all message from followed user 13. Search all messages based on a user 14. Search all message based on a keyword 15. Read notifications about posts made by users followed by some other user. 16. Read notifications about likes to posts made to messages from a logged user. 17. Read notifications about unlikes to posts made to messages from a logged user. 18. Engagement statistics for a given message a. Number of likes b. Number of dislikes c. Number of reads d. Number of replies e. Number of shares 19. Global statistics* for: a. number of posts b. number of posts per user, c. number of posts per day, week, or month. *Additional Statistics could be given in latter phases

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

t. james, owner, invested 20000 cash in sustain company

Answered: 1 week ago

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago