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 REQUESTED MORTGAGE LENDER LENDER AMOUNT NUMBER NAME $245,000 13 Excel $124,688 BOR- ROWER LAST FIRST CURRENT NUMBER NAME NAME ADDRESS 450 Adams Jennifer 450 Peachtree Rd. 451 452 453 454 455 456 457 458 459 460 461 Adamson David Bronson Paul Brown Foster Frank Marietta 310 Loop Highway Charles Kenneth 3 Commons Blvd. Coulter Tracey 1367 500 Loop Jones Highway Johnson James 312 Mountain $345,000 View Dr. Harold 678 Loop Highway Holly Peachtree Rd. Vernon 210 Bicayne Blvd. 1121 Bicayne Blvd. Holmes Heather Johanson Sandy 817 Mountain View Dr. 985 Loop Highway 1650 Wash ington Blvd. $57,090 $34,000 $216,505 $117,090 $89,000 $459,010 $67,900 $12,000 $67,890 13 14 15 16 13 12 12 16 15 12 15 Mortgage Excel Mortgage CCY Advantage Lenders Capital Savings Excel Mortgage National Mortgage National Mortgage Capital Savings Advantage Lenders LENDER OFFICE ADDRESS 6890 Sheri- dan Dr. 6890 Sheri dan Dr. 28 Buck- head Way 3345 Lake Shore Dr. 8890 Coral Blvd. 6890 Sheri- dan Dr. 750 16 St. 750 16 St. 8890 Coral Blvd. 3345 Lake Shore Dr. National 750 16 St. Mortgage Advantage 3345 Lake Lenders Shore Dr. PROPERTY PROPERTY APPRAISER APPRAISER NUMBER NAME 8 Advent 9 10 10 8 8 10 10 9 10 9 Appraisers Independent Appraisal Service Jones Property Appraisers Jones Property Appraisers Advent Appraisers Advent Appraisers Independent Appraisal Service Jones Property Appraisers Jones Property Appraisers Independent Appraisal Service Jones Property Appraisers Independent Appraisal Service 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.