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
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