Category Archives: Programming

Payroll System Database Design

Payroll System Table Relationship

Title: Payroll System Database Design


Automated Payroll system is an application that will manage and compute the employee’s salary. It connects information throughout the entire company. It is the easiest way to cater these needs. Computerize systems is typically simplify information, Quickly organize reports, automatically archive data, calculate deductions, easily track clock in/out and minimize manual efforts.

Simplified and quickly organize data is advantageous in many ways. Such as integrated the payroll figures into easy to read platform to ensure everything is accounted for, thus minimizing risks of valid or missed numbers. The systems include updating of records of the employees preparing payroll sheet & pay slips. Updating records is automatically updated and stored on host computers where it can be review or amended by a manager or supervisor to ensure the accuracy & consistency of the records of the employees. Preparing payroll sheet is a document which all information’s of employees are recorded including name, address, id, number, position of employee.

Attendance Monitoring System Database Design

Attendance Monitorig System Table Relationship

Title: Attendance Monitoring System Database Design


The system Supreme Student Council (SSC) Student Activity Bar coding Attendance and Monitoring System has the ability to automate and increase the speed and security in terms of monitoring the attendance. The SSC members/Students will both have benefit for a reason that they will not do the same process they are using in every transaction. Instead of doing the usual way or the manual system of monitoring the attendance, they can now use a Graphical User Interface (GUI) all they have to do is to use the mouse, keyboard and barcode scanner to automate every transaction.

Employee Performance Evaluation System Database Design

Employee Performance Evaluation System Table Relationship

Title: Employee Performance Evaluation System Database Design


The Human Resource will address the Automation of the Performance of the employees as regard to what is monitored on them. Their performance would be according to the qualities of what they’re working on. On the present situation, the performance of the employees were poorly evaluated and monitored before, during and after every period of their jobs. Although Human Resource would evaluate them, it is a very ideal thing for them to accomplish every evaluation of the employees regularly to update their performance their quality of work. The Human Resource Management Office used to have a process of manual performance evaluation system. The employee evaluators manage/conduct the manual system and other staffs of Human Resource Management Office are the one who compute the results of performance evaluation. During the process, it takes time to do all paper works and the validity of results. There are also some instances that some documents are being misplaced and lack of security. The Web-Based Employee Performance Evaluation System will improve the current system of the organization. The documents will be secured and the employees can gain knowledge about their performance and the data will be sent directly to the Human Resource Management Office. The works will be lessening because of the new system that we proposed.

Library System Database Design

Library System Table Relationship

Title: Library System Database Design


The Library System is a computer-based application used to automate a library. It allows the librarian to maintain the information about books, magazines and other library materials. It also allows the librarian to maintain and organize the information about its clientele or borrowers.

This project focuses on the automation of system process of adding newly acquired books, borrowing books and borrower’s information, returning of books, searching for the location of the books and printing of the inventory of books in the library.

Sales and Inventory System Database Design

Sales and Inventory System Table Relationship

Title:  Sales and Inventory System Database Design


The main objective of the study is to develop and implement computerized sales and inventory with decision support system. The development of this project started with the proponent’s statement of the problem which includes general and specific problems that the current processes of the owner/company encountered. These problems were acquired through different data determination techniques such as observation, interviews, and surveys. Upon knowing the problems and formulating the objectives of the development, the proponents set the scope and limitations of the developed system to determine what the system would be like.

The proponents will create a module that will integrate the Point of Sales and for the availability of the products. The proponents will use MySQL that will serve as the database and querying of the tables. The proponents will also use Visual Basic for building an application for this module.

Sea grass Specie Profiling System in PHP and MySQL

Sea grass Specie Profiling System

Sea grass Specie Profiling System in PHP and MySQL


This study aims to develop an Information system of sea grass. The system is a big help to respond and to answer the needs of the end users in terms of the scarcity of references and lack of resources for the researchers, and fisheries students of the institution in the current existing system available for use.

This software is capable for storing data and is responsible for quick accessibility and easy retrieval of data and information of sea grass in the coastal areas in your locality. Prior to the development, the system was designed with search menu options that allows user to view and search information using the specie name of sea grass. As it was consulted from the end-user, the sea grass name contains information which includes its corresponding specie name, local name, phylum, order, genus and its taxonomic information. The system presents images in each specie with assigned label of photo description. It also provides information and basic set of features to add and update certain information available on the database system.

Voting System Database Design

Voting System Database Design

Title:  Voting System Database Design


The researchers would like to develop a voting system with android application. Wherein the system itself can canvass the vote of the students, easily distinguish the winner and can provide printable results. The system involved android application wherein the developer develops an application to those user students. The approach targets all the phases of system design, implementation and testing in the system. This approach is currently being applied for the implementation of voting system that will be initially deployed in an actual voting process.

Web Based Entrance Examination Database Design

Web Based Entrance Examination Database Design

Title:  Web Based Entrance Examination Database Design


The system can give reference number to the examinee before taking the exam. Then the systems database will provide the list of the entire applicant who takes the examination as well as their complete profile and examination. This data will help the Guidance Counselor who among the applicants passed the entrance examination and who qualifies to enroll in the institution. With the help of Decision Support System which utilizes decision models a database and decision makers it can help the student the course they belong or qualified.

The system is a web based project, PHP/Javascript will be used as the programming/scripting language. For the user interface or the design or the project the researchers will use HTML, CSS and Javascript and for the storage or the database we will use MySQL/MariaDB.

Medical Record System Database Design

Medical Record System Database Design

Title:  Medical Record System Database Design


The researcher came up with the study by conducting an observation with regards to the clinics operation and protocol. The Clinic started using the recording of patient’s information thru MS Excel and using manual file folder recording since the start of the operation. By that reason the researcher propose a more convenient way of organizing and managing the patient’s record by means of developing a lan-based system thru EMR (Electronic Medical Record) Technology. The researcher will use Visual Basic for programming and MySQL for the database of the project.

The study is focused on developing the patient’s record. Patient Integrated system is a LAN-Based System that will focus on keeping all the patient records.

Elearning System Database Design

Elearning System Database Design (PHP, MySQL, Bootstrap)

Title: Elearning System Database Design

Description: the elearning system will be developed using PHP and MySQL, for the user interface the researcher will use Bootstrap. There are two types of users for this system, the administrator or the teacher account and the student account. The teacher/administrator will be the one to encode the student information, lessons, categories and quizzes. The student account can then login to the system using the username and password provided by the teachers, they can now view the lessons in text format, pdf version or even in video presentation, after that they can now take a quiz and view the results.

Database Schema with description of table:

This section will discuss the different tables of the elearning system.

tbluser stores basic information of the persons who are using the system such as username, password, firstname and lastname. User level field is set by the administrator specifying the role of the user. The id field is auto-generated by the table/system.