NSC Online Leave System Members Designation Shiundu Jonathan

NSC Online Leave System Members Designation Shiundu Jonathan Programmer Nyongesa, John Programmer

Overview • Background of the Study • Scope and Delimitation • Objectives of the Study • Current Operation / Proposed Solution • Database Scheme • Entity Relationship Diagram • Virtual Table of Contents • System Description • System Features • Conclusion and Future Direction

Background of the Study Automation plays an increasingly important role in the global economy and in daily experience. Engineers strive to combine automated devices with mathematical and organizational tools to create complex systems for a rapidly expanding range of applications and human activities.

The researchers decided to choose this study to help NSC ICT Department provide an accurate and secured filing of leave. The researchers also chose this study because NSC needs a computer-based Online Leave System due to the growth of population of the NSC and it is the only system that is never developed by any employee at NSC , Colleges or outside the school.

Scope and Delimitation • The system manages or administers the automation of filing of leave report generation, and verifying leaves, thus the system will deal primarily with automating these processes to be able to solve the problems caused by these manual processes of leave process. • The other processes were added to facilitate the work of the system employee’s registration is needed, since this information is needed for the system, report generation is undeniably needed in automating the leave process. This will help deal with complaints, and is also needed for the creation of objective documents for the school’s records. The system will be used in determining whether an employee is eligible for filing leave or not.

Objective the Study Specific Objectives Minimize the inconsistencies of processing transactions. Minimize the time consume in generating a reports. To find and track down all the leave transactions.

Current Operation Start Y A Fill in the form File Leave? Have the form Signed by the dean N Approval Or Disapproval? Y End Employee can take a leave Y Approved Or Disapproved? N A Have the form signed by director N A

Propose Solution Start A Y Y Are there Leave available? View Leave Available File Leave? File Leave Fill up the form N N Filed leave submitted to the dean End Y End Employee can take leave Approved Or Disapproved? Filed leave submitted to the director Y Approval Or Disapproval? N N A A

Database Scheme Employee eid, fname, mname, lname, bday , age, gender, address, status, contact, posid, date_added, added_by Primary Key: eid Foreign Key: posid referring to the Position Table Leaves leaveid, fdate, leavetype, edate, endate, reason, recommending, deanstatus, directorstatus Primary Key: leaveid Foreign Key: eid referring to the Employee Table Position posid, position Primary Key: posid Users userid, eid, fname, lname, username, password, posid Primary Key: username Foreign Key: posid referring to the Position Table eid referring to the Employee Table ldays id, posid, adays Primary Key: id Foreign Key: posid referring to the Position Table

E. R. Diagram

Virtual Table of Contents User Login Employee Director Administrator Main Page Search Employee Search Reports Maintenance Log Out Transaction Log Out

System Description • The programming language we use in creating this system is Php (Hypertext Preprocessor) • The database that researches uses is My. SQL because it is a very capable relational client/server database system. • It is sufficiently secure and stable for many applications, and it offers an excellent cost/benefit ratio not only because My. SQL is free itself.

System Features • The system is divided in three (3) modules the faculty, administrator, director • The system aims to develop a fully functional computer based Online Leave System for the NSC Faculty. Filing of Leaves will be easier and errors or anomalies will be reduced. • The system will be secured from confusion of how many days will an employee is allowed to take a leave.

System Features • The system generates a report such as the list of the employees who filed their leave; the employees who are allowed to file a leave are those who are registered on the database. • The system will securing the process of filing leave. One way is through the use secure password, which will be entered upon registering on the system software.

Conclusion and Future Direction This study was done for the employee of the Nzoia Sugar Company Ltd to make their filing of leaves easier and faster. In this system you will see what are the available days of leave and easier for the administrator to enter the information of the employee. The admin was one click away from the reports. We conclude that this system will track all employees who filed leave, can easily search for the employees and it will make the transaction of the process faster and efficient.

Conclusion and Future Direction It is very important for NSC to implement the NSC Online Leave System to have a faster transaction to the employees. By implementing this system they will be easily track down of all the leave information of the employee in the department. The researchers want that the system will make the current system automated

References • Andy Harris, 2003 PHP/My. SQL Programming for the Absolute Beginners Premier Press, 25 Thomson Place, Boston, MA 02210 • Michael Kofler 2004, The Definitive Guide to My. SQL, Second Edition Apress, Springer-Verlag New York, Inc. , 175 Fifth Avenue, New York, NY, 10010 • Julie C Meloni, 2002, Teach Yourself PHP, My. SQL™ and Apache in 24 Hours California • Rasmus Lerdorf, Peter Mac. Intyre, Kevin Tatroe, 2006, • Programming PHP, 2 nd Edition 1005 Gravenstein Highway North, Sebastopol, CA 95472. • Matt Rutledge, 2004, PHP Game Programming, 25 Thomson Place Boston, MA 02210 Los Altos,