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

Internal Code: 1AGHBF Code: ACCT6001

Accounting Database Application Case Study Assessment Answer

Assignment Task: ACCT6001 This assessment addresses the following subject learning outcomes: a) Explain the characteristics of relational databases and their role in the 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. Context: ACCT6001 The aim of this assessment is to assess the student’s ability to solve business problems using database design tool and software. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report. Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An understanding of technology allows business professionals to be able to perform their work effectively. Instructions: ACCT6001 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 You are able to use MS Access to complete this assessment. Case Study: ACCT6001 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 ACCT6001: 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.