Please help!!!

CHAPTER 4 RELATIONAL DATABASES 129 The constraint that all foreign keys must have either nall values or the value of a primary key in another table is referred to as which of the following a referential integrity nale b entity integrity rule Which of the following is not a basic requirement of a relational database? a. Primary keys cannot be null. b. Every column in a row must be single d. All non-key attribotes in a table must c. foreign key valoe rule d. null value rule 0. c. Foreign keys cannot be nall. describe a characteristic of the object identified by the primary key. COMPREHENSIVE PROBLEM The Butler Financing Company runs a mortgage brokerage basiness 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 In addition, the spreadsheet has to be sorted in many different ways to retrieve the data. lender, or mortgage. This updating is error-prone, which has harmed the business necessary Butler Financing Company Spreadsheet TABLE 4-14 BOR ROWER LAST FIRST CURRENT MORTGAGE LENDER LENDER OFFICE APPRAISER PROPERTY NUMBER NAME NAME ADDRESS AMOUNT NUMBER NAME ADDRESS NUMBER APPRAISER NAME REQUESTED LENDER PROPERTY 450 Adams Jennifer 450 Peachtree $245,000 13 Excel6890 451 Adamson David 500 Loop $124,68813Excel6890 Sheridan9 Independent Ap 4S2 Bronson 453 Brown Marietta 310 Loop $57,090 15 Advantage 3345 Lake10 Jones Property 454 Charles Kenneth 3 Commons$34,000 6 Capital 8890 Coral 8 Advent Appraisers Rd. Highway View Dr Mortgage Sheridan Dr praisal Service 10Jones Property Mortgage Dr 28 Buckhead Paul 312 Mountain $345,000 14 CCY Lenders Shore Dr Savings Blvd Morngage Sheridan D. 8 Advent Appraisers 8 Advent Appraisers 9 Independent Ap 10 Jones Property 5216,505 13 Eetexo 13 Excel 6890 455 Coulter Tracey 1367 Rd 12 National 750 16 St 56 Foster Harold 678 Loop $117,090 praisal Service 210 Bicayne $89,000 12 National 750 16 St Frank Vernon Blvd Blvd. View Dr Highway ington Blvd. 458 Holmes Heather 1121 Bicayne $459,010 16 Capital 8890 Coral 10 Jos 459 Johanson Sandy 817 Mountain $67,900 15 Advantage 3345 Lake 460 Johnson James 985 Loop 461 Jones Holly 1650 Wash $67,890 15 Advantage 3345 Lake Savings Blvd Independent Ap- praisal Service Jones Property LendersShore Dr 10 12,000 12 National 750 16 5t 9 Independent Ap- praisal Service Shore Dr Lenders I CONCEPTUAL FOUNDATIONS OF ACCOUNTING INFORMATION SYSTEMS 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. CHAPTER 4 RELATIONAL DATABASES 129 The constraint that all foreign keys must have either nall values or the value of a primary key in another table is referred to as which of the following a referential integrity nale b entity integrity rule Which of the following is not a basic requirement of a relational database? a. Primary keys cannot be null. b. Every column in a row must be single d. All non-key attribotes in a table must c. foreign key valoe rule d. null value rule 0. c. Foreign keys cannot be nall. describe a characteristic of the object identified by the primary key. COMPREHENSIVE PROBLEM The Butler Financing Company runs a mortgage brokerage basiness 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 In addition, the spreadsheet has to be sorted in many different ways to retrieve the data. lender, or mortgage. This updating is error-prone, which has harmed the business necessary Butler Financing Company Spreadsheet TABLE 4-14 BOR ROWER LAST FIRST CURRENT MORTGAGE LENDER LENDER OFFICE APPRAISER PROPERTY NUMBER NAME NAME ADDRESS AMOUNT NUMBER NAME ADDRESS NUMBER APPRAISER NAME REQUESTED LENDER PROPERTY 450 Adams Jennifer 450 Peachtree $245,000 13 Excel6890 451 Adamson David 500 Loop $124,68813Excel6890 Sheridan9 Independent Ap 4S2 Bronson 453 Brown Marietta 310 Loop $57,090 15 Advantage 3345 Lake10 Jones Property 454 Charles Kenneth 3 Commons$34,000 6 Capital 8890 Coral 8 Advent Appraisers Rd. Highway View Dr Mortgage Sheridan Dr praisal Service 10Jones Property Mortgage Dr 28 Buckhead Paul 312 Mountain $345,000 14 CCY Lenders Shore Dr Savings Blvd Morngage Sheridan D. 8 Advent Appraisers 8 Advent Appraisers 9 Independent Ap 10 Jones Property 5216,505 13 Eetexo 13 Excel 6890 455 Coulter Tracey 1367 Rd 12 National 750 16 St 56 Foster Harold 678 Loop $117,090 praisal Service 210 Bicayne $89,000 12 National 750 16 St Frank Vernon Blvd Blvd. View Dr Highway ington Blvd. 458 Holmes Heather 1121 Bicayne $459,010 16 Capital 8890 Coral 10 Jos 459 Johanson Sandy 817 Mountain $67,900 15 Advantage 3345 Lake 460 Johnson James 985 Loop 461 Jones Holly 1650 Wash $67,890 15 Advantage 3345 Lake Savings Blvd Independent Ap- praisal Service Jones Property LendersShore Dr 10 12,000 12 National 750 16 5t 9 Independent Ap- praisal Service Shore Dr Lenders I CONCEPTUAL FOUNDATIONS OF ACCOUNTING INFORMATION SYSTEMS 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