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 database tables for a regional bank. How might this data be aggregated and analyzed to create information and knowledge? Zip 60504 60543 CustomerID Name Address City State 100001 Don Baker 1215 E. New York Aurora IL 100002 Yuxiang Jiang 1230 Douglas Oswego IL Road 100003 Emily Brown 632 Fox Valley Aurora IL Road 100004 Mario Sanchez 24 E. Ogden Naperville IL Figure 7(a): Customers table 60504 60563 CustomerID Account Number Account Type Date Opened Balance 100001 4 875940 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 16700.00 100004 1890571 Savings 10/16/2007 5300.00 100004 8390126 Checking 12/02/2008 2700.00 Figure 7(b): Accounts table