Question: Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1 and

Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1 and Figure 2 (below) are two examples of database tables for a regional bank. How might this data be aggregated and analyzed to create information and knowledge?

CustomerID Name Address City State Zip

100001 Don Baker 1215 E. New York Aurora IL 60504

100002 Yuxiang Jiang 1230 Douglas Road Oswego IL 60543

100003 Emily Brown 632 Fox Valley Road Aurora IL 60504

100004 Mario Sanchez 24 E. Ogden Naperville IL 60563

Figure 1: Customers table

CustomerID AccountNumber AccountType DateOpened Balance

100001 4875940 Checking 10/19/1971 2500.00

100001 1660375 Savings 08/10/1973 1200.00

100002 1783032 Savings 05/15/1987 500.00

100002 4793289 Checking 05/15/1987 3200.00

100003 6213690 Checking 02/14/1996 6700.00

100004 1890571 Savings 10/16/2007 5300.00

100004 8390126 Checking 12/02/2008 2700.00

Figure 2: Accounts table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The data in these tables can be aggregated and analyzed in several meaningful ways to create valuable information and knowledge for the bank Heres how this could be done 1 Customer Insights and Segmen... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1-20 and Figure 1-21 (below) are two examples of...

Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1 and Figure 2 (below) are two examples of database...

7. Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1-20 and Figure 1-21 (below) are two examples of...

Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1 and Figure 2 (below) are two examples of database...

Consider the information that is maintained by a bank. In addition to customer records, the bank maintains records on accounts and loans. Figure 1-20 and Figure 1-21 (below) are two examples of...

1. Research has shown that the relationship between eye contact and deception a. is nonexistent b. is positive in that eye contact increases as the level of deception rises c. is negative in that eye...

Aside from cash balances, what other information is requested by an AICPA standard form to confirm account balance information with financial institutions (Figure 11-7)? Figure 11-7: Bank...

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

Discuss how does culture affect the fashion industry?

What is the conditional probability of high income, given never? VIEWING FREQUENCY Regular Occasional Never Totals HIGH INCOME 0.10 0.10 0.05 0.25 MIDDLE INCOME 0.15 0.20 0.05 0.40 Low INCOME 0.05...

A US investor that borrowed US dollar converted them to Brazilian real and invested in Brazilian real denominated bonds to take advantage of interest rate differentials. The US investor should _ _ _...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Nationwide Financial, a 5,000-employee life insurance company based in Columbus, Ohio, found that its management development program contained four types of managers. One type, unknown leaders, have...

You have been asked to evaluate whether your organizations current pay structure makes sense in view of what competing organizations are paying. How would you determine what organizations to compare...

The chapter-opening story described how employers are shifting more employee health care costs to employees. What are the likely consequences of this change? Where does the social responsibility of...