EMPLOYEE MANAGEMENT SYSTEM (EMS)

Student : Padua Gloria Student number: 2916574 Supervisor : Professor I.Venter

OVERVIEW

• Employee management system.

• High level design • Implementation • Testing • Scenario • Timeline • References • Demo • Questions

Quick re cap

• Employees are the backbone of any organization, business etc.

• Employees play a major role in deciding the success of an organization.

• The project was based on an automobile workshop located in Kigali, Rwanda.

• Workshop has at least 20 employees.

• The workshop owner is still using legacy system that is cabinet files.

• The workshop owner wants to upgrade his system

Quick re cap(CONT’D)

•

To monitor and manage the tasks of employees

(Keeps records of the functions performed by each individual employee) • The system needs to be secure • Allocate work to employees.

• Must be linked • It must be accessible at all times.(

Web based application used

)

High level design

Implementation

• Created a database using MySQL and phpMyAdmin. This is the back end of the EMS • In order for the users to interact with the system they need an interface that retrieves, updates and deletes data from the database.

• Used php, JavaScript, Ajax and html

Testing

• This is split into two parts. This is in order to deal with the both the two users.

• That is the Administrator and the employee • So I split the users into two groups that is the users and administrators • Then gave them step by step guide line on how to use the system and let the users interact with the system.

• Then their was a questionnaire they filled to rate the performance of the system.

Tasks done

• Add a new car and assign a task to employee •

Add a new employee

•

Delete an employee

•

Calculate

Salary

Testing (cont’d)

• Each user was able to complete the task allocated in the user’s guide so all the functionalities were accounted for.

• For the interface: user friendly, understandable and easy to navigate.

• System performance is fast. And the database insertions work correctly.

System Testing

• Scripts and SQL injections to test security of the database that is to check if unauthorised access to the database is possible.

• Used PHP time to check the amount of time it takes to execute a function

Usability testing

85% 85% 85% 85% 84% 84% 84% 84% 84% 83% interface Performance Security Series 1 Column1 Column2

Testing Graph

100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% Interface Performance Security Administrator Employee Column1

Negative feedback

• Some of the links on the administrator side were not working. • With the more insertions more data.

Scenario

• • • • • • A car owner brings a faulty car into the work shop. The administrator captures the following information number plate, make, problem and then he assigns a car to an employee.

Then he adds a new employee is employed into the workshop so his basic personal details need to also be captured into the database.

An employee then logs into the system and looks through his work sheet and then picks a task to begin with.

Administrator is then able to keep track on who is working on a car and what time they started working on it.

When the employee has completed his/her task he updates the this information including the services he performed on the car.

Every employee is entitled an hour break he is also able to allocate what time he took a break. Then he is able to view his salary update for each car he works on.

TIMELINE

Project Module

Project Analysis Project design and Development Project implementation Project testing, Evaluation and Presentation

Contents Documentatio n Submission

User requirements document Project plan Requirement Analysis User Interface specification, prototype, OOA/HLD and OOD/LLD documentation Fully documented implementation and refinement Testing and evaluation criteria document, user’s guide, Testing suite demo, final write up 2012/03/30 2012/05/25 2012/08/31 2012/11/23

Submissi on Status

Yes Yes Yes Yes

References

• All about PHPMyAdmin http://www.phpmyadmin.net/home_page/index.php

• All about Apache http://www.webopedia.com/TERM/W/Web_server.html

• All about PHP http://php.net/manual/en/intro-whatis.php

• Dvorski D.D. 2007 . Installing, configuring and developing with XAMPP.

•

MySQL and PHP Reference

. 2012 (revision: 28791) Rasmus .L , 2002. Veracruz, Mexico.

PHP advanced tutorial

.

Demo

Administrator

• assign a task to employee •

Delete an employee

•

Calculate

Salary

Employee

• Pick a car to work on • Update after you finished working on a car • Edit Personal details • Salary statement

Questions