Accounting information system
ACCT6001 Assessment 4 – Database Application Page 1 of 9 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 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 4 – Database Application Page 2 of 9 ASSESSMENT 4 Database Application Case Study CASE STUDY Background of Torrens We Help Inc. Torrens We Help Inc (TWHI) is a not-for-profit private education organisation. It provides online education in farming anywhere in the world. The majority of their students are from outback areas of Indonesia, Papua New Guinea and Vietnam. TWHI wants to engage and work in partnership with communities, industries and businesses. It seeks to provide multiple learning experiences and opportunities to enrich the learning journey of its students. TWHI prides itself on being an inclusive provider, offering higher education to people who might not otherwise have the opportunity to experience it. To this end many of its students have their fees paid partially or fully by the Indonesian, Papua New Guinean and Vietnamese government. One of their projects is called Project "HR DATABASE". The following are the stages: Stage 1: Develop HR Database System for the Academic Staff Stage 2: Extend the Database system to include administrative Staff Stage 3: Develop a Partners database You have been assigned to develop part of the stage 1 of the project. Project Description: TWHI has used a spreadsheet software to maintain and monitor its employee information. Its human resource (HR) department is currently struggling get the updated information of its entire academic and administrative staff. The HR manager maintains the following spreadsheets for the academic staff: • Employee information (Employee ID, Title, First Name, Middle Name, Last Name, Birthdate, Street Address, City, State, Postal Code, Phone Number, Mobile Number, Date Hired, Date Terminated, TFN, Department, Location) • Timesheet for academic staff (Employee ID, hours worked per week, type of work, (e.g., online facilitation, assessment marking, consultation), hourly rate, subject code, number of students) • List of subjects that teaching staff is approved to teach (Subject Code, Employee ID, Subject Name) ACCT6001 Assessment 4 – Database Application Page 3 of 9 • Information about the teaching staff (name, location, contact details, status (part-time, full-time, sessional) • Class details (Class code, class name, semester offered ,year offered) You are expected to develop the initial database for the ACADEMIC STAFF of TWHI Human Resource. You need to design and implement the database using Microsoft Access or LibreOfficeBase. In this project, you are required to design the database and develop the database for storing and retrieving information about the TWHI Academic Staff. You need to create tables, queries, reports and forms. The following are some of the requirements for TWHI HR: 1. Forms: a. HR Manager should have the form to enter the information about TWHI’s employees b. HR Manager should have the form to enter information about the allocation of subject per Academic Staff 2. Reports: a. HR Manager wants to see the following reports: • List of all Employees and their contact details (sorted by Last Name, then First Name) • List and total number of all full-time Academic Staff and their location • List of classes all Academic Staff are teaching in semester 2. • List the names of all employees and how long they have worked for TWHI 3. Tables: a. In order for you to create the forms and required reports, you must first create tables that will store all the data about the Academic Staff. b. The following are the activities you expected to do: • create the database tables • add at least 10 different data per table ACCT6001 Assessment 4 – Database Application Page 4 of 9 4. E-R Diagram a. To help HR Manager understand the database design ADDITIONAL INFORMATION: The following are some of the guidelines followed by the HR Manager: • The teaching staff can teach different subjects. The HR manager has to monitor distribution of teaching load. It is possible that several teaching staff will teach the same subject depending on the number of students enrolled. Because of this, each subject is also assigned to a class. • Please take note of the following when entering data: o Currently all employees are in the Business Department o Start by entering data in the Employee table o An Academic Staff is an Employee therefore the Academic Staff - Employee ID should exist in the Employee table (i.e., if there is an employee ID 00000 at the Academic Staff table, then there should be a data about Employee Id 00000 at the Employee table. o The FacilitatorID is the ID of the Employee facilitating the subject. o The following are the list of Units currently being offered: ▪ BIS2018 – Fundamentals of Business Information System ▪ PLC2018 - Industry Placement ▪ PRJ2018 – Information Systems Project Management ▪ DBM2018 – Database Management System o Current available class codes are (only one facilitator is allowed to teach a class): ▪ CBIS20181A-1-18 (this is read as Class BIS2018 group A – Semester 1- 2018) ▪ CBIS20181B-1-18 ▪ CPLC2018A-1-18 ▪ CPRJ2018A-1-18 ▪ CPRJ2018B-1-18 ▪ CPRJ2018C-1-18 ▪ CDBM2018A-1-18 ▪ CPLC2018A-1-18 o Semester Code format is SEM
-. For example: SEM1-2018, SEM2- 2018, SEM1-2019 and so on. There are 3 semesters per year. o Work Type can be: ▪ Online facilitation ▪ Assessment marking ▪ Consultation ▪ Tutorial ACCT6001 Assessment 4 – Database Application Page 5 of 9 o Status of an Academic Staff can be: ▪ Full-time ▪ Part-time ▪ Sessional Instructions: 1. You need to design and develop a new database given the information provided above. Create the E-R diagram, translate to relational schema and then normalise. 2. Create the tables, forms, reports and queries using libreBase or Microsoft Access 3. You need to create the forms and reports as required by the HR Manager in the case study. SUBMISSION REQUIREMENTS: 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) IT controls needed 2) LibreOffice Base/Microsoft Access 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 • IT Control ACCT6001 Assessment 3- Excel Spreadsheet Page 6 of 9 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