180 likes | 426 Views
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.
E N D
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)
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
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.
References • All about PHPMyAdminhttp://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