Consider the information that is maintained by a bank. In addition to customer records, the bank mai

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 database tables for a regional bank. How might this data be aggregated and analyzed to create information and knowledge?

CustomerID

Name

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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-20: 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 1-21: Accounts table

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code FREE15

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.