DESIGN AND IMPLEMENTATION OF COMPUTERIZED VEHICLE REGISTRATION SYSTEM CASE STUDY OF ENUGU STATE LICENSING OFFICE

0
588

ABSTRACT

Vehicle registration system is an information system with a strong database that is used to record vehicle information. Database is an organized collection of information, data, or citations stored in electronic format that can be searched for specific information or records by techniques specific to each database.

Vehicle registration system is also a database program used to electronically collect data, process it and also store it for future use.

This Vehicle registration system program implements the techniques of database normalization. Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

The program deal on computerized Vehicle registration system. The sore purpose of this program is to enhance and facilitate the Management approach to information collection and storage for future use.

This project work is implemented with visual basic programming and Microsoft Access.

ORGANIZATION OF WORK

            This project work is primarily designed to give an insight to computerized vehicle registration system.

            Chapter one talks about introduction to computerized vehicle registration system, study of problem and objectives as well as definition of the scope.

            Chapter two comprises the literature review. Chapter three gives the detailed information about the existing (old) system, while chapter four and five deals with the design and implantation of new system.

            Chapter six document the project work, while chapter seven summaries,  conclusion and suggestions were made.

TABLE OF CONTENTS

Title page                                                                                                        i

Certification                                                                                                    ii

Dedication                                                                                                      iii

Acknowledgement                                                                                          iv

Abstract                                                                                                          v

Table of contents                                                                                            vii

CHAPTER ONE

INTRODUCTION                                                                                         1

1.1       Background of the study                                                                    1         

1.2       State of the problem                                                               2

1.3       Purpose of the study                                                               3

1.4       Aims and objectives                                                                3

1.5       Scope of study                                                                                    5

1.6       Limitations of study                                                               5

1.7       Assumptions                                                                           6

1.8       Definition of terms                                                                             7

CHAPTER TWO

LITERATURE REVIEW                                                                  8

CHAPTER THREE

  • Description and analysis of existing system                           15
    • Fact finding method used                                                                   17
    • Organization structure                                                                        19
    • Objectives of Existing system                                                            21
    • Input, Process and Output Analysis                                       22
    • Information Flow Diagrams                                                   26
    • Problems of the Existing System                                            27
    • Justification of the New System                                                         28

CHAPTER FOUR

  • Design of the New System                                                     30
    • Input Specification and design                                                           30
    • Output specification and design                                                         32
    • File Design                                                                                          34
    • Procedure chart                                                                                   36
    • System flow chart                                                                               38
    • System requirements                                                               40       

CHAPTER FIVE

  • Implementation                                                                                   42
    • Program Design                                                                                  45
    • Program Flowchart                                                                 48
    • Pseudo code                                                                                        54
    • Source Program: Test Run                                                      59

CHAPTER SIX       

Documentation                                                                                               60

CHAPTER SEVEN

  • Recommendation                                                                                62
    • Conclusion                                                                                          64

Bibliography                                                                           65

1.0                                                CHAPTER ONE

INTRODUCTION

A vehicle registration plate is a metal or plastic plate attached to a motor vehicle or trailer for official identification purposes. The registration identifier is a numeric or alphanumeric code that uniquely identifies the vehicle within the issuing region’s database. In some countries, the identifier is unique within the entire country. In others, it is unique within each state or province. There is also variation on whether the identifier is associated with a vehicle or a person. Depending on the country or region of issue, it may also be referred to as a license plate, number plate, vehicle tag, license tag, or simply tag.

            As I consider the design and implementation of computerized vehicle registration system, it is necessary to mention here that information technology have a lot to play in achieving this. Implementing computerized vehicle registration system entails having access to internet, having a website and the place of strong and reliable database can not be over emphasized.

Computerized Vehicle registration system is an information system use to track the record of the vehicles that are use in our nation. It is use by the management to effectively record, process and monitor effectively the records of vehicles.

Most governments require a registration plate to be attached to both the front and rear of a vehicle, although certain jurisdictions or vehicle types, such as motorcycles, only require one plate, which is usually attached to the rear. National databases relate this number to other information describing the vehicle, such as the make, model, color, year of manufacture, engine size, type of fuel used and mileage recorded during the vehicles annual (or bi-annual) road worthiness test, Vehicle identification (Chassis) Number and the name and address of the vehicle’s registered owner or keeper.

In some jurisdictions, these registration plates will be permanently assigned to that particular vehicle for its lifetime. Some countries permit the re-registration of the vehicle with “personal” (“vanity” or “Cherished Mark”) plates. When the vehicle is destroyed or exported to a different country it will require re-registering in the country of import. China requires the re-registration of any vehicle that crosses its borders from another country, such as overland holiday tourist visits, regardless of the amount of time it is due to remain there; this has to be arranged with prior approval.

A vehicle license is a permit issued by a state government allowing vehicle owners access to road network and infrastructure around the country. Vehicle licenses are renewed annually and show:

The ownership of a vehicle

The vehicle registration number

Owner’s address

Vehicle engine number

License expiration month

Vehicles are levied according to the load capacity of the vehicle and the purpose of use i.e. private or commercial usage.

            STATEMENT OF THE PROBLEM

            Owing to (i) the difficulties vehicle owners encounter in manual filling and submission of registration forms (ii) time wasted in getting information from vehicle registration officers on how to fill the form. (iii) Loss of some submitted forms due to mismanagement and (iv) Long queue the vehicles owners face in collecting their payment Receipts, the need arises for the development of computerized vehicle registration system to alleviate these problems.

DESIGN AND IMPLEMENTATION OF COMPUTERIZED VEHICLE REGISTRATION SYSTEM CASE STUDY OF ENUGU STATE LICENSING OFFICE