DATA FEDERATION OF PUBLIC DATABASE OF NIGERIANS USING DATABASE LINKS AND WEB SERVICES

ABSTRACT

The project is the design and implementation of database federation of public database of Nigerians using database links and web services. It involves the design of a representative of the primary database that houses comprehensive information about Nigeria residences; other smaller databases representing some of the government agencies concerned with the issuance of different types of identification cards/documents and a website for a representative of government security agency that could request for information from all of the databases at any point in time, in order to profile any residence for security purposes. The various smaller databases have been set up to be able to access certain information (biodata) from the main database and to be able to append their specific information with unique identification numbers before issuing required identification cards to a requesting resident. The security agency has privileged access to some of the information stored in any of the databases through a dedicated web interface provided by the database. The system was tested, and the overall objective of the project was achieved.

                                                                   Table of Contents

CERTIFICATION.. ii

DEDICATION.. iii

ACKNOWLEDGEMENT. iv

ABSTRACT. v

LIST OF TABLES. Error! Bookmark not defined.

LIST OF FIGURES. viii

LIST OF FIGURES

Figure 2: Distributed ..............................................................................................12

Figure 3: Showing tightly -coupled ........................................................................14

Figure 4: Showing Loosely-coupled system...........................................................14

Figure 6: Relationship among components bodies.................................................26

Figure 7: Source code in visual studio environment...............................................47

Figure 8: Source code 2 in visual studio environment............................................48

Figure 9: NIMC landing page..................................................................................49

Figure 10: NIMC registration form ..........................................................................50

Figure 11: NIS registration form..............................................................................51

Figure 12: FRSC registration form..........................................................................52