Online School Documents Processing System Free Database Design Tutorial
Introduction
Table of Contents
It is possible to handle and process school documents online through the use of the Online School Documents Processing System (OSDPS), which is a web-based/online program. OSDPS enables schools to create and manage user accounts, upload and process documents, and generate reports, among other functions.
The proposed idea aims to fully automate the entire process of requesting and processing school documents from start to finish. In order to complete the document processing, both the students and the registrar’s office can transact electronically between themselves. Students can submit a request electronically through the use of the system. The request will be approved by the registrar’s office, and the certified copy of the document that students download will be processed by the registrar’s office. All documentation pertaining to students will be maintained in a consolidated database under the control of this system. The system will delete all physical copies of documents, as well as a plethora of other items that have taken up a significant amount of physical space. The paperwork are handled as quickly as possible, and requests for school documents are answered to in a timely and professional manner.
Benefits of the Online School Documents Processing System
The online school documents processing system provides a lot of advantages and benefits to users, some of which are as follows:
- Convenience and ease of use – The online school documents processing system is simple to use and handy to access from anywhere in the world, allowing users to do their tasks from any location.
- Efficiency in terms of time and money – The online school documents processing system minimizes the time and money spent on school documents processing by automating manual operations and replacing them with automated workflows.
- Cost-effectiveness – Because it is a cost-effective solution for huge volumes of files or records, the online school documents processing system helps to reduce labor costs.
- Security – The safe environment provided by the online school documents processing system aids in the preservation of the confidentiality of sensitive information and data collected.
Database Tables
Let’s start by making the tables and columns. For a thorough tutorial, please watch the video.
tbl_course – this table will store the course information in the system.
- course_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
- course_name – the name of the course.
- course_description – the description of the course.
Create SQL Statement – the statement below is used to create the tbl_course, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.
CREATE TABLE `tbl_course` ( `course_id` int(11) NOT NULL, `course_name` varchar(15) NOT NULL, `course_description` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
tbl_student – the student’s information will be stored in this table.
- student_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
- student_id_number – this is a unique number for the student’s ID
- first_name – the first name of the student
- middle_name – the middle name of the student
- last_name – the last name of the student
- course_id – this is a foreign key that points out to the course
- year_level – the student’s year level
- date_of_birth – the student’s date of birth
- gender – the gender of the student
- complete_address – the student’s complete address
- email_address – the student’s email address
- mobile_number – the student’s contact number preferrably a cellphone or mobile.
- username – the desired username of the student for his/her account
- password – the desired password of the student for his/her account
- account_status – active, inactive
Create SQL Statement – the statement below is used to create the tbl_student, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.
CREATE TABLE `tbl_student` ( `student_id` int(11) NOT NULL, `student_id_number` varchar(15) NOT NULL, `first_name` varchar(30) NOT NULL, `middle_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `course_id` int(11) NOT NULL, `year_level` int(1) NOT NULL, `date_of_birth` date NOT NULL, `gender` int(1) NOT NULL, `complete_address` int(11) NOT NULL, `email_address` varchar(30) NOT NULL, `mobile_number` varchar(15) NOT NULL, `username` varchar(30) NOT NULL, `password` text NOT NULL, `account_status` int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Visit the page on Online School Documents Free Template in Bootstrap
tbl_document_info – this table will store the information of school documents in the system.
- document_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
- document_name – the name of the school document
- description – the description of the document
- number_of_days_to_process – the number of days for the documents to be processed
- amount – the amount to paid for a specific documents
Create SQL Statement – the statement below is used to create the tbl_document_info, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.
CREATE TABLE `tbl_document_info` ( `document_id` int(11) NOT NULL, `document_name` varchar(30) NOT NULL, `description` varchar(100) NOT NULL, `number_of_days_to_process` int(2) NOT NULL, `amount` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
tbl_document_request – this table will store the information for the requested documents in the system.
- request_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
- control_number – the unique control number for the documents
- student_id – this is a foreign key that points out to the students
- document_id – this is a foreign key that points out to the document
- number_of_copies – the number of copies for the requested documents
- date_of_request – the date the document request was made
- date_of_releasing – the date when the document’s will be released
- processing_officer – user_id – this is a foreign key that points out to the processinf officer
- status – pending, paid, received
- remarks – the additional information for the requested documents
Create SQL Statement – the statement below is used to create the tbl_document_request, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.
CREATE TABLE `tbl_document_request` ( `request_id` int(11) NOT NULL, `control_number` varchar(15) NOT NULL, `student_id` int(11) NOT NULL, `document_id` int(11) NOT NULL, `number_of_copies` int(1) NOT NULL, `date_of_request` date NOT NULL, `date_of_releasing` date NOT NULL, `processing_officer` int(11) NOT NULL, `status` int(1) NOT NULL, `remarks` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
tbl_payment – the payment information will be stored in this table.
- payment_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
- request_id
- control_number – this is a unique control number for the payment
- total_amount – the total amount for the payment
- amount_paid – the amount paid for the documents
- date_of_payment – the date the payment was made
- proof_of_payment – the proof of the payment
- status – verified, rejected
Create SQL Statement – the statement below is used to create the tbl_payment, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.
CREATE TABLE `tbl_payment` ( `payment_id` int(11) NOT NULL, `request_id` int(11) NOT NULL, `control_number` varchar(15) NOT NULL, `total_amount` float NOT NULL, `amount_paid` float NOT NULL, `date_of_payment` date NOT NULL, `proof_of_payment` longblob NOT NULL, `status` int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
tbl_user – this table will store the information of the system’s users.
- user_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
- complete_name – the complete name of the user.
- designation – the user’s designation
- email_address – the email address of the user.
- phone_number – the contact number of the user preferrably cellphone or mobile number
- username – the user’s preferred username combined with the password to login to the system.
- password – the user’s preferred password to be used when logging in to the system.
- account_status – active, inactive
Create SQL Statement – the statement below is used to create the tbl_user, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.
CREATE TABLE `tbl_user` ( `user_id` int(11) NOT NULL, `complete_name` varchar(100) NOT NULL, `designation` varchar(30) NOT NULL, `email_address` varchar(30) NOT NULL, `phone_number` varchar(15) NOT NULL, `username` varchar(30) NOT NULL, `password` text NOT NULL, `account_status` int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Summary
Database systems are extremely significant in businesses because they provide a way for storing, managing, and accessing information. They can assist organizations in increasing the efficiency and effectiveness of their operations by allowing them to keep data in a consistent and structured fashion. Additionally, database systems can assist firms in better tracking and analyzing their data, which can result in more informed decision-making for the organization.
We hope that this article will help you and serve as a guide in the development of the project entitled Online School Documents Process System
Please watch the video tutorial that will be posted on our YouTube Channel.
Online School Documents Processing System Free Database Design Tutorial – Video Tutorial
You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive free capstone projects resources and computer programming tutorials.
Hire our team to do the project.
Online School Documents Processing with Payment System
Online School Documents Processing System Capstone Project
School Management System in Java
Top 35 Free School Related IT Capstone Project
