[Authentic] ASSESSMENT BRIEF Subject Code and Name ACCT6001 Accounting Information Systems…

ASSESSMENT BRIEFSubject Code and Name ACCT6001 Accounting Information SystemsAssessment Assessment 4: Database Application – Case StudyIndividual/Group IndividualLength 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 intelligenceb) 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.2For intensive mode: By 11:55pm AEST/AEDT Sunday week 6/ end of module 6.2Weighting 30%Total Marks 100 marksContext: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 effectivelyACCT6001_Assessment Brief 4_Database Application_Due End of Module 6.2Page 1 of 7Instructions: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 loanYou are able to use MS Access to complete this assessment.Submission Instructions:· A word document containing:a) Introduction – a summary of the case studyb) Justification of the use of databasec) Database Design: E-R Diagramd) Microsoft Access files used in creating the tables, forms, queries and reportsCriteria:· Need for the implementation of the database· E-R Diagram· Normalised Database Tables· Queries· Forms and ReportsCase 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 SpreadsheetBorrower No Last name First name Current address Requested mortgage amount Lender No Lender name Lender office address Property Appraiser No Property Appraiser Name450 Adams Jennifer 4 Do Rd $245,000 13 Excel Mortgage 6 Shore Dr 8 AdAppraisers451 Adamson David 5 So St $124,000 13 Excel Mortgage 6 Shore Dr 9 SoAppraisers452 Bronson Paul 3 To Dr $345,000 14 CCY 2 Buck Rd 10 JayAppraisers453 Brown Marietta 3 Go St $55,000 15 Advantage Lenders 3 Lake Dr 10 JayAppraisers454 Charles Kenneth 7 Do Rd $25,000 16 Capital Savings 8 Coral Rd 8 AdAppraisers455 Coulter Tracey 13 So St $216,350 13 Excel Mortgage 6 Shore Dr 8 AdAppraisers456 Foster Harold 8 To Dr $115,000 12 National Mortgage 7 Ten St 9 SoAppraisersACCT6001_Assessment Brief 4_Database Application_Due End of Module 6.2Page 2 of 7457 Frank Vernon 14 Go St $90,000 12 National Mortgage 7 Ten St 10 JayAppraisers458 Holmes Heather 9 Do Rd $450,000 16 Capital Savings 8 Coral Rd 10 JayAppraisers459 Johanson Sandy 11 So St $70,000 15 Advantage Lenders 3 Lake Dr 9 SoAppraisers460 Johnson James 12 To Dr $15,000 12 National Mortgage 7 Ten St 10 JayAppraisers461 Jones Holly 5 Go St $65,000 15 Advantage Lender 3 Lake Dr 9 SoAppraisersPlease follow the rubrics below whilst working on your assignment.ACCT6001_Assessment Brief 4_Database Application_Due End of Module 6.2Page 3 of 7Learning RubricAssessment CriteriaFail(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 andimplementation 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-15E-R Diagram E-R Diagram is E-R diagram is complete E-R diagram is…

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA  PhD. Writers)


Source: Get Help

Posted in Uncategorized