MySQL

Objective:

The objective of this assignment is for students to analyze and list key functionalities of Facebook, as well as identify important objects in the Facebook application. Your task is to carefully analyze the core functionalities of a social media platform like Facebook and identify its key objects (such as user, page, comment, etc.).

Yourare expected to:

• List the main functionalities of the Facebook app.
• Identify and describe the important objects that exist in Facebook's data model (e.g., User, Post, Comment, Reaction).

We expect a detailed analysis, but to guide you in the right direction, we'll provide an example of similar analysis for Quora, another popular social platform.

Example: Quora Application Analysis Functionalities of Quora

1. User Registration and Login:
   • Sign up via email, Google, or Facebook..
   • Password recovery functionality.
2. User Profile Management:
   • Edit profile information (e.g., name, bio, profile picture)..
   • Follow topics of interest.
   • View personal stats (e.g., number of followers, answers provided).
3. Asking and Answering Questions:
   • Users can ask questions on a variety of topics.
   • Other users can answer questions or provide additional details.
   • Answer upvoting and downvoting to rank responses.
4. Content Moderation:
   • Report inappropriate content.
   • Follow moderation guidelines enforced by Quora.
5. Feed Generation:
   • Personalized feed based on followed topics, users, and previous activity.
   • Recommendations of related questions and answers.
6. Search Functionality:
   • Search for questions, answers, topics, and users.
   • Filter search results based on relevance or date.
7. Notifications:
   • Receive notifications when someone answers your question, follows you, or upvotes your content.
   • Customize notification preferences.
8. Interaction with Content:
   • Upvote or downvote questions and answers.
   • Comment on answers or add your perspective.
   • Share content to external social media platforms.
9. Spaces and Communities:
   • Join or create Spaces (topic-focused communities).
   • Interact with other members within a Space by posting content and participating in discussions.
10. Private Messaging:
    • Users can send private messages to each other.
    • Block or report inappropriate messages.

Important Objects in Quora

1. User:
   • Attributes: user_id, name, email, profile_picture.
   • Relationships: A user can follow other users, post questions, and provide answers.
2. Question:
   • Attributes: question_id, title, content, created_at, user_id.
   • Relationships: A question is posted by a user and can have multiple answers and followers.
3. Answer:
   • Attributes: answer_id, content, created_at, user_id, question_id..
   • Relationships: An answer belongs to a question and is provided by a user.
4. Comment:
   • Attributes: comment_id, content, created_at, user_id, answer_id..
   • Relationships:A comment is added to an answer and is written by a user.
5. Upvote/Downvote:
   • Attributes: vote_id, vote_type (upvote or downvote), created_at, user_id, answer_id..
   • Relationships: A vote is cast by a user on an answer .
6. Space:
   • Attributes: space_id, name, description, created_at, owner_id..
   • Relationships: A space is created by a user and can have multiple members and posts.
7. Message:
   • Attributes: message_id, content, created_at, sender_id, receiver_id..
   • Relationships: A message is sent by one user to another user.

Your Task: Analyzing Facebook

Now that you have an example of Quora's functionalities and objects, it’s time for you to do the same for Facebook. Follow the same process and structure:

1. List the functionalities that Facebook provides.
   • Think about user interactions, content sharing, profile management, messaging, groups, and events.
   • Consider privacy settings, notifications, and user experience features.
2. Identify important objects in Facebook.
   • Describe the objects and their attributes (e.g., User, Page, Post, Comment, Reaction, Friend, Message, Group, Event).
   • Define relationships between these objects (e.g., A user can create a post, a user can react to a post, a user can be part of multiple groups).

Provide a detailed analysis for each functionality and object. Your submission should include a well-structured list similar to the example provided for Quora.

GOOD LUCK WITH YOUR ASSIGNMENT!!

Don't forget to contact us if you need any further assistance with your assignments, and most importantly, for a manual review and approval of your work.

To gain complete access, login with gmail or outlook, no need of signup, click here