ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 10 ASSESSMENT...

Question

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 10

ASSESSMENT BRIEF
Subject Code and Title ACCT6001 Accounting Information Systems
Assessment Assessment 4: Database Application – Case Study
Individual/Group Individual
Length 1500 words +/-10%
Learning Outcomes b) Explain the characteristics of relational databases
and their role in creation and communication of
usiness 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 XXXXXXXXXXPage 2 of 10
ASSESSMENT 4 Database Application Case Study
CASE STUDY
Background of To
ens We Help Inc.
To
ens 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 Australia, Papua New Guinea and New Zealand.
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 Australian, PNG or New
Zealand 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 prototype data mart for the HR System that will be used as basis for the
development of the data warehouse for the entire university.
You have been assigned to develop the stage 1 of their project.
Project Description:
TWHI has used a spreadsheet software to maintain and monitor its employee information.
Its human resource (HR) department is cu
ently struggling get the updated information of its
entire academic and administrative staff. The HR manager maintains the following
spreadsheets:
 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 teaching staff (name of staff, hours worked per week, type of
work, (e.g., online facilitation, assessment marking, consultation), hourly
ate, subject name, number of students)
 List of subjects that teaching staff is approved to teach (name, list of subjects)

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 3 of 10

 Information about the teaching staff (name, location, contact details, status
(part-time, full-time, sessional)
 Administrative staff information (name, position, status (part time or full-time)
 Teaching staff and administrative staff leave/absence spreadsheet (name of
staff, position, status, no of leave allowed, no of sick leave allowed, dates of
leave/absences, type of leave, remaining leave, remaining sick leave, paid/not
paid leave, status (approved or not)
 Staff Professional Development Activities (name of staff, date of activity, type
of activity, description of activity, report submitted, funding type)
Aside from the abovementioned spreadsheets, the HR Manager maintains a physical file
of all the Cu
iuculum Vitae’s of all the staff and just reads the CVs when information is
needed. Because of this, the HR Manager spends time sorting and looking at the staff’s
ecords to get the information needed by several stakeholders in AusED (e.g.,
management, payroll, staff)
Management has determined that the company’s plan of extending its education services
to different areas means it is no longer feasible to use spreadsheets to maintain the
organisation’s human resource data. A human resource development database system
needs to be designed to be able to store and retrieve all employee related information in
an organized and efficient manner. In addition, the spreadsheets that the AusED Human
Resource (HR) manager maintains contain a lot of redundant data. The spreadsheets also
contain attributes (columns) that should belong to other spreadsheets.
You are expected to develop a database for the ACADEMIC STAFF of TWHI Human
Resource. You need to design and implement the database using Microsoft Access or
Li
eOfficeBase.
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 AusED’s
employees
. 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:

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 4 of 10

 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 and total number of all part-time Academic Staff and their location
 List and total number of sessional Academic Staff and their location
 List the names of all academic staff and the type of work they are doing.
 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.
. The following are the activities you expected to do:
 create the database tables
 normalise the database tables
 update the database tables using SQL statements
 add at least 10 different data per table
c. The final project should contain normalised tables
4. E-R Diagram
a. You are also required to submit the E-R diagram for this project using any diagram
editor.
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 Cu
ently all employees are in the IT 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 XXXXXXXXXXat

ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 5 of 10

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 cu
ently being offered:
 BIS2018 – Fundamentals of Business Information System
 PLC XXXXXXXXXXIndustry Placement
 PRJ2018 – Information Systems Project Management
 DBM2018 – Database Management System
o Cu
ent 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
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 li
eBase or Microsoft Access
3. You need to create the following forms for data entry:
a. Employee Form
. Project Form
c. Supplier Form

ACCT6001 Assessment 4 – Database Application

qfile_636797918236711564_123644_1.pdf

Ankit · Accepted Answer

Student_Id
				Student_Name
				Title of Assignment
1. Introduction
The main purpose of this document is to develop database design for academic staff and admin staff for Torrens We Help Inc (TWHI). “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 Australia, Papua New Guinea and New Zealand. 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 Australian, PNG or New Zealand government.”
The database software is developed for TWHI in software MSaccess that consist of tables, relationship, forms and reports. The design of tables is listed below:
1. 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) 
2.  Timesheet for teaching staff (name of staff, hours worked per week, type of work, (e.g., online facilitation, assessment marking, consultation), hourly rate, subject name, number of students) 
3.  List of subjects that teaching staff is approved to teach (name, list of subjects)
4. Information about the teaching staff (name, location, contact details, status (part-time, full-time, sessional) 
5.  Administrative staff information (name, position, status (part time or full-time) 
6. Teaching staff leave/absence spreadsheet (name of staff, position, status, no of leave allowed, no of sick leave allowed, dates of leave/absences, type of leave, remaining leave, remaining sick leave, paid/not paid leave, status (approved or not) 
7. Administrative staff leave/absence spreadsheet (name of staff, position, status, no of leave allowed, no of sick leave allowed, dates of leave/absences, type of leave, remaining leave, remaining sick leave, paid/not paid leave, status (approved or not) 
8.  Staff Professional Development Activities (name of staff, date of activity, type of activity, description of activity, report submitted, funding type)
2. Need for the implementation of the database
“Microsoft Access is database management software as it dramatically decreases the amount of time required to exchange and leverage information between Microsoft Office applications. Microsoft access provides database management functionality for academic staff of TWHI Human Resource and is highly extensible with enterprise systems by professional developers.”
3. Forms
a. HR Manager should have the form to enter the information about AusED’s employees
b. HR Manager should have the form to enter information about the allocation of subject per Academic Staff
4. 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 and total number of all part-time Academic Staff and their location
  List and total number of sessional Academic Staff and their location 
 List the names of all academic staff and the type of work they are doing. 
 List the names of all employees and how long they have worked for TWHI
Tables
Database: Acedemic staff has following tables in 3 normal forms:
1. create table Employee(Employee_id number,Employee_title text,Employee_fname text, Employee_lname text,Employee_dob date,Employee_address text,Employee_state text,Employee_postalcode text,Employee_phno text,Employee_mobile text,Employee_hire_Date date,Employee_terminated_date date,TFN text,Department text,Location text);
2. Create table  Timesheet(ID number, employee_id number, Hours_works_week text, Type_work text, Hourly_rate number, Subject_id number, Number_student_subject text);
3. Create table  Subject(Subject_id number, Subject_code text, Subject_name text);
4. Create table Subjects_approved(ID number, Subject_id number, Employee_id number);
5. Create table Staff_teaching(id number, employee_id number, Staff_location text, Staff_mobile text, Staff_status text);
6. Create table Admin_staff(Admin_id number, Admin_name text, Admin_position text, Admin_status text);
7. Create table Staff_Activity(ID number, employee_id number, activity_date date, activity_type text, activity_desc text, report_submitted text, funding_type text);
8. Create table Leave_info_Admin(id number, admin_id number, admin_position text,

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

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment