THE DESIGN AND DEVELOPMENT OF AUTOMATED DAILY TIME RECORD WITH AN EARLY WARNING ALARM SYSTEM FOR LGU-SISON

Abstract

This paper presents a comprehensive study on the design and development of the Daily Time Record system for employees of the Local Government of Sison in Surigao Del Norte. The system serves as a basis for recording their time-in and time-out, which, in turn, plays a crucial role in evaluating their performance and calculating their salaries. To facilitate this process, an RF-ID reader is integrated into the computer keyboard port to capture RF-ID tags during login and logout transactions. In addition to the Time Record system, the study also focuses on the development of an automated Central Alarm system. The external central alarm is connected via a USB port with the aid of a third-party driver that converts from USB to RS232 cable converter, enabling seamless communication with the embedded systems application of the alarm system. Careful consideration was given to the power rating of the alarm siren and the driver of the high current load to ensure efficient operation. To realize the complete automation process, the implementation includes the utilization of a MYSQL database for the backend, while the front end is based on Visual Basic.net. The study's results indicate that the system's output is not only applicable to the Local Government of Sison but also serves as a suitable solution for other local government units seeking to implement an automated centralized alarm system. The system has been extensively tested and found to be compatible with most windows operating systems, making it highly adaptable and accessible across various environments