1.1 INTRODUCTION/PROJECT CONTEXT
In today’s technology, most of big institutions like Systems Plus College Foundation, Holy Angel University, Angeles University here in Pampanga already adopted hi-tech enrollment system compare with Public Schools. If you are from Public Schools, you might remember that you experience long lines before you can actually enroll yourself, plus too many things to fill up. Currently, DHVTSU is still using manual enrollment as of now, this is why we made up an idea on how to improve their enrollment by creating a new system which focus on enrollment only.
One more reason is paper works or personal records can be easily lost, or sometimes if accident occurs like fire, then all files we’re lost, since you cannot backup those files. With the use of Computerized Enrollment System, you will be 100% comfortable when it comes to records, they are safe which is stored on a MySQL database with a backup during enrollment process in case the system fails, but most likely will not happen since the code is simple and just focuses on enrolling, and looking on the records. 1.2 STATEMENT OF THE OBJECTIVE
This section present the objectives of the study and has been classified into two objectives: 1.2.1 General Objective
The general objective of the proposed study is to provide “Computerized Enrollment System” for Public Schools that will manage and monitor the records of the whole institution. 1.2.2 Specific Objectives
In line with the stated general objective, the study aims to achieve the following specific objectives: To develop a system to make all public schools turn their enrollment online To make it low-cost as possible so all public schools can afford Ability to search for specific records
To Completely remove paper works and adopt this system
1.3 SCOPE AND LIMITATIONS
The Scope and Limitations will determine the flow of the proposed system. It will show the attributes that are included and the limits of the proposed project:
The system is easy to use, as we all know most of the faculty of a Public School are already 50 + and we created the system to suit those ages. We develop a good yet simple system for enrollment. The system can search all records with first name, last name, or students that live with the same area, or list all students enrolled on this section. The system will be hosted locally to avoid SQL Injections and to make the system faster compare on hosting it online, security threats, slow processing since it hosted on another place 1.3.2 Limitations
There is no student portal similar to SPCF Campus ++ since some students can’t afford on having a computer at home, so no sense on adding this features to focus more on just enrollment system. And yes we are just Enrollment System and not a Student Portal. The System does not have inquiry module regarding grades of the students. 1.4 SIGNIFICANCE OF THE STUDY
By this study they will come up with easier and powerful program that will benefit both school and students, first the student, they will be just having short period of time when enrolling their self since they will just present their birth certificate, face the camera (our system is develop with storing pictures) and viola, you are now enrolled on this specific school. Second is the school, not just the students will benefit but the school also, this system is affordable, by just setting up 3 – 5 Computers, get a 1 router (no internet access since it will be running locally) and you are ready to go. Plus all student records are already stored on a secured database provided by MySQL.
REVIEW OF RELATED LITERATURE AND STUDIES
2.1 Technical Background
It is a network of networks that consists of millions of private, public, academic, business, and government networks, of local to global scope, that are linked by a broad array of electronic, wireless and optical networking technologies. The internet is use in the proposed system to transfer information that will be accessible on the Web. 2.1.2 Web Browser
Web Browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier (URI) and may be a web page, image, video, or other piece of content. A web browser can also be defined as an application software or program designed to enable users to access, retrieve and view documents and other resources on the Internet. In the proposed system web browser is used to access the site a media that can open a web site. In order to read HTML documents. 2.1.3 HTML 5
HTML5 is a core technology mark-up language of the Internet used for structuring and presenting content for the World Wide Web. It is the fifth revision of the HTML standard (created in 1990 and standardized as HTML 4 as of 1997). 2.1.4 CSS
Stands for Cascading Style Sheets, a feature added to HTML that gives both
Web site developers and users more control over how pages are displayed. With CSS, designers and users can create style sheets that define how different elements, such as headers and links, appear. These style sheets can then be applied to any Web page. 2.1.5 XAMPP
XAMPP is a free and open source cross-platform web server package, consisting mainly of the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP and Perl programming languages. It is used as a development tool, to allow website designers and programmers to test their work on their own computers without any access to the Internet. 2.1.6 MySQL DATABASE
MySQL is a simple, yet powerful Open Source Software relational database management system that uses SQL.
2.2 Related Studies and Literature
The introduction of computers and word-processing equipment into business and government has resulted in an information explosion and caused an increase in records volume of incredible proportions. Offices are most affected by this growth because much of the information is channelled into the business or governmental office in the form of records for administrative use.
As you can see big companies using computers also for their records, which is most likely develop via PHP, Java, or C++. Big companies are using their own record system which cost big bucks for sure.
Our enrollment system will be changing how public schools registrations will go by. No more long lines, hassle for teachers and students, records are safe, and mostly convenient.
This is one of great technology invented, it is where your data are stored, example of database provider are MyQSL, MSSQL, SQL of Java and etc. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. In computing, databases are sometimes classified according to their organizational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network. An object-oriented programming database is one that is congruent with the data defined in object classes and subclasses. Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogues and inventories, and customer profiles.
Typically, a database manager provides users the capabilities of controlling read/write access, specifying report generation, and analyzing usage. Databases and database managers are prevalent in large mainframe systems, but are also present in smaller distributed workstation and mid-range systems such as the AS/400 and on personal computers. SQL (Structured Query Language) is a standard language for making interactive queries from and updating a database such as IBM’s DB2, Microsoft’s SQL Server, and database products from Oracle, Sybase, and Computer Associates. Database is important in our system since it will be used on storing all student records, data types of database is important to avoid SQL Injections(if you will host it online) but if you will use it locally, SQL Injections are impossible, since you are just the one who have access on your database.
2.4 HTTP / Apache
Often referred to as simply Apache, a public-domain open source Web server developed by a loosely-knit group of programmers. The first version of Apache, based on the NCSA httpd Web server, was developed in 1995. Core development of the Apache Web server is performed by a group of about 20 volunteer programmers, called the Apache Group. However, because the source code is freely available, anyone can adapt the server for specific needs, and there is a large public library of Apache add-ons. In many respects, development of Apache is similar to development of the Linux operating system. The original version of Apache was written for UNIX, but there are now versions that run under OS/2, Windows and other platforms.
Apache is also important on our system since we develop our system using PHP, we used XAMPP to accommodate all our system needs like MySQL and Apache. XAMPP can run our whole system without any add-ons, that’s the best thing with XAMPP, he can handle your whole system, built in MySQL databases, Apache, includes FileZilla also for FTP.