Development of HR Database for Torrens We Help Inc.

This report discusses the development of an HR Database for Torrens We Help Inc., a non-profit organization providing online education services. It includes an ER diagram, tables, forms, and reports, as well as IT control needs.

Running head: ACCOUNTING INFROMATION SYSTEM
Accounting Information System
Name of the Student:
Name of the University:
Author Note

1
ACCOUNTING INFROMATION SYSTEM
Introduction
Development of database is very useful for any type of organization and Torrens We
Help Inc. is no exception in this aspect. The organization is a non-profit organization and the
organization provides online education service to the students around the world. The
Organization is looking to implement an HR Database which would be helpful in tracking the
activities of the staffs within the organization and monitoring them.
The report has been developed for providing the discussion on the development of the
HR Database for the organization. The ER diagram has been used for the description of the
table and the structures of the database. The forms and reports useful for the organization is
also described in the report.
Justification of the use of database
The Use of database for the HR Database system implemented in the Torrens We
Help Inc. is that it would help the organization with the management of data that is fetched
from the different business procedures od the organization. The database management system
is used for the interaction with the software that is to be implemented in the system. The
reports and the forms would make the task of handling the management process for the
organization. The database would help the HR management to define the data that are
obtained from the business procedures of the organization. The task of fetching data and
storing data would be done easily with the help of the database management system as the
technology provides the functions of creation, querying, update, and administration of the
systems of the organization.

2
ACCOUNTING INFROMATION SYSTEM
Database design: E-R Diagram
Normalization
The set of tables which are obtained after normalization are provided below:
Employee Information (EmployeeID (pk), Title, FirstName, MiddleName, LastName,
Birthdate, StreetAddress, City, State, PostalCode, PhoneNumber, MobileNumber, DateHired,
DateTerminated, TFN, DepartmentID (fk))
Department (DepartmentID (pk), DepartmentName, Location)
Subjects (SubjectID (pk), SubjectName)
Academic Staffs (StaffID (pk), EmployeID (fk), Name, Location, ContactDetails, Status,
WorkType)
Administrative Staffs (AdminID (pk), EmployeID (fk), Name, Position, Status)
Subject Allocations (AllocationID (pk), StaffID (fk), SubjectID (fk))
Attendance Spreadsheet (LeaveID (pk), StaffID (fk), LeaveAllowed, SickLeaveAllowed,
AbsentDate, LeaveType, RemainingLeave, RemainigSickLeave, Status)

3
ACCOUNTING INFROMATION SYSTEM
Development Activities (ActivityID (pk), StaffID (fk), ActivityDate, ActivityType,
Description, Report, FundingType)
Approved List (FacilitatorID (pk), EmployeeID (fk), SubjectID (fk))
IT control Needs
IT control is a process that is very important for any type of organization and the
Torrens We Help Inc. is no exception in this case. The IT control procedures provides an
assurance that would be helpful for the Torrens We Help Inc. organization in monitoring their
process and also mitigating the security issues that might be faced by the organization during
the implementation of the business procedures of the organization. This makes sure that the
organization is able to operate on the developed system as per their intention and this gives
them the chance to control the process flow of the systems developed. This also affects the
business of the organization to a great extent, although the organization that has been
considered here is a non-profit organization. Yet the procedures of the organization are to
controlled as this a disciplinary organization. It is to be made sure that the data that is being
used by the organization for their organizational procedures are reliable enough and the
processes that are followed by the organization are in compliance with the applicable laws
and standards of the organizations. In addition to this, there are two categories of the IT
control needs and they are termed as the IT general controls and application controls. The
organization is required to demonstrate the organizational procedures and the policies that are
in place for the technologies that are used by the management of the organization. Hence all
these processes are handled by the IT general control. The issues such as risk management,
change management and disaster recovery process are included in this concept which is
necessary for the organization to avoid the possible risks that would be faced by the
organization. In addition to this, the organization is also required to take proper actions that
are already automated by the software application and there should be possible methods for

4
ACCOUNTING INFROMATION SYSTEM
the demonstration of the software application used for the business process of the
organization and these facilities are provided by the IT application control system that would
be used for proper authorization and monitoring the audits and other business functions of the
organization.

5
ACCOUNTING INFROMATION SYSTEM
Bibliography
Achpal, A., Kumar, V. B., & Mahesh, K. (2016). Modeling Ontology Semantic Constraints in
Relational Database Management System. In Proceedings of the International
MultiConference of Engineers and Computer Scientists (Vol. 1).
Achpal, A., Kumar, V. B., & Mahesh, K. (2016). Modeling Ontology Semantic Constraints in
Relational Database Management System. In Proceedings of the International
MultiConference of Engineers and Computer Scientists (Vol. 1).
Arasu, A., Babcock, B., Babu, S., Cieslewicz, J., Datar, M., Ito, K., ... & Widom, J. (2016).
Stream: The stanford data stream management system. In Data Stream Management
(pp. 317-336). Springer, Berlin, Heidelberg.
Van Aken, D., Pavlo, A., Gordon, G. J., & Zhang, B. (2017, May). Automatic database
management system tuning through large-scale machine learning. In Proceedings of
the 2017 ACM International Conference on Management of Data (pp. 1009-1024).
ACM.

6
ACCOUNTING INFROMATION SYSTEM
Appendix
Database Tables and Data
Employee Information
Department
Subjects
Academic Staffs

7
ACCOUNTING INFROMATION SYSTEM
Administrative Staffs
Subject Allocations
Attendance Spreadsheet
Development Activities

8
ACCOUNTING INFROMATION SYSTEM
Approved List
Forms
Employee Details
Subject Allocations

9
ACCOUNTING INFROMATION SYSTEM
Reports
Employee Contact
Full Time Employees

10
ACCOUNTING INFROMATION SYSTEM
Part Time Employees
Seasonal Employees
Work Experience

11
ACCOUNTING INFROMATION SYSTEM
Work Type