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 upcoming artists. That is, they want to follow friends; retweets are the social currency of the 21st century. MSS also negotiates to have its clients wear, advertise, use a product or brand, or even interact with a celebrity to increase their online visibility. MGMT Software Solutions collects as much data as possible from its clients' 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 famous friends and family are. Why? Those persons, in turn, ‘like’ products, services, and celebrities— information 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 can track their responses in real-time. When Tyler searches YouTube, Google (which 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 analyze 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 client contracts 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
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 upcoming artists. That is, they want to follow friends; retweets are the social currency of the 21st century. MSS also negotiates to have its clients wear, advertise, use a product or brand, or even interact with a celebrity to increase their online visibility. MGMT Software Solutions collects as much data as possible from its clients' 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 famous friends and family are. Why? Those persons, in turn, ‘like’ products, services, and celebrities— information 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 can track their responses in real-time. When Tyler searches YouTube, Google (which 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 analyze 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
Step by step
Solved in 2 steps
