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

Data from Table 4-14

Create a database from Butler’s spreadsheet that does not have any of the data anomalies explained in this chapter. 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.

Transcribed Image Text:

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