ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 6 ASSESSMENT BRIEF Subject Code and Title ACCT6001 Accounting Information Systems Assessment Assessment 4: Database Application...

I have attached the assessment brief . thanks


ACCT6001 Assessment 4 – Database Application Page 1 of 6 ASSESSMENT BRIEF Subject Code and Title ACCT6001 Accounting Information Systems Assessment Assessment 4: Database Application Individual/Group Individual Length 1500 words +/-10% Learning Outcomes b) Explain the characteristics of relational databases and their role in creation and communication of business intelligence. c) Identify and assess IT controls, auditing, ethical, privacy and security issues with respect to information. d) Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases. e) Communicate with IT professionals, stakeholders and user groups of information systems. Submission By 11:55pm AEST/AEDT Sunday end of module 6.2 (week 12) 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 4 – Database Application Page 2 of 6 Instructions: Students are expected to develop a database given the organisational brief that will be provided to you. Students need to design and implement the database using Microsoft Access or LibreBase. The following are the list of requirements: • Explain why the organisation needs to use a database. • Create an E-R Diagram using Diagram Editor • Convert the E-R diagrams to tables • Create database tables • Create queries and forms • Identify IT controls needed and ethical, privacy and security issues the organisation might encounter when using databases. Outcome to be submitted: 1) 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) Analysis of the database 2) Database files used in creating the tables, forms, queries and reports Criteria • Need for the implementation of the database • E-R Diagram • Queries • Forms and Reports • Database Analysis ACCT6001 Assessment 3- Excel Spreadsheet Page 3 of 6 Learning Rubrics Assessment Attributes Fail (Unacceptable) Pass (Functional) Credit (Proficient) Distinction (Advanced) High Distinction (Exceptional) Points Need for the implementation of the database 15%% Unsatisfactory explanation provided is very general, lacks detail, does not answer the question. Points 0-6 Satisfactory explanation provided, several justifications discussed, lack detailed explanation. Points 7-9 Good explanation provided, several justifications discussed. Explanations are detailed but some are not convincing. Points 10-11 Very good explanation and justification. Explanations are convincing. Main problems are identified and discussed in details. Provided some examples. Points 12-13 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 incorrect. More than 50% of the entities, attributes and relationships identified are incorrect. Points 0-6 E-R diagram is complete but some attributes and relationships are incorrect. Some entities identified should not be an entity. Around 50% of attributes are missing (or incorrect) and incorrect relationships are identified. Points 7-9 E-R diagram is complete. All entities identified are correct. Around 25% of the attributes and relationships are missing or incorrect. Points 10-11 E-R diagram is complete. Identified entities were correct and complete. Attributes were correct and complete. One or two relationships were missing (or incorrect) Points 12-13 E-R Diagram is complete. All entities, attributes and relationships are identified correctly. Points 14-15 ACCT6001 Assessment 3- Excel Spreadsheet Page 4 of 6 Database Tables 20% Database tables are incorrect and incomplete. E-R Diagram is not correctly translated to database tables. Majority of the tables, attributes are missing. Not all entities were translated into tables. Points 0-9 Database table is complete. All entities are translated into tables. Some attributes of the E- R Diagram are not in the table and types of attributes are incorrect. Relationships are not translated to tables (primary keys and foreign key are incorrect). Some data in the table were entered. Points -10-12 Database table is complete. All entities are translated into tables. Attributes are all present and relationships among tables are established (primary keys and foreign keys are mostly correct) All data in the table were entered. Most of the attributes have correct types. Points 13-15 Database table is complete. All entities are correctly and completely translated into tables. Attributes and types of attributes were correctly identified. All data in the table were entered. Most table relationships are correct (primary keys and foreign keys and their relationship have been mostly correctly established). Points 16-18 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 ACCT6001 Assessment 3- Excel Spreadsheet Page 5 of 6 Queries 20% SQL queries and generated are mostly incorrect. Complex queries are not answered Points 0-9 More than 50% of the SQL queries are correct. Complex queries are incorrect. Points -10-12 More than 75% of the SQL queries are correct. Complex queries are mostly incorrect. Points 13-15 Almost all queries are correct (one or two incorrect queries). Some complex queries were answered. Points 16-18 All SQL queries are correct. Can generate complex queries. Points 19-20 Forms and Reports 15% Unsatisfactory forms. Forms does not enter data. Reports are mostly incorrect. No report formatting used. Points 0-6 Satisfactory forms. Some links to the tables are not functioning. Some data cannot be entered in the tables via forms. Simple design incorporated in the forms. Not professional looking. More than 50% of the reports are correct. No report formatting used. Points 7-9 Good forms. Most data can be entered in the tables via forms. Some design were incorporated in the forms but not professional looking. More than 75% of the reports are correct. Some report formatting used. Points 10-11 Very good forms. All elements of the forms are created. All data can be entered via forms. Design were incorporated in the forms. Somewhat professional looking. Almost all of the reports are correct (one or two incorrect). Report formatting used. Points 12-13 Excellent form. All elements