Cordillera Career Development College Personnel Information System

Abstract

The project transformed the existing manual personnel data recording and information retrieval processes of the Human Resources Management Office (HRMO), Cordillera Career Development College (CCDC), into a computer-based Personnel Information System (PIS). When operational, personnel information will be available on-line to authorized users through LAN-connected computers. CCDC is located in Poblacion, La Trinidad, Benguet, with about 2.500 students, and about the one hundred eighty (180) personnel, of whom one hundred thirty (130) are faculty. The project stems from a November 2002, directive of the College President to initiate computer-based information system projects.

A client/server RDBMS architecture was adopted, using the existing school LAN. After a meticulous review of Internet literature, it was decided to use MySQL, MS Access, MyODBC, TCP/IO, and the underlying SQL and VBasic programming languages.

Total project development consists of three phases, 1) a database management sub-system, 2) an internet-based information browsing subsystem, and 3) a hardcopy report generation subsystem. This project construction is limited to phase 1 only. Development proceeded along with the “waterfall model” utilizing RAD and prototyping techniques. Phases 1 is concluded by parallel conversion, 1) to evaluate and improve the functionalities of the GUIs, 2) to provide exhaustive tests to identify and rectify bugs, and 3) to populate the database for subsequent development of the other two subsystems.