Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
To vary your reporting, you decided to include graphical representation.  Create a clustered column chart that shows the total amount each active customer with a data plan must pay.  Format the total pay column to currency and give the chart an appropriate title.  Remember to label the axes.  (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_. For example, MGMT2006_G50_ Jane Doe.

To vary your reporting, you decided to include graphical representation.  Create a clustered column chart that shows the total amount each active customer with a data plan must pay.  Format the total pay column to currency and give the chart an appropriate title.  Remember to label the axes.  (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_. For example, MGMT2006_G50_ Jane Doe.

Database System Concepts
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
See similar textbooks
icon
Related questions
Question

To vary your reporting, you decided to include graphical representation.  Create a clustered column chart that shows the total amount each active customer with a data plan must pay.  Format the total pay column to currency and give the chart an appropriate title.  Remember to label the axes.  (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_<first name last name>. For example, MGMT2006_G50_ Jane Doe. 

CASE BACKGROUND MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis. Special discounts are given to customers for frequently using their pre- or post-paid mobile service. Customers can also sign up online or visit one of ten outlets stationed at various locations around the country. https://tinyurl.com/b2n62ymc Customers can opt to receive their bills either through the post or online but all payments are due by the 21st of each month. An 18.5% mobile tax is applied to the cost of all services. All transactions, customer calls and other data are captured in a database, where specific data can be extracted for decision making. The company wishes to determine the types of customers who should be granted special offers and the amount of money received for taxes. The manager of MMC hired you to work in the Information Systems Department to produce some reports for him to present at the meeting for the next quarter. He also wants you to focus mainly on the airtime usage to get a better understanding of the performance of the service. First, you need to peruse the database. It comprises the following tables: CUSTOMER: Persons who have an account with the company. SERVICE: The service offered to the customer is either PRE-PAID, POST-PAID, and the service comes with or without a DATA PLAN. CALL: The duration of calls by the customer for the month, and the amount of data used for the month. RATES: The rates for airtime usage, in cost per minute and the rates for data usage in cost per megabyte. You are asked to prepare several queries, as well as some reports.
Transcribed Image Text:CASE BACKGROUND MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis. Special discounts are given to customers for frequently using their pre- or post-paid mobile service. Customers can also sign up online or visit one of ten outlets stationed at various locations around the country. https://tinyurl.com/b2n62ymc Customers can opt to receive their bills either through the post or online but all payments are due by the 21st of each month. An 18.5% mobile tax is applied to the cost of all services. All transactions, customer calls and other data are captured in a database, where specific data can be extracted for decision making. The company wishes to determine the types of customers who should be granted special offers and the amount of money received for taxes. The manager of MMC hired you to work in the Information Systems Department to produce some reports for him to present at the meeting for the next quarter. He also wants you to focus mainly on the airtime usage to get a better understanding of the performance of the service. First, you need to peruse the database. It comprises the following tables: CUSTOMER: Persons who have an account with the company. SERVICE: The service offered to the customer is either PRE-PAID, POST-PAID, and the service comes with or without a DATA PLAN. CALL: The duration of calls by the customer for the month, and the amount of data used for the month. RATES: The rates for airtime usage, in cost per minute and the rates for data usage in cost per megabyte. You are asked to prepare several queries, as well as some reports.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Elements of Tables
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
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
SEE MORE TEXTBOOKS