An Online Book-bank Monitoring System

IMPLEMENTATION
6.1 PROGRAMMING ENVIRONMENT

6.1.1 THE MONITORING SYSTEM
The relations were created using a script that runs on a database that was created on a command prompt. Primary keys uniquely identify all entries and checks aplication while foreign keys link tables and enhance referential integrity. Data manipulation that is inserting, deleting, retrieving and ordering of outputs for any search was done at this level.
The system  was  designed  under Linux environment to ensure better  security implementations. The database was done using MySql and PHP scripting because it’s fast processing especially under Internet access. Considering that the greatest expansion of the Internet came after the introduction of globally unique identifier to digital information (URL), the development of a Hyper Text Markup Language (HTML) and the compilation of a Hyper Text Transmission Protocol (HTTP), and forming World Wide Web in early 1990s (Terje, 2005) [11]. This means that since it is possible to access the information on the network, then HTML was used to design the web pages.

6.1.2 DATA MANIPULATION
SQL is used in the data manipulation i.e. inserting, deleting, retrieving and ordering of outputs for any search.

6.1.3 SCRIPTING
Scripting helps web pages come live by allowing the developer manipulate elements of a web page dynamically as a client browses that page. PHP was used to make the system dynamic. Codes written such that the database is searched in a predetermined format using a user supplied clue.

6.1.4 INTERFACE
The interface was designed using Hyper Text Markup Language (HTML). This makes up the overall graphical user interface in which PHP was embedded to carry the appropriate SQL queries that fetch data from MySql database.

6.2 FORM INPUT DESIGN
MySql and PHP are used to enter data, change data, view and print data. Forms offer the most convenient layout for entering data, changing data, and viewing database. The following are forms that were created.