6. 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 helpful.) A PIVOT chart showing the results of Q2-Followers might be more effective. Create this chart with suitable labels in a MGMT2006_MSS_first name_last name.xlsx. spreadsheet 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 ii. query Q3-Brand. Produce a count of the brands this client's fans follow. 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'

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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: 

6.
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 helpful.)
A PIVOT chart showing the results of Q2-Followers might be more effective.
Create this chart with suitable labels in a
MGMT2006_MSS_first name_last name.xlsx.
spreadsheet
Transcribed Image Text:6. 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 helpful.) A PIVOT chart showing the results of Q2-Followers might be more effective. Create this chart with suitable labels in a MGMT2006_MSS_first name_last name.xlsx. spreadsheet
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
ii.
query Q3-Brand.
Produce a count of the brands this client's fans follow. 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'
Transcribed Image Text: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 ii. query Q3-Brand. Produce a count of the brands this client's fans follow. 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'
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education