ACCT6001: Accounting Information Systems - Database Application Case Study Assessment Answer

Subject Code: ACCT6001 Internal Code:1AGFGA

Database Application Case Study Assessment Answer

TASK: a) Explain the characteristics of relational databases and their role in creation and communication of business intelligence b) Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases. c) Communicate with IT professionals, stakeholders and user groups of information systems. Instructions: Create a database from Butler’s spreadsheet that does not have any data anomalies. Use appropriate E-R diagrams to explain the relationships. To test the database, you can create 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. Case Study: The Butler Financing com[any runs a mortgage brokerage business that matches lenders and borrowers. The table below 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.

This Accounting Assessment has been solved by our Accounting experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.