Question 1

The Butler Financing Company runs a mortgage brokerage business that matches lenders and borrowers. Table 4-16 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.

Create a database from Butlers 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 and appraisers are associated with loans from Excel Mortgage.

Tabla A Ac