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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images