Principles of Information Systems, Loose-Leaf Version
13th Edition
ISBN: 9781305971820
Author: Ralph Stair, George Reynolds
Publisher: Course Technology
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 5.4, Problem 1RQ
Explanation of Solution
Sources of data are used in Telefonica Brasil to perform customer churn analysis:
To perform customer churn analysis, the Telefonica Brasil might use the following sources of data:
- Telecom Brasil Company can use customer behavior data and customer demographic data such as age, income level, educational detail and employment status and so on...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Mr. Emmanuel Kwame Andoh wants to start a mobile money vending business with 6 branches across the country. He wants to be able to have information on all the transactions that happens in any of his branches. He describes a typical daily activity per a worker as follows:
A customer or a person walks in and requests to do either a withdrawal or a deposit. Then his worker would record the name and number of the person, the type of transaction and the amount involved in the transaction and the transaction reference number.
Mr. Andoh provided all the information above and more to a database designer who simply supplied just the SQL script that would implement the system. But the designer did not explain how the system would work to Mr. Andoh.
#below is the SQL Script: You can copy and paste to run
create database pharmacy;
use pharmacy;
create table branch(id int(3) not null auto_increment primary key, name varchar(50) not null);
create table transaction_type(id int(1) not null…
N26, a mobile bank, was founded in 2013 by Valentin Stalf and Maximilian Tayenthal. Since its launch, N26 has built a network of more than 5 mil- lion customers in 24 European countries. In 2019, N26 began operation in the United States in partnership with Axos Bank, and in 2020 it applied for a banking license in Brazil. In total, N26 has raised close to $800 million from investors and, with a market value of $3.5 billion as of May 2020, it is one of the most valuable and well-funded fintech startups in Europe.
Traditional banks typically employ a distributed IT landscape. Banks usually operate numerous self-developed software applications, but many of these are only partially adaptable to changing processes and needs. An online bank, however, has the scope to optimally design its IT landscape and customer inter- action processes based on current needs-such as compatibility with a mobile app-without having to take legacy systems into consideration. N26 is one of the few fintech banks…
computer networks
PT XYZ is a technology-based company that has been running for 5 years. In carrying out its activities, this company has 2 office buildings, namely the Main Building and Branch Building which is ± 10 km away. This company has employees with the following information:
Work location
Departemen
Number of Current Employees
Main Building
Finance
18
HR A
Addition of your 10 digit NIM *
Marketing & Sales A
100
IT Directorate
62
Procurement
Add the last 6 digits of your NIM
IT Consultant
5
Branch Building
HR B
10
IT Developer B
20
IT Support
Add the last 3 digits of your NIM
Marketing & Sales B
30
* Example:If your NIM is 1234567890 then,• The sum of 10 digits is 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 0 = 45• The sum of the last 6 digits is 5 + 6 + 7 + 8 + 9 + 0 = 35
You as a Computer Network Consultant, design a computer network for the company for the next 5 years if the number of employees is expected to increase 2.5 fold from…
Chapter 5 Solutions
Principles of Information Systems, Loose-Leaf Version
Ch. 5.1 - Prob. 1RQCh. 5.1 - Which attribute would you designate as the primary...Ch. 5.1 - Prob. 1CTQCh. 5.1 - Prob. 2CTQCh. 5.2 - Prob. 1RQCh. 5.2 - Prob. 2RQCh. 5.2 - Prob. 1CTQCh. 5.2 - Prob. 2CTQCh. 5.3 - Prob. 1RQCh. 5.3 - Prob. 2RQ
Ch. 5.3 - What additional questions need to be answered...Ch. 5.3 - Prob. 2CTQCh. 5.4 - Prob. 1RQCh. 5.4 - Telefonica Brasil is one of the largest...Ch. 5.4 - Prob. 1CTQCh. 5.4 - Prob. 2CTQCh. 5.5 - Prob. 1RQCh. 5.5 - Prob. 2RQCh. 5.5 - Why is it unlikely that a traditional SQL database...Ch. 5.5 - Prob. 2CTQCh. 5 - Prob. 1SATCh. 5 - Prob. 2SATCh. 5 - Prob. 3SATCh. 5 - The ______________ model is a simple but highly...Ch. 5 - The ability to combine two or more tables through...Ch. 5 - Prob. 6SATCh. 5 - Prob. 7SATCh. 5 - Prob. 8SATCh. 5 - Prob. 9SATCh. 5 - Prob. 10SATCh. 5 - Prob. 11SATCh. 5 - Prob. 12SATCh. 5 - Prob. 13SATCh. 5 - Prob. 14SATCh. 5 - Prob. 15SATCh. 5 - Prob. 16SATCh. 5 - Prob. 1RQCh. 5 - In the hierarchy of data, what is the difference...Ch. 5 - Prob. 3RQCh. 5 - What is meant by data archiving? Why is this an...Ch. 5 - What is an entity-relationship diagram, and what...Ch. 5 - Identify four basic data manipulations performed...Ch. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - Prob. 17RQCh. 5 - Prob. 1DQCh. 5 - Outline some specific steps an organization might...Ch. 5 - SQL databases conform to ACID properties. Briefly...Ch. 5 - Prob. 4DQCh. 5 - Prob. 6DQCh. 5 - Prob. 8DQCh. 5 - Prob. 1PSECh. 5 - Describe the role of a database administrator....Ch. 5 - Prob. 2CECh. 5 - Prob. 1CTQ1Ch. 5 - Prob. 2CTQ1Ch. 5 - Prob. 3CTQ1Ch. 5 - Prob. 1CTQ2Ch. 5 - Prob. 2CTQ2Ch. 5 - Prob. 3CTQ2
Knowledge Booster
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
- Wise Limited has an online platform for purchase and sale of goods and services which connects customers all around the world. It provides additional services of invoicing and data collation for sellers on the platform. Sellers process sales orders and transport the orders to the customers. Payment is made through the platform directly to the seller for which Wise limited collects a fee for invoicing services Further to the requirement of the Code of Corporate Governance Wise limited has decided to change its auditors after a period of 10 years. Your firm was approached and due process followed in the appointment of new Auditors including appropriate professional clearance. The audit is now set to commence. You are the Audit Manager responsible for this engagement but some of your Team members are not conversant with controls in on-line businesses. 1. On-line business makes use of electronic data interchange. Evaluate FOUR risks associated with the application of electronic data…arrow_forwardLinkedIn does not collect any financial information about its users. Why would hackers who are motivated by money steal data from LinkedIn? What kind of information do hackers seek?arrow_forward4. SA Paribahan Courier Track and Trace system delivers real-time shipment information to Web browsers on its customers' computers. This system shows the customer which freight carrier is transporting a shipment, where it is, and when it should arrive. Draw a data flow diagram of SA Paribahan online Track and Trace system.arrow_forward
- Small Potatoes is a family-operated seed business that has grown rapidly. It specializes in supplying home gardeners with the finest seeds and gardening supplies. Until now, the firm has done all its business by placing ads in gardening and health magazines and taking orders using a toll-free telephone number. Now, the family has decided to establish a website and sell online. Use this background to answer the following questions (each question should have a separate section denoted by a heading): What factors would you consider when deciding on the user interface design for the website? Create/Draw a rough prototype of what the user interface for the entry point (landing page) of what the Software would look like. Should the website be designed in-house, or outsourced - give your reasons for selecting one over the other.arrow_forwardMake an RFP (request for bids) for a new mobile buying system for KFC?arrow_forwardCourse: Management Information Systems 1 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 thecountry. Customers can opt to receive their bills either through the post or online but all payments are21stdue by the 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 beextracted for decision making. As a new employee of a team in the IS Department of this corporation, your manager wants you to produce some reports for him to review for the next quarter, such as which types of customers should be targeted for special offers and how much money is received for taxes.Reports reaching Executive management revealed that all of the…arrow_forward
- LinkedIn does not collect any information on the credit cards or other financial accounts that its users may have. Why would hackers who are motivated by profit therefore seek to steal the data that is saved on LinkedIn? In order to get their hands on the most valuable information, what type of data would hackers want the most?arrow_forwardWhat role does Amazon Web Services play in the Netflix information system?arrow_forwardAnswer only for (d)arrow_forward
- please draw the data flow diagram.arrow_forwardCASE STUDY: OMEGA WASTE MANAGEMENT LTD. Waste Management Ltd (OWM) is Zoomlion’s main competitor in waste management solutions in Ghana. OWM is in the business of collecting, transporting and disposing of waste materials (only solid and liquid waste, but no gas). Other services include the managing and monitoring of waste materials. OWM focuses on residential users and small commercial businesses and is in 6 of the regions of Ghana. The solid and liquid waste are residential; non-hazardous commercial and industrial waste. OmegaWaste Management Ltd is registered to dispose of or re-cycle the waste it collects in 10 Landfill sites; 3 glass and bottle collection depots; and 2 vegetation incinerator plants. Waste disposal at Landfill sites is common practice as this is a relatively inexpensive method of disposing of most waste materials. Incinerator plants is a controversial method of waste disposal and is relatively more expensive than Landfill even though it needs less space. The glass…arrow_forwardCASE STUDY: OMEGA WASTE MANAGEMENT LTD. Waste Management Ltd (OWM) is Zoomlion’s main competitor in waste management solutions in Ghana. OWM is in the business of collecting, transporting and disposing of waste materials (only solid and liquid waste, but no gas). Other services include the managing and monitoring of waste materials. OWM focuses on residential users and small commercial businesses and is in 6 of the regions of Ghana. The solid and liquid waste are residential; non-hazardous commercial and industrial waste. OmegaWaste Management Ltd is registered to dispose of or re-cycle the waste it collects in 10 Landfill sites; 3 glass and bottle collection depots; and 2 vegetation incinerator plants. Waste disposal at Landfill sites is common practice as this is a relatively inexpensive method of disposing of most waste materials. Incinerator plants is a controversial method of waste disposal and is relatively more expensive than Landfill even though it needs less space. The…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning