1. Create a database from Butler’s spreadsheet that does not have any of the data anomalies. 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. 2. Identify the Primary and Foreign Keys in each of the tables you have created 3. Identify the relationships among the tables4. From the database you have created in MS Access, perform the following queries a) Which borrowers use Advent Appraisers? b) What is the average amount borrowed from National Mortgage? c) List all of the property appraisers. d) List all of the lenders. e) List the lenders that lent more than $100,000. f) Which borrower requested the largest mortgage? g) Which borrower requested the smallest mortgage?

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Related Model Questions

Feel free to peruse our college and university model questions. If any our our assignment tasks interests you, click to place your order. Every paper is written by our professional essay writers from scratch to avoid plagiarism. We guarantee highest quality of work besides delivering your paper on time.

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!