Microsoft SQL Server

Objective:

Your task in this assignment is to analyze the functionalities and objects within the Gmail Mobile Application. This involves examining how Gmail operates, focusing on core features such as sending and receiving emails, inbox management, filtering, labeling, and user interactions with messages. You will also identify and describe the important objects that make up the application, such as emails, users, folders, attachments, and filters.

To help guide you, we have provided an example analysis of Outlook, another popular email platform.

Example: Outlook Application Analysis

Functionalities of Outlook

1. Email Sending and Receiving:
   • Users can send and receive emails with attachments.
   • Outlook supports multiple email accounts in one application.
   • Users can sync their contacts from their devices or cloud.
2. Inbox Management:
   • Outlook automatically categorizes emails into Focused and Other tabs for improved organization.
   • Users can mark emails as read/unread, archive messages, or delete them.
   • Features such as snooze and pinning allow users to manage high-priority emails effectively.
3. Folders and Organization:
   • Users can create custom folders and rules to automatically organize emails.
   • Outlook also offers flags, categories, and filters to further manage email content.
4. Calendar Integration:
   • Outlook includes an integrated calendar for scheduling meetings and events.
   • Users can create, accept, and manage calendar invitations from their inbox.
   • Integration with Microsoft Teams allows scheduling of virtual meetings.
5. Push Notifications:
   • Users receive real-time push notifications for new emails and calendar events.
   • Notification settings can be customized based on account or folder preferences.
6. Search Functionality:
   • Users can search for emails by keywords, sender, date, or attachment.
   • Outlook offers advanced search filters such as unread, flagged, or emails with attachments.
7. Focused Inbox:
   • Outlook’s Focused Inbox feature automatically prioritizes important emails based on the user's interactions and behavior.
   • Less important messages are filtered into the Other tab.
8. Spam and Security:
   • Outlook includes built-in spam and malware protection.
   • Suspicious emails are flagged, and users are warned against potential phishing attacks.
9. Multiple Account Management:
   • Outlook supports multiple email accounts, allowing users to switch between personal and business accounts seamlessly.
10. Third-Party Integrations:
    • Outlook integrates with third-party services like Google Drive, Dropbox, and OneDrive for file attachments and sharing.
    • Microsoft Office apps such as Word, Excel, and PowerPoint can be used directly from within Outlook.

Important Objects in Outlook

1. User:
   • Attributes: user_id, first_name, last_name, email_address, password.
   • Relationships: Users send, receive, and manage emails, access calendars, and create folders.
2. Email:
   • Attributes: email_id, sender, receiver, subject, body, sent_date, read_status.
   • Relationships: Emails are linked to users and can belong to different folders, have attachments, and be marked as spam.
3. Folder:
   • Attributes: folder_id, folder_name, user_id.
   • Relationships: Users create folders to organize emails, and rules can be applied to sort emails automatically.
4. Attachment:
   • Attributes: attachment_id, file_name, file_size, email_id.
   • Relationships: Attachments are tied to specific emails and can be viewed or downloaded by recipients.
5. Calendar Event:
   • Attributes: event_id, event_name, event_date, location, user_id.
   • Relationships: Calendar events are linked to users, and invitations can be sent to others for participation.
6. Filter/Rule:
   • Attributes: rule_id, criteria, action, user_id.
   • Relationships: Filters automatically organize emails into folders or mark them based on defined rules (e.g., sender, keywords).

Your Task: Analyzing Gmail Mobile Application

Following the example provided for Outlook, your task is to perform a similar analysis for Gmail. You are required to:

1. List the functionalities that Gmail offers.
   • Consider features such as composing and sending emails, inbox management, categories (Primary, Social, Promotions), email filters, and integration with other Google services like Google Drive.
   • Include features like Gmail Labels, Snooze, Priority Inbox, Spam Protection, and Search.
2. Identify and describe the important objects in Gmail.
   • Consider objects like User, Email, Label, Attachment, Filter, Conversation Thread, and Starred Messages.
   • Explain how these objects interact with each other (e.g., Users send emails with attachments, assign labels, and manage email conversations).

Your analysis should provide a clear understanding of how Gmail operates, both in terms of its key features and its underlying data structure.

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