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