SOFTWARE DESIGNS

4.1 DATA FLOW DIAGRAM

After interpretation of the data, tables were drawn and process of data determined to guide the researcher of the implementation stage of the project. The tools, which were employed during this methodology stage, were mainly tables, Data Flow Diagrams (DFDs) and Entity Relationship Diagrams (ERDs). The design ensures that only allows authorized users to access the system’s information.

                                                  Fig 1-DFD

4.2 CONTROL FLOW DIAGRAM

 System Architecture This gives a high level view of the new system with the main components of the system and the services they provide and how they communicate. The system is implemented using a three-tier architecture that      comprises of user interface, process management and DBMS.

4.3                                 DATABASE DESIGNA relational database design was used to design the database. A relational database management system (RDBMS) is an excellent tool for organizing large amount of data and defining the relationship between the datasets in a consistent and understandable way. A RDBMS provides a structure which is flexible enough to accommodate almost any kind of data. Relationships between the tables were defined by creating special columns (keys), which contain the same set of values in each table. The tables can be joined in different combinations to extract the needed data. A RDBMS also offered flexibility that enabled redesign and regeneration of reports from the database without need to re-enter the data. Data dictionaries were used to provide definitions of the data used; these included the final data structures for the various tables and their corresponding data fields, description and sizes .The user application programs and interface were developed using core java language (SQL) and MYSQL.

SQL is a language used to create, manipulate, examine and manage relational databases. SQL was standardized in 1992 so that a program could communicate with most database systems without having to change the SQL commands. Unfortunately one must connect to the database before sending SQL commands and each database vendor has a different interface as well as different extensions of SQL. Though SQL is well suited for manipulating database, it is unsuitable as a

Application language and programmers use it primarily as a means of communicating with databases, another language is needed to feed SQL statements to a database and process results for visual display or report generation. The advantage of java  and mysql  is that you can run their programs easily.

4.3.1 ENTITY-RELATIONSHIP DIAGRAM

                      

         Fig 3- ER Diagram