PRE 1. MGMT2006_Software_Solution X + X O File | C:/Users/kimberly%20Arjoon/Desktop/MGMT2006%20-%20MANAGEMENT%20INFO%20SYSTEMS%201/CCou... @ Not syncing lookingGlass Secur.. BB 70220038.pdf Other favorites 2 of 6 - + | A) Read aloud | Draw V Highlight V Erase When Tyler searches YouTube, Google (that owns YouTube) can track his every move and push content that may appeal to him, including other videos of young and upcoming artists to start their popularity. This is where the currency of 'likes' and retweets and searches turns into actual currency. The selfies each client takes so that others will like them on Instagram helped that company sell for a billion dollars. Sending a tweet helped raise the value of Twitter to around $30 billion while Facebook is valued at approximately $140 billion. You have been asked to help the company analyse some of this data on its new clients and check the data to see who has new "followers' for the day. First, you need to peruse the database. It comprises the following tables BRAND: The Company has negotiated contracts for its clients to use these brands. CLIENT: The names of MGMT Software Solutions" clients FAN: Followers of the company's clients SOCIALWEDAPP: Various social media and apps along with some statistics You are asked to prepare several queries, as well as some reports. Pre-Project Suggestion: . A step-by-step exercise is available for you to follow which imports data from Excel to Access and provides examples on creating queries and functions listed above. This will help you to become familiar with database management system. You should complete these tasks BEFORE you begin your project, as they will greatly assist your understanding and completion of the project. MGMT2006 Project $1:2020-2021PRE 1. MGMT2006_Software_Solution X + X O File | C:/Users/kimberly%20Arjoon/Desktop/MGMT2006%20-620MANAGEMENT%20INFO%20SYSTEMS%201/CCou... @ Not syncing lookingGlass Secur.. BB 70220038.pdf Other favorites 3 of 6 - + A) Read aloud | Y Draw V Highlight V , where G# is your group number. 2. Create relationships between pairs of tables and enforce referential integrity. 3. Add FIVE new clients and associate them with a brand 4. Also, add TEN new followers along with their information. 5. Create the following queries a) List the followers who use WhatsApp. Name the query Q1-WhatsApp. b) Produce the list of clients along with the number of followers. Show the client with the most followers first in the list. Name this query Q2-Followerss. c) Using the name of the client with the most followers from Q2-Followers: i. List the brand that this client is associated with. Name this query Q3-Brand. ii. Produce a count of the different brands that this client's fans are following. Include the brand name (BrandID. Value) and the client's name. Sort the list in descending order of brand. Name this query Q4-BFollowers. Save the query again as "Query on Followers', (This query will have two different names) d) i. Create a new field name Age to calculate the current ages of all clients. The following calculation may be helpful: Round (Int (Date()-[DOB])/365.25) ii. How many clients are under 25 years of age? Name this query Q5-Under25. (Hint: "Where" clause may be useful.) 6. Maybe a PIVOT chart to show the result of Q2-Followers would be more effective. Create this chart with suitable labels and name it as ()2-Followers Chart. 7. Using the "Query on Followers' remove the client's name from the criteria. Add fields to show Replies, Likes, Shares and Clicks. Create a report that is grouped by the client's name and sorted by the brand. Show the details and summary fields for each client and a grand total for the report. Give suitable report headings that are appropriately adjusted and legible. For printing purposes, ensure that the report prints each client on a new page, with alternate lines shaded and the title on each page. Rearrange the fields on the report to MGMT2006 Project $1:2020-2021PRE 1. MGMT2006_Software_Solution X + X O File | C:/Users/kimberly%20Arjoon/Desktop/MGMT2006%20-620MANAGEMENT%20INFO%20SYSTEMS%201/CCou... @ Not syncing lookingGlass Secur. PRE 70220038.pdf Other favorites 4 of 6 - + | A) Read aloud | Draw V Highlight V Erase prevent overflow of information and extra pages. Name the report 'Report of Daily Followers by Client - October 2020. S. Create a switchboard named MGMT Software Solutions Client Menu System. Include TWO queries, the database report and an Exit option. In the bottom right-hand corner, create a label using an 8-point font that states that you created the switchboard. For example, 'Created by "- POWER BI 1. Whether you installed Power BI or plan to use the Web Service :- a) Use the pbix file provided on the course page. 2. Save your file as MGMT2006_G#_, (For example, MGMT2006_G50_Jane Doc). All pages should be numbered. It must include: 1. A cover page comprising the UWI Open Campus title, course code and course name, the name of the Coordinator, your E-Tutor and group mu cater and due date. (Remember your Orientation Activity?). 2. A section discussing the findings of each query. Include copies of the query results. This means you should: MGMT2006 Project $1:2020-2021PRE 1. MGMT2006_Software_Solution X + X O File | C:/Users/kimberly%20Arjoon/Desktop/MGMT2006%20-%20MANAGEMENT%20INFO%20SYSTEMS%201/CCou... @ Not syncing lookingGlass Secur.. PRE 70220038.pdf Other favorites 5 of 6 - + | A) Read aloud | Draw V Highlight V Erase MGMT2006 - Management Information Systems I Semester 1: 2020-2021 Course Project MGMT Software Solutions. DUE WEDNESDAY 11 November at MIDDAY - 20% CASE BACKGROUND MGMT Software Solutions (MSS) is a company that works with young clients to increase their popularity on various social networks. After all, likes and views can be a ticket to fame for elwillerTWITTER upcoming artists. That is, likes follow friends; retweets are the LikeSFACEBOOKLIKES CLOUDRETWEET social currency of the 21" century. MSS also negotiates to have PINTEREST computing ance their clients wear, advertise or use a product or a brand, or even interact with a celebrity to increase their online visibility. MGMT Software Solutions collects as much data as possible from its client's followers. This data is generated when a follower retweets, clicks "Like," or creates a comment thus creating a demographic profile of that follower. For example, MSS has clients Collins, Acadia, Julia and Tyler. When Collins' friends "like" his profile picture, Facebook tracks who his most popular friends and family are. Why? Those persons in turn 'like" products, services and celebrities - information that would be valuable to those advertisers. When Acadia "likes' dozens of brands on Facebook, those brands can learn more about potential customers - all of her friends. When Julia and her friends retweet news about The Hunger Games, or the Wedding Ringer, the movie studio is able to track those responses in real time. MGMT2006 Project $1:2020-2021