PostgreSQL

Objective:

Your goal in this assignment is to analyze and list the key functionalities of the Instagram Social Application. Additionally, you should identify and explain the main objects in Instagram, such as users, posts, stories, comments, followers, likes, and messages. The expectation is that you will thoroughly break down how Instagram operates from a functional and object-oriented perspective.

Your output should include:

• A detailed list of functionalities available in the Instagram app.
• Identification and explanation of core objects (e.g., user, post, story, comment, follower, like, message).

To guide your work, we’ve provided an example analysis for Pinterest, another popular social media application.

Example: Pinterest Application Analysis

Functionalities of Pinterest

1. User Account Management:
   • Registration via email, Google, or Facebook accounts.
   • Customizing user profile: username, profile picture, and personal bio.
   • Following other users or boards of interest.
2. Pin Creation and Sharing:
   • Uploading images or videos as Pins from devices or directly from websites.
   • Adding descriptions, tags, and links to Pins.
   • Saving Pins to user-created or existing Boards.
3. Boards for Organizing Content:
   • Creating Boards to organize Pins by topics (e.g., travel, food, fashion).
   • Secret boards for personal use (private to the user).
   • Collaborating on Boards by inviting other users to add Pins.
4. Discovering Content:
   • A personalized feed of Pins based on user preferences and past engagement.
   • Search functionality to find Pins, Boards, or specific topics.
   • Trending Pins based on popular themes and user activity.
5. Pin Engagement:
   • Liking and commenting on Pins to interact with other users.
   • Saving Pins to your own Boards.
   • Sharing Pins externally via social media platforms or messaging.
6. Shopping and Product Integration:
   • Direct links to purchase products from Pins (product Pins).
   • Integrated shopping experience with buyable Pins (e.g., fashion, home décor).
7. Group Boards:
   • Collaborative boards where multiple users can contribute Pins.
   • Useful for event planning, team projects, or shared interests.
8. Video Pins:
   • Creating and sharing video content as Pins.
   • Ability to like, share, or comment on videos, similar to image Pins.
9. Business Tools:
   • Pinterest business accounts with analytics tools for tracking engagement, impressions, and audience insights.
   • Creating Promoted Pins for advertising purposes.
   • Insights on the performance of Pins, audience demographics, and website traffic from Pinterest.
10. Privacy and Security:
    • Public or private account settings.
    • Blocking and reporting users or Pins that violate community guidelines.
    • Personal data protection and account security options.

Important Objects in Pinterest

1. User:
   • Attributes: user_id, username, followers, following, profile_picture, bio.
   • Relationships: A user can follow other users, create Boards, and Pin content.
2. Pin:
   • Attributes: pin_id, image, description, link, tags.
   • Relationships: A Pin can be saved to Boards by users and commented on by others.
3. Board:
   • Attributes: board_id, board_name, visibility, created_by_user_id.
   • Relationships: A Board is created by a user and contains multiple Pins.
4. Comment:
   • Attributes: comment_id, content, timestamp, user_id, pin_id.
   • Relationships: A comment is linked to a user and a Pin.
5. Like:
   • Attributes: like_id, user_id, pin_id.
   • Relationships: A like is associated with a user and a Pin.
6. Follow:
   • Attributes: follow_id, follower_id, following_id.
   • Relationships: A user can follow another user, and this relationship is tracked by the Follow object.

Your Task: Analyzing Instagram Social Application

Based on the example provided for Pinterest, your task is to perform a similar analysis for Instagram. You are required to:

1. List the functionalities Instagram offers.
   • Explore features such as posts (photos and videos), Instagram Stories, Reels, IGTV, Direct Messaging, and more.
   • Mention interactivity options like likes, comments, sharing, and saving posts.
   • Look at features such as account privacy settings, tagging users, following and followers, and highlights.
2. Identify and describe the important objects in Instagram.
   • Consider objects like User, Post, Story, Comment, Like, Follower, Message, and Hashtag.
   • Define the relationships between these objects (e.g., A user can create multiple posts, a post can receive several comments and likes, a user can follow other users).

   Provide a structured and detailed analysis of the Instagram Social Application.

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