ASSESSMENT BRIEF
Subject Code and Name ACCT6001 Accounting Information Systems
Assessment Assessment 4: Database Application – Case Study
Individual/Group Individual
Length 1500 words +/-10%
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.
Submission By 11:55pm AEST/AEDT Sunday week 12/ end of module 6.2
For intensive mode: By 11:55pm AEST/AEDT Sunday week 6/ end of module 6.2
Weighting 30%
Total Marks 100 marks
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
ACCT6001_Assessment Brief 4_Database Application_Due End of Module 6.2
Page 1 of 7

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.
Butler Financing Company Spreadsheet
Borrower No Last name First name Current address Requested mortgage amount Lender No Lender name Lender office address Property Appraiser No Property Appraiser Name
450 Adams Jennifer 4 Do Rd $245,000 13 Excel Mortgage 6 Shore Dr 8 Ad
Appraisers
451 Adamson David 5 So St $124,000 13 Excel Mortgage 6 Shore Dr 9 So
Appraisers
452 Bronson Paul 3 To Dr $345,000 14 CCY 2 Buck Rd 10 Jay
Appraisers
453 Brown Marietta 3 Go St $55,000 15 Advantage Lenders 3 Lake Dr 10 Jay
Appraisers
454 Charles Kenneth 7 Do Rd $25,000 16 Capital Savings 8 Coral Rd 8 Ad
Appraisers
455 Coulter Tracey 13 So St $216,350 13 Excel Mortgage 6 Shore Dr 8 Ad
Appraisers
456 Foster Harold 8 To Dr $115,000 12 National Mortgage 7 Ten St 9 So
Appraisers
ACCT6001_Assessment Brief 4_Database Application_Due End of Module 6.2
Page 2 of 7

457 Frank Vernon 14 Go St $90,000 12 National Mortgage 7 Ten St 10 Jay
Appraisers
458 Holmes Heather 9 Do Rd $450,000 16 Capital Savings 8 Coral Rd 10 Jay
Appraisers
459 Johanson Sandy 11 So St $70,000 15 Advantage Lenders 3 Lake Dr 9 So
Appraisers
460 Johnson James 12 To Dr $15,000 12 National Mortgage 7 Ten St 10 Jay
Appraisers
461 Jones Holly 5 Go St $65,000 15 Advantage Lender 3 Lake Dr 9 So
Appraisers
Please follow the rubrics below whilst working on your assignment.

ACCT6001_Assessment Brief 4_Database Application_Due End of Module 6.2
Page 3 of 7

Learning Rubric
Assessment Criteria
Fail
(Unacceptable)
0-49% Pass
(Functional)
50-64% Credit
(Proficient)
65-74% Distinction
(Advanced)
75 -84% High Distinction
(Exceptional)
85-100%
Need for the Unsatisfactory Satisfactory explanation Good explanation Very good explanation and Excellent explanation and
implementation of explanation provided is provided, several provided, several justification. Explanations justifications provided.
the database very general, lacks detail, does not answer justifications discussed, lack detailed explanation. justifications discussed. are convincing. Main problems are identified Main problems are identified and prioritised.
the question. Explanations are detailed but some are not convincing. and discussed in details. Provided some examples. Each problem is discussed in detail. Examples were provided for each problem.
15% Points 0-6 Points 7-9 Points 10-11 Points 12-13 Points 14-15
E-R Diagram E-R Diagram is E-R diagram is complete E-R diagram is E-R diagram is complete. E-R Diagram is complete.
incorrect. More than with some attributes and complete. All entities Identified entities were All entities, attributes and
50% of the entities, attributes and relationships incorrect. incorrect. Some entities identified are correct. Around 25% of the correct and complete. Attributes were correct relationships are identified correctly.
relationships identified wrongly identified. attributes and and complete. One or two
are incorrect. Around 50% of
attributes, relationships are missing or incorrect. relationships are missing or incorrect. relationships were missing or incorrect.
15% Points 0-6 Points 7-9 Points 10-11 Points 12-13 Points 14-15

.
Database Tables Database tables are Database table is Database table is Database table is Database table is complete.
incorrect and complete. All entities are complete. All entities complete. All entities are All entities are correctly
incomplete. E-R translated into tables. are translated into correctly and completely and completely translated
Diagram is not correctly Some attributes of the ER tables. Attributes are translated into tables. into tables. Attributes and
translated to database Diagram are not in the all present and Attributes and types of types of attributes are
tables. Majority of the table and types of relationships among attributes were correctly correctly identified. All
tables, attributes are attributes are incorrect. tables are established identified. All data in the data in the table are
missing. Not all entities Relationships are not (primary keys and table were entered. Most entered. All table
were translated into translated to tables foreign keys are table relationships are relationships are correct
tables. (primary keys and foreign mostly correct) All correct (primary keys and (primary and foreign keys
key are incorrect). Some data in the table were foreign keys and their and their relationships are
data in the table were entered. entered. Most of the attributes have correct types. relationship have been mostly correctly established). all correctly identified)
20% Points 0-9 Points -10-12 Points 13-15 Points 16-18 Points 19-20
Queries SQL queries and More than 50% of the More than 75% of the Almost all queries are All SQL queries are correct.
generated are mostly SQL queries are correct. SQL queries are correct (one or two Can generate complex
incorrect. Complex Complex queries are correct. Complex incorrect queries). Some queries.
queries are not answered incorrect. queries are mostly incorrect. complex queries were answered
Points 16-18
20%
Points 0-9 . Points -10-12 Points 13-15 Points 19-20
Forms and Reports Unsatisfactory forms. Satisfactory forms. Some Good forms. Most Very good forms. All Excellent form. All
Forms does not enter links to the tables are not data can be entered in elements of the forms are elements of the forms are
data. Reports are functioning. Some data the tables via forms. created. All data can be created. All data can be
mostly incorrect. No cannot be entered in the Some design were entered via forms. Design entered via forms.
report formatting used. tables via forms. Simple incorporated in the were incorporated in the Professional looking forms.
design incorporated in forms but not forms. Somewhat All of the reports are
the forms. Not professional looking. professional looking. correct Report formatting
professional looking. More than 50% of the reports are correct. No report formatting used. More than 75% of the reports are correct. Some report formatting used. Almost all of the reports are correct (one or two incorrect). Report formatting used. used extensively.
15% Points 0-6 Points 7-9 Points 10-11 Points 12-13 Points 14-15
IT security and Makes assertions about Some issues are justified Issues identified are Issues identified are Issues identified are
Privacy the database issues by arguments and not appropriate;points are appropriate. Arguments appropriate. Points are
given that are not merely assertions. presented to justify are presented to justify the presented to justify the
justified. the issues. Complexity of issues considered. Justifies any conclusions reached with arguments and not merely assertions. issues. Accurately takes into account the complexities of the issues. Other viewpoints were acknowledged. Justifies any conclusions reached with well-developed arguments and not merely assertions. 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 0-6 Points 7-9 Points 10-11 Points 12-13 Points 14-15
15% . .