COMPREHENSIVE PROBLEM The Butler Financing Company runs a mortgage brokerage business that matches lenders and borrowers. Table 4-14 lists some of the data that Butler maintains on its borrowers and lend- ers. The data are stored in a spreadsheet that must be manually updated for each new borrower. lender or mortgage. This updating is error-prone, which has harmed the business. In addition, the spreadsheet has to be sorted in many different ways to retrieve the necessary data TABLE 4-14 Butler Financing Company Spreadsheet BOR REQUESTED LENDER ROWER LAST FIRST CURRENT MORTGAGE LENDER LENDER OFFICE NUMBER NAME NAME ADDRESS AMOUNT NUMBER NAME ADDRESS 450 Adams Jennifer 450 Peachtree $245,000 13 Excel 6890 Sheri Rd Mortgage dan Dr. 451 Adamson David 500 Loop $124.688 13 Excel 6890 Sheri Highway Mortgage can Di 452 Bronson Paul 312 Mountain $345,000 14 CCY 28 Buck View De head Way 453 Brown Marietta 310 Loop $57,090 15 Advantage 3345 Lake Highway Lenders Shore De 454 Charles Kenneth 3 Commons $34.000 16 Capital 8890 Coral Blvd Savings Blvd 455 Coulter Tracey 1367 $216,505 13 Excel 6890 Sheri Peachtree Mortgage dan De Rd 456 Foster Harold 678 Loop 5117.090 12 National 750 16 St Highway Mortgage PROPERTY PROPERTY APPRAISER APPRAISER NUMBER NAME Advent Appraisers 9 Independent Appraisal Service 10 Jones Property Appraisers 10 Jones Property Appraisers Advent Appraisers 8 Advent Appraisers 9 457 12 10 458 16 10 Frank Vernon 210 Bicayne $89,000 Blvd Holmes Heather 1121 Bicayne $459,010 Blvd Johanson Sandy 817 Mountain $67.900 View Dr. National 750 16 St Mortgage Capital 8890 Coral Savings Blvd. Advantage 3345 Lake Lenders Shore De 459 15 Independent Appraisal Service Jones Property Appraisers Jones Property Appraisers Independent Appraisal Service Jones Property Appraisers Independent Appraisal Service 460 Johnson James 12 10 National 750 16 St. Mortgage Advantage 3345 Lake Lenders Shore D 461 Jones 985 Loop $12,000 Highway 1650 Wash $67,890 ington Blvd Holly 15 9 Requirements: 1. Create a database from Butler's spreadsheet that does not have any of the data anomalies explained in class discussions. To test the database, prepare a query to show which borrowers (both borrower number and name) took out loans from Excel Mortgage and who the appraiser was for each loan. COMPREHENSIVE PROBLEM The Butler Financing Company runs a mortgage brokerage business that matches lenders and borrowers. Table 4-14 lists some of the data that Butler maintains on its borrowers and lend- ers. The data are stored in a spreadsheet that must be manually updated for each new borrower. lender or mortgage. This updating is error-prone, which has harmed the business. In addition, the spreadsheet has to be sorted in many different ways to retrieve the necessary data TABLE 4-14 Butler Financing Company Spreadsheet BOR REQUESTED LENDER ROWER LAST FIRST CURRENT MORTGAGE LENDER LENDER OFFICE NUMBER NAME NAME ADDRESS AMOUNT NUMBER NAME ADDRESS 450 Adams Jennifer 450 Peachtree $245,000 13 Excel 6890 Sheri Rd Mortgage dan Dr. 451 Adamson David 500 Loop $124.688 13 Excel 6890 Sheri Highway Mortgage can Di 452 Bronson Paul 312 Mountain $345,000 14 CCY 28 Buck View De head Way 453 Brown Marietta 310 Loop $57,090 15 Advantage 3345 Lake Highway Lenders Shore De 454 Charles Kenneth 3 Commons $34.000 16 Capital 8890 Coral Blvd Savings Blvd 455 Coulter Tracey 1367 $216,505 13 Excel 6890 Sheri Peachtree Mortgage dan De Rd 456 Foster Harold 678 Loop 5117.090 12 National 750 16 St Highway Mortgage PROPERTY PROPERTY APPRAISER APPRAISER NUMBER NAME Advent Appraisers 9 Independent Appraisal Service 10 Jones Property Appraisers 10 Jones Property Appraisers Advent Appraisers 8 Advent Appraisers 9 457 12 10 458 16 10 Frank Vernon 210 Bicayne $89,000 Blvd Holmes Heather 1121 Bicayne $459,010 Blvd Johanson Sandy 817 Mountain $67.900 View Dr. National 750 16 St Mortgage Capital 8890 Coral Savings Blvd. Advantage 3345 Lake Lenders Shore De 459 15 Independent Appraisal Service Jones Property Appraisers Jones Property Appraisers Independent Appraisal Service Jones Property Appraisers Independent Appraisal Service 460 Johnson James 12 10 National 750 16 St. Mortgage Advantage 3345 Lake Lenders Shore D 461 Jones 985 Loop $12,000 Highway 1650 Wash $67,890 ington Blvd Holly 15 9 Requirements: 1. Create a database from Butler's spreadsheet that does not have any of the data anomalies explained in class discussions. To test the database, prepare a query to show which borrowers (both borrower number and name) took out loans from Excel Mortgage and who the appraiser was for each loan