Results Computation System In Higher Institutions Using Php, Html, Css, Mysql

CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION
4.1    Introduction
A system is an organized collection of inter related subsystems with a collective responsibility of meeting a goal. Dependent subsystems are regularly interacting while independent group of components forming a unified whole work stand alone in achieving a specified task.
A system is also defined as an organized or complex unitary whole. System Analysis is therefore the study of the systems’ processes including investigation of inputs and outputs in order to find better, more economical and efficient means of processing data (D.I. Cleland and W.R. King, 1975).
4.2    System Design
Conceptualizing a system design is done in two modeling phase:
i.    Data Modeling: This phase involves detecting the various data entries of the system and analyzing its attributes and the relationship amongst the data entries.
ii.    Function Modeling: On the other hand, this phase describes how the data entities are to be processed to achieve a desired solution on the path of solving the identified problem.
The purpose of the system design is to effectively divide the overall problems into small and more manageable problems that can be easily handled by separate program modules. The separate program modules will later be integrated forming the entire system.
Languages used in the course of this project are;
i.    HTML and CSS for Design
ii.    JavaScript for Client-Side Scripting
iii.    PHP for Server-Side Scripting
iv.    MySQL as Database backend (via SQL)
The following Softwares were also used to achieve the aim and objectives of this project;
i.    Adobe Dreamweaver CS5
ii.    Notepad ++ Text Editor
4.2.1    Choice of Programming Languages
The System is developed as a Web-Based Application owing to a number of reasons:
-    Web Based Systems are Ubiquitous (They are easily accessed as long as there is a network).
-    It is by default, a Server/Client Model system and this helps to ensure information uniformity.
-    PHP is used as Programming Language because it is Open Source, Easy and can handle large tasks in minimum time.
-    MySQL is used as Database Backend for its reliability, security and ability to handle really large information.
4.2.2    Database Design
The Database was designed involving a number of tables that are used to store and retrieve information. These are: