Monthly Archives: January 2020

Web and Mobile Based School Publication System with Forum

Web and Mobile Based School Publication System with Forum

Web and Mobile Based School Publication System with Forum

Proposed System

The technology has grown so fast, it changes the way we do our daily task. Technology has made our daily lives easier. Giving a way for technology gives us knowledge in improving or innovate how we disseminate information in a creative way. School publication is an entryway for students to express and voice out their ideas, through making a system for school publication it will catch the attention of every students or individual and readers in innovative, accessible and fun way. This serves as the reliable information about the school, where the events or activities and school related news will be published. Because of the advancement of today’s technology, faster dissemination of information is needed. The proposed Web and Mobile School Publication System can make students aware of the day-to-day activities inside the school campus.

Web and Mobile Based School Publication System with Forum

Web and Mobile Based School Publication System with Forum

Training Management System Capstone Project

Training Management System Capstone Project

Training Management System Capstone Project

Proposed System

The emergence of technology has made a huge impact in every single person in their working life. The functions of all the inventions and creations of the brilliant minds through technology, keeps them away in burden and hassle. And through this, the researchers have given the opportunity to produce a system that makes every processes, operations and transactions easy and possible. The researchers of the system entitled “training management system”, develops a system that would help individuals to be more effective and efficient in every performances. This is productive software that connects individuals to each other in order to meet their competency needs. It is very convenient, easy to use, and user friendly platform that enables real time access between the end user and the admin for a better and fast transaction and operations. This system will play a vital role in this field for it makes their work done on time, cannot make delays, and error free. All of the end users data will store or record in this system including their attendance, performance, comments and suggestions and ideas.

Training Management System Capstone Project

Training Management System Capstone Project

Task Management System Capstone Project

Task Management System Capstone Project

Task Management System Capstone Project

Proposed System

Technological innovations have changed the way we live our lives. Gone the days when everything was done manually, nowadays even simple tasks were provided more convenient and faster ways to do it. One of these is providing a system that transactions which involves in giving and monitoring task will be done in a fast and efficient manner.

The researchers of the proposed system entitled Task Management System aimed to provide a platform in which works and management of employee entries is more convenient. This is to verify the data and information of its member, task list, assigning task, personal messaging and so on. If you are a new employee, you have to register first and then the employee will be able to go to members log in, it is easier to its employee to do this. And if there are some functionality of the site that you register, then you will be able to register again to change its log in information.

Task Management System Capstone Project

Task Management System Capstone Project

Lending Management System Capstone Project

Lending Management System Capstone Project

Lending Management System Capstone Project

Proposed System

The proposed system entitled Lending Management System aims to make convenience for the transaction involving lending and using this system only requires less effort for the lender, easier and faster to manage. This kind of system will facilitate underwriting of proposals, dynamic uploading of documents, create user accounts and offer a collaboration framework for lenders.

The Lending Management System has unique characteristics which are simple, intuitive and proactive and this system handles different types of borrower and security of users’ documents. Through this system, lending processes will be hassle-free; they will not need to go physically to the lending offices to process but instead they will just utilize this system.

Lending Management System Capstone Project

Lending Management System Capstone Project

Online Vehicle Rental System Capstone Project

Online Vehicle Rental Capstone Project

Online Vehicle Rental System Capstone Project

Proposed System

Technology’s advancement has provided quicker ways to get things done. Technology made changes in our lives today. People rely so much in technologies even in transportation. Nowadays, not all people can afford to buy a vehicle that they will use in travelling. Most of those who can’t afford rely in renting vehicles as an alternative but the problem is it takes a lot of effort and time in finding vehicles that would satiate their selves while using it. In this era, people have less time and more works to do that force them to travel, they need vehicles that would make them reach their destination on time with comfort. To address this problem, the researcher of the proposed system entitled Online Vehicle Rental System aimed to provide a platform that would let transactions involving rental of vehicles to be convenient.

Online Vehicle Rental Capstone Project

Online Vehicle Rental Capstone Project

Patient Information System Database Model

Patient Information System Database Model

Patient Information System Database Model

This article will provide you with the list of database tables for the system entitled patient information system. The content includes the entities or columns of each table and as well as the table structure and the different constraints and relationships of the tables.

Patient Information System List of Database Table

Patient Information System List of Database Table

tblconsultation (consultation_id, patient_id, complaints, diagnosis, treatment, date_recorded, doctor_id, user_id)

Description: consultation table stores the information of the patient and as well as the consultation or health history, it is the compilation report for every time the patient ask the advice of his/her doctor. The table has 8 fields or entities; (1) consultation_id stands for the primary key of the table, (2) patient_id is a foreign key that links to the information of patient in the tblpatient, (3) complaints or the list of illnesses of the patient, (4) diagnosis is the initial findings of the doctor, (5) treatment refers to the initial advice of the doctor to the patient, (6) date_recorded is the date of data entry to the system, (7) doctor_id is the foreign key that links to the information of doctor in the tbldoctor, and (8) user_id the one who encodes the data to the system.

Create Table SQL Statement:

CREATE TABLE IF NOT EXISTS `tblconsultation` (
`consultation_id` int(11) NOT NULL AUTO_INCREMENT,
`patient_id` int(11) NOT NULL,
`complaints` varchar(100) NOT NULL,
`diagnosis` varchar(100) NOT NULL,
`treatment` varchar(100) NOT NULL,
`date_recorded` date NOT NULL,
`doctor_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`consultation_id`),
KEY `patient_id` (`patient_id`,`doctor_id`,`user_id`),
KEY `user_id` (`user_id`),
KEY `doctor_id` (`doctor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Procurement Management System Database Design

Procurement Management System Database Design

Procurement Management System Database Design

This article will serve as a guide in the development of procurement management system and related systems to procurement. The article contains the list of database tables used in our version of the procurement system.

Procurement Management System List of Database Table

Procurement Management System List of Database Table

Database Design/Schema/Model and List of DB Tables

tbldepartment (dept_id, dept_initial, full_description, encoded_by, encoded_date)

Description: tbldepartment is the database table that stores the information of the different offices and department of the company. The table has 5 entities; (1) dept_id is the primary key of the table, (2) dept_initial refers to the shortcut name or code of every office, (3) full_description is the full name of the office or department, (4) encoded_by is the user or staff that is responsible for encoding the department information, (5) encoded_date is the date of data entry to the system.

Create Table SQL Statement:

CREATE TABLE IF NOT EXISTS `tbldepartment` (
`dept_id` int(11) NOT NULL AUTO_INCREMENT,
`dept_initial` varchar(15) DEFAULT NULL,
`full_description` varchar(100) DEFAULT NULL,
`encoded_by` int(11) DEFAULT NULL,
`encoded_date` date DEFAULT NULL,
PRIMARY KEY (`dept_id`),
KEY `encoded_by` (`encoded_by`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Water Refilling System Database Model

Water Refilling System Database Model

Water Refilling System Database Model

The project entitled water refilling system is a database oriented information system that automates the record keeping of the water refilling station.

This article will provide you with the list of tables that might help you in the development of your own water refilling system.

Water Refilling System List of Database Tables

Water Refilling System List of Database Tables

Class Scheduling System Review of Related Literature

Class Scheduling System Review of Related Literature

Class Scheduling System Review of Related Literature

REVIEW OF RELATED LITERATURE AND STUDIES

This article suggests some significant literature and studies conducted which are important in the development of Class Scheduling System.

FOREIGN RELATED CONCEPTUAL LITERATURE

A literature is an article written by an authority. Related literature usually explains the concept being investigated, perhaps elucidate on the variables or factors that relate to this concept.

Class Scheduling System Review of Related Literature

Class Scheduling System Review of Related Literature

Barangay Management System Database Design

Barangay Management System Database Design

Barangay Management System Database Design

The barangay management system is an information system that will automate the records of barangay in the profiling of their inhabitant and other transactions as well.

This article is actually our database design for our barangay management system developed in Visual Basic and PHP, MySQL.

Barangay Management System Database Tables

Barangay Management System Database Tables