Explain the characteristics of relational databases

Assignment Help Database Management System

Reference no: EM132301536

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

Reference no: EM132301536

Questions Cloud

Compute the time interval between their passing : Two particles are projected from a point at the same instant with velocities. The time interval between their passing through the other common points

Create spreadsheets that can aid business problem solving : Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases - Communicate with IT professionals

Emergency department based on system archetypes : MGT603: Systems Thinking - Laureate International Universities - Analyse, select and apply systems modelling tools in integrating, optimising and enhancing

Draw dependency diagram to show the functional dependencies : Using the above table - Draw a dependency diagram to show the functional dependencies in the relation. Decompose the relation into a set of 3NF relations

Explain the characteristics of relational databases : Accounting Information Systems - Database Application - Case Study - Explain the characteristics of relational databases and their role in creation

Create a cost-benefit analysis of the proposed new system : ACCT6001 - Accounting Information Systems - Laureate International Universities - Assessment Case Study – Excel-based - create a cost-benefit analysis

Explore the distinction between individuals in crisis : You will explore distinct interview approaches for each of these situations and consider why these approaches would be appropriate

Write a position paper on american history to the civil war : Students must write a position paper focusing on a controversial and/or important topic related to American history to the Civil War.

Evaluate how the leadership abilities and style hindered : Examine at least ten of the themes within the context of the documentary and tie them to the leadership of UNIA by Marcus Garvey. Evaluate how his leadership.

User Account

All Pages