User Account

All Pages

Create a database from Butler spreadsheet

Assignment Help Database Management System
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

Verified Expert

The solution file is prepared in ms word and database created in ms access which discussed about the Butler Financing company case study.IT runs a mortgage brokerage business that matches lenders and borrowers.This company maintain a table which has all details about borrowers, lenders.This business required to sort spread sheet in various ways to retrieve the required data as per business need.This report, discussed about the use of Butler Financing company database, entity relationship diagram, in Ms access create tables,forms, queries and reports for business.The solution has 1500 words and references are included as per APA format.

Reference no: EM132301360

Questions Cloud

Contribute to how we make decisions about it security : Discuss what external factors contribute to how we make decisions about IT security and what measures need to be taken to stay updated on these external factors
Optimal quantity per order based on the total annual cost : What is the optimal quantity per order based on the total annual cost (composed of the holding cost and ordering cost and the acquisition cost)?
Which people accept as normal unequal distribution : The extent to which people accept as normal an unequal distribution of power is known as what?
What are the outcomes of the strategies : In addition to the presentation, you will have to submit an individual essay regarding your case analysis. This project is designed to be a term paper.
Create a database from Butler spreadsheet : ACCT6001 Accounting Information Systems Assignment - Database Application - Case Study, Laureate International Universities, Australia. Create a database
What is the reorder point and what is inventory position : What is the reorder point and what is the inventory position immediately after the order is placed?
How your approach to leadership has been impacted : How your approach to leadership has been impacted through your personal self-awareness. Also share if the impact is a result of the course.
Factors that increase group cohesiveness : Factors that increase group cohesiveness include all of the following EXCEPT:
How organizational design linked to organizational behavior : Part 1: (Respond in 150 words or more). Discuss the elements of organizational designs and how organizational design is linked to organizational behavior.

Reviews

len2301360

5/8/2019 2:27:27 AM

Length - 1500 words +/-10%. Need for the implementation of the database 15% - Excellent explanation and justifications provided. Main problems are identified and prioritised. Each problem is discussed in detail. Examples were provided for each problem. Points 14-15. E-R Diagram 15% - E-R Diagram is complete. All entities, attributes and relationships are identified correctly. Points 14-15. Database Tables 20% - Database table is complete. All entities are correctly and completely translated into tables. Attributes and types of attributes are correctly identified. All data in the table are entered. All table relationships are correct (primary and foreign keys and their relationships are all correctly identified) Points 19-20.

len2301360

5/8/2019 2:27:23 AM

Queries 20% - All SQL queries are correct. Can generate complex queries. Points 19-20. Forms and Reports 15% - Excellent form. All elements of the forms are created. All data can be entered via forms. Professional looking forms. All of the reports are correct Report formatting used extensively. Points 14-15. IT security and Privacy 15% - Issues identified are appropriate. Points are presented to justify the issues. Complexity of issues considered with examples. Other viewpoints acknowledged. Justifies any conclusions reached with well-developed , well articulated arguments substantiated by research and not merely assertions. Points 14-15.

Write a Review

Database Management System Questions & Answers

  Dml triggers can be defined for a combination of dml

Normal 0 false false false EN-US X-NONE X-NONE DML triggers can be defined fo..

  Develop a physical plan for data organization and storage

Develop a physical plan for data organization, storage, updating, and retrieval. Estimating completion time and costs.

  Calculate the average price for books that have the type art

Calculate the average price for books that have the type ART.

  Add a validation rule for date of birth

Make an Update Query that will add the phrase "Free Champagne for this Preferred Guest" to the Comments field, but only if the guest stays for 8 days or more.

  Write a reflective essay regarding the systems development

Write a reflective essay regarding the systems development environment and the sources of software. This assignment covers Course Objective 5.

  Design a database for the scenario

CSG1207 - CSI5135 Systems and Database Design - Your first task is to design a database for the scenario detailed on the following pages. Your final database design should comprise of approximately 10 entities.

  Detail the functional requirements for the system

An operation specification for the most important single interaction between user and system during the critical core use case's normal flow.

  Describe the skills involved in design of unstructured data

Describe the skills involved in the design of unstructured data warehouses that are different than developing a multiple dimension model.

  Define the user requirements for a database

What actions would you take to ensure that the student reporting needs and data privacy concerns of the students are fully identified?

  Each technician is an expert on one or more plane model

Each technician is an expert on one or more plane model(s), and his or her exper-tise may overlap with that of other technicians. This information about technicians must also be recorded.

  What is the purpose of database

In order to design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database, and how it will be organized. There are several approaches to creating a success..

  Elaborate further on the definition of information systems

Review some of the tools you use whether at home or school that helps turn the data we are exposed to into information for making decisions.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd