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. 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. RATE
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. 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.
Add TWO new Customers and associate them with a Service. Also add TEN new Calls along with their information for any ten customers. Be sure to include calls for your two additional customers.
![Home
O Tell me what you w
File
Create
External Data
Database Tools
Fields
Table
X Cut
a Copy
Format Painter
21 Ascending
Selection -
New
ΣΤotals
ZI Descending
Filter
Save
יריןס
ABC
|Advanced -
Spellin
View
Paste
Refresh
A Remove Sort Y Toggle Filter
All - X Delete
More
Views
Clipboard
Sort & Filter
Records
E Relationships
ID
CALL
All Access ... O
CUSTOMER
RATES
SERVICE
CUSTNUM
Duration
Click to Add
Tables
65 006-72-1607
84.46
CALL
66 011-54-9127
30.40
CUSTOMER
67 012-34-1417
78.03
68 013-60-6314
2.04
RATES
69 014-38-8325
9.08
70 014-58-8653
10.25
SERVICE
71 014-62-7111
18.36
72 000-10-9999
0.00
73 008-72-1958
0.00
74 009-32-2470
0.00
75 009-58-1690
0.00
76 011-32-1378
0.00
77 011-42-1171
0.00
78 015-54-8777
0.00
79 015-64-5756
0.00
80 019-58-3262
0.00
81 020-56-3206
0.00
82 021-50-0385
0.00
83 021-56-6761
0.00
84 025-54-0259
0.00
85 123-45-6789
12.23
86 020-56-3206
23.00
87 222-55-0987
101.00
88 222-55-0987
3.00
89 222-55-0987
45.80
90 011-42-1171
23.80
91 015-54-8777
23.00
92 015-54-8777
23.00
93 004-68-7501
23.00
94 006-62-4185
4.56
米
(New)
11 of 94
Record: 4
No Filter
Search](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fad0ebfe9-34e5-496e-87e2-1620f8a73549%2F88ff4736-c950-4d63-8913-881b66c8915d%2F683rq9o_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)