Reference no: EM132301360

Accounting Information Systems Assignment - Database Application - Case Study

Learning Outcomes - This assessment addresses the following subject learning outcomes:

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.

Context: 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 this technology allows business professionals to be able to perform their work effectively

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 You are able to use MS Access to complete this assessment.

Submission Instructions: A word document containing:

a) Introduction - a summary of the case study

b) Justification of the use of database

c) Database Design: E-R Diagram

d) Microsoft Access files used in creating the tables, forms, queries and reports

Criteria:

• Need for the implementation of the database
• E-R Diagram
• Normalised Database Tables
• Queries
• Forms and Reports

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.

Attachment:- Assignment File.rar