Description
ABSTRACT
Employees are the backbone of any company therefore their management plays a major role in deciding the success of an organization [1]. Employees Management Software makes it easy for the employer to keep track of all records. This software allows the administrator to edit employees, add new employees, transfer/promote/terminate employees. Each employee in the database is associated with a position can be added and edited when need arises. Employees can be transferred between positions easily without having to retype back their information in the database. You can check to see if there are duplicate positions/employees in the database. Most of all, the employer can assign tasks to employees and assess their progress in order to keep track of employee performance.
A flexible and easy to use Employee Management software solution for small and medium sized companies provides modules for personnel information management thereby organization and companies are able to manage the crucial organization asset – people [2]. The combination of these modules into one application assures the perfect platform for re-engineering and aligning Human Resource processes along with the organizational goals. This system brings about an easy way of maintaining the details of employees working in any organization.
It is simple to understand and can be used by anyone who is not even familiar with simple employees system. It is user friendly and just asks the user to follow step by step operations by giving easy to follow options. It is fast and can perform many operations for a company.
The goal of this project is to design and develop an employee management system to fill existing gaps in the electronic management of employees.
Table of Contents
- CHAPTER ONE: INTRODUCTION TO THE RESEARCH…………………………………………………………… 11
- PROBLEM STATEMENT……………………………………………………………………………………………… 11
- PROJECT BACKGROUND…………………………………………………………………………………………… 11
- OBJECTIVES……………………………………………………………………………………………………………. 12
- SCOPE.. 12
- EXPECTED BENEFITS…………………………………………………………………………………………………. 13
- REQUIREMENTS AND CONSTRAINTS…………………………………………………………………………… 14
- Functional Requirements:……………………………………………………………………………………… 14
- Non-Functional Requirements:………………………………………………………………………………. 16
Since EMS application is a web-based application, internet connection must be established……. 16
The EMS software personal database model will support MySQL environment as DBMS………. 16
- SUMMARY…………………………………………………………………………………………………………….. 16
- CHAPTER TWO –RESEARCH………………………………………………………………………………………….. 17
- INTRODUCTION………………………………………………………………………………………………………. 17
- LITERATURE REVIEWS ON TOPICS RELATED TO THE PROJECT……………………………………………. 17
- REVIEWS ON SEVERAL SOFTWARE METHODOLOGIES……………………………………………………… 18
- REVIEW OF POSSIBLE DEVELOPMENT TOOLS AND SOFTWARE TO BE USED………………………………… 20
- Back-end Technology……………………………………………………………………………………………. 20
- Database Management System……………………………………………………………………………… 22
- REVIEW OF SIMILAR SYSTEMS……………………………………………………………………………………. 24
- SUMMARY…………………………………………………………………………………………………………….. 28
- CHAPTER THREE: SYSTEM ANALYSIS………………………………………………………………………………. 29
- INTRODUCTION………………………………………………………………………………………………………. 29
- SOFTWARE DEVELOPMENT METHODOLOGY OF CHOICE………………………………………………….. 29
- SYSTEM DESIGN……………………………………………………………………………………………………… 29
- Use case analysis…………………………………………………………………………………………………. 29
- Class diagram………………………………………………………………………………………………………. 36
- DEVELOPMENT TOOLS……………………………………………………………………………………………… 37
- Front End Technologies…………………………………………………………………………………………. 37
- Back End Technologies………………………………………………………………………………………….. 38
- SUMMARY…………………………………………………………………………………………………………….. 39
- CHAPTER FOUR: DESIGN…………………………………………………………………………………………….. 40
- INTRODUCTION………………………………………………………………………………………………………. 40
- EXPLANATION OF THE PROPOSED SYSTEM…………………………………………………………………… 40
- SYSTEM AND ALGORITHM FLOWCHARTS……………………………………………………………………… 41
- SYSTEM STRUCTURE CHART DFD AND ERD……………………………………………………………………. 43
- Data Flow Diagram (DFD)………………………………………………………………………………………. 43
- ENTITY RELATIONSHIP DIAGRAM (ERD)……………………………………………………………………. 44
- STORYBOARD…………………………………………………………………………………………………………. 45
- Sequence Diagrams……………………………………………………………………………………………… 45
- INTERFACE DESIGN………………………………………………………………………………………………….. 47
- Sketches of graphics………………………………………………………………………………………………… 48
- SUMMARY…………………………………………………………………………………………………………….. 50
- CHAPTER 5: IMPLEMENTATION……………………………………………………………………………………. 51
- INTRODUCTION………………………………………………………………………………………………………. 51
- DESCRIPTION OF DEVELOPED SYSTEM…………………………………………………………………………. 51
- Accessing the system……………………………………………………………………………………………. 51
- TECHNICAL DETAILS OF IMPLEMENTED SYSTEM…………………………………………………………………… 52
- Model View Controller architecture (MVC)……………………………………………………………….. 52
- MySQL Triggers……………………………………………………………………………………………………. 53
- Algorithms………………………………………………………………………………………………………….. 54
- Pseudocode……………………………………………………………………………………………………….. 55
- SCREENSHOTS OF DEVELOPED SYSTEM………………………………………………………………………… 57
- SUMMARY…………………………………………………………………………………………………………….. 57
- CHAPTER SIX: TESTING AND VERIFICATION…………………………………………………………………….. 58
- INTRODUCTION………………………………………………………………………………………………………. 58
- SCOPE.. 58
- TESTING GOALS………………………………………………………………………………………………………. 58
- CONFIRMATION TESTING…………………………………………………………………………………………. 58
- REGRESSION TESTING………………………………………………………………………………………………. 58
- TEST PLANS AND RESULTS…………………………………………………………………………………………. 59
- SUMMARY…………………………………………………………………………………………………………….. 62
- CHAPTER SEVEN: CONCLUSION……………………………………………………………………………………. 63
- INTRODUCTION………………………………………………………………………………………………………. 63
- RESULTS………………………………………………………………………………………………………………… 63
- PROBLEMS FACED……………………………………………………………………………………………………. 63
- LIMITATIONS………………………………………………………………………………………………………….. 63
- Custom report generation……………………………………………………………………………………… 63
- Head of Department heads all Projects…………………………………………………………………….. 63
- Leave Management……………………………………………………………………………………………… 64
- Browser support………………………………………………………………………………………………….. 64
- FUTURE WORK……………………………………………………………………………………………………….. 64
- Leave Management……………………………………………………………………………………………… 64
- Integration with payroll system………………………………………………………………………………. 64
- Employee Performance………………………………………………………………………………………… 64
- Information archiving……………………………………………………………………………………………. 64
- LEARNING EXPERIENCE…………………………………………………………………………………………….. 64
- CONCLUSION…………………………………………………………………………………………………………. 65
- REFERENCES……………………………………………………………………………………………………………… 66
- APPENDIX………………………………………………………………………………………………………………… 68
- Appendix A – Sequence Diagrams………………………………………………………………………………. 68
- Report generation……………………………………………………………………………………………….. 68
- Edit account details………………………………………………………………………………………………. 68
- Appendix B – Sample Code……………………………………………………………………………………….. 69
- Database Connectivity………………………………………………………………………………………….. 69
- User Authentication……………………………………………………………………………………………… 69
- PDF Library…………………………………………………………………………………………………………. 71
- Leave application…………………………………………………………………………………………………. 71
- Create new project and add member………………………………………………………………………. 73
- Appendix C – Screen shots of developed system…………………………………………………………… 74
- Employee interface………………………………………………………………………………………………. 74
- Admin interface…………………………………………………………………………………………………… 74
- Leave management……………………………………………………………………………………………… 75
- Edit profile………………………………………………………………………………………………………….. 75
- Appendix I – Testing………………………………………………………………………………………………… 76
- Login………………………………………………………………………………………………………….. 76
- Add new user……………………………………………………………………………………………… 76
- Edit Account………………………………………………………………………………………………… 77
- Leave request denied due to pending leave……………………………………………………… 77
- Leave request successfully submitted………………………………………………………………. 78
- Create Project WBS………………………………………………………………………………………. 78
- Generate reports…………………………………………………………………………………………. 79
- Appendix A – Sequence Diagrams………………………………………………………………………………. 68
1 CHAPTER ONE: INTRODUCTION TO THE RESEARCH
- PROBLEM STATEMENT
Manual handling of employee information poses a number of challenges. This is evident in procedures such as leave management where an employee is required to fill in a form which may take several weeks or months to be approved. The use of paper work in handling some of these processes could lead to human error, papers may end up in the wrong hands and not forgetting the fact that this is time consuming. A number of current systems lack employee self-service meaning employees are not able to access and manage their personal information directly without having to go through their HR departments or their managers. Another challenge is that multi-national companies will have all the employee information stored at the headquarters of the company making it difficult to access the employee information from remote places when needed at short notice.
The aforementioned problems can be tackled by designing and implementing a web based HR management system. This system will maintain employee information in a database by fully privacy and authority access. The project is aimed at setting up employee information system about the status of the employee, the educational background and the work experience in order to help monitor the performance and achievements of the employee through a password protected system.
- PROJECT BACKGROUND
Employees are the backbone of any company therefore their management plays a major role in deciding the success of an organization [1]. Human Resource Management Software makes it easy for the employer to keep track of all records. This software allows the administrator to edit employees, add new employees as well as evaluate an employee’s performance. Employees can be managed efficiently without having to retype back their information in the database. You can check to see if there are duplicate positions/employees in the database.
A flexible and easy to use Employee Management software solution for small and medium sized companies provides modules for personnel information management thereby organization and companies are able to manage the crucial organization asset – people [2]. The combination of these modules into one application assures the perfect platform for re-engineering and aligning
Human Resource processes along with the organizational goals. This system brings about an easy way of maintaining the details of employees working in any organization.
It is simple to understand and can be used by anyone who is not even familiar with simple employees system. It is user friendly and just asks the user to follow step by step operations by giving easy to follow options. It is fast and can perform many operations for a company
- OBJECTIVES
In this world of growing technologies everything has been computerized. With large number of work opportunities the Human workforce has increased. Thus there is a need of a system which can handle the data of such a large number of Employees. This project simplifies the task of maintaining records because of its user friendly nature.
The objective of this project is to provide a comprehensive approach towards the management of employee information. This will be done by designing and implementing an HR management system that will bring up a major paradigm shift in the way that employee information is handled.
The objectives of this system include:
- Design of a web based HR management system to fulfill requirements such as project management, leave management, report generation to assist in performance appraisal, ESS and employee trainings.
- Well-designed database to store employee
- A user friendly front-end for the user to interact with the
- SCOPE
The scope of this project will be limited to the following:
- Employee profiles:
Employees will have access to their personal profiles and will be able to edit their details.
- Electronic leave application:
Complete elimination of paperwork in leave management by enabling an employee apply for leave as well as check their leave status through the system. This will also enable the HR manager to accept/reject leave application through the system
- Project Management:
Assign tasks and projects to employees, assign a project team and keep track of the progress.
- Report generation:
The HR manager will be able to generate timely reports in order to monitor employees and this can be used for performance appraisals. The reports will be have all the information of an employee from educational background, trainings attended, projects done as well as technical skills.
- Recruitment Process:
The admin will add an employee and a default password and employee id will be generated and sent to the new employees email. The HR manager will then have the ability to add an employee’s information to the database.
- EXPECTED BENEFITS
This system is expected to be user friendly and will offer easy access to data as well as services such as online leave management, e-recruitment, and timely report generation, monitoring employee trainings, task management, project management and employee tracking.
The employee is expected to have direct interaction with this system through a password protected user account therefore proposed system is web based to enable accessibility from any location as long as internet connectivity is available. This direct interaction with the system will enable employee self-service.
Without an employee management system, it’s a tedious job for the human resource department to keep track of each and every employee and even harder for a project manager to assign tasks to the project team. The HR management system will be developed to provide information of employees and many other facilities at the click of a button.
- REQUIREMENTS AND CONSTRAINTS
- Functional Requirements:
Authentication
- Login- The user can login to the HRMS system with his/her username and
- Logout- The user can log out from the HRMS
Login failure- If the user does not exist in the database or the user has not yet being authorized by the HRMS admin.
Authorization
- User role check- After logging in, the user role will be checked from the database and the user interface will be displayed according to their
Process Data
- Display- User with defined roles can display the content of the database. Being more specific, employee can only view his/her personal information. HOD can not only see his/her personal information but also employee’s information who are under his/her department or school. Admin and HR can display their personal information and all employees’
- Edit- A user with employee role can edit his/her specific personal information. Dean or HOD can only edit employees’ personal information that is under his/her coverage except user role type. Admin can edit all information related to all employees’ including their user role
- Search- User with Dean/HOD role can search the content of database for the employees’ who are under his/her coverage. HR and admin roles can search all the employees’ information in the database. Search feature works on specific keywords showing
employee’s characteristics, peculiarities, skills, features, and etc. For example, HR wants to find employees’ who are well trained in “Java Programming Language”. He/she will write the specific keyword in the search bar and press the available search button.
Afterwards, he/she will find a list of all the employees’ who know “Java Programming”. Update authentication- This feature can be used only by admin role type. Admin can update the role type of a specific user. For example, an employee got promotion and his role type will be changed from employee role id to HOD or Dean role. Admin will be able to update this authentication mechanism.
Leave Application/Approval
- Leave application- The user can be able to fill in leave application form in the appropriate fields.
- Leave approval- The admin can be able to approve leave applications based on the reasons stated, length of leave as well as available HR on a
Leave days accrued- The user shall be able to check the number of leave days accrued.
Recruitment
- Add new employee- HR role type is able to add a new employee to the database. The new employee will have all the required personal information related to him/her. The new created employee will have an
- Add a new user- After a new employee has being created by HR role, admin role is responsible for creating a new user by the specified id assigned in the “Add a new
employee” feature. The unique id will be given by the system. Admin will assign a new role such as employee, Dean, HOD, HR, and admin to the new created user.
Report generation
- Report generation- HR shall be able to generate a report in pdf format for each employee based on the information in the database.
Project Management
- Create project team: The HOD of department or project manager shall be able to create a project and come up with a project
- Work Breakdown Structure (WBS): The HOD or project manager shall be able to assign tasks to the project team as well as monitor their
Trainings and Task Management
- Trainings: The HOD shall create trainings and assign employees that are required to attend the trainings as
- Tasks: HOD shall assign tasks to employees in his/her department.
- Non-Functional Requirements:
Performance requirements
There is no restriction on the number of the users to be added to the database.
Hardware requirements
EMS should be able to work on a computer with the following minimum hardware specifications:
OS: Windows XP/Vista/7/8 and Linux CPU: Pentium III (700MHz) and above Memory: 128 MB and above
Capacity: 4GB of hard drive
Others: Network interface card, mouse, keyboard, and monitor.
Software requirements
Since EMS application is a web-based application, internet connection must be established. The EMS software personal database model will support MySQL environment as DBMS.
- SUMMARY
This chapter began by giving a brief overview of the entire project, the background of the project and the scope. The problem definition and solution highlights the current problems faced with the use of the systems that are in place and outlines briefly the solution system to be developed. The next chapter will focus on the literature review. This is literature that relates to the project and similar systems.
Reviews
There are no reviews yet.