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

0
1599

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 Online 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 Online vehicle registration system.

Chapter one talks about introduction to Online 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 CONTENT

Title page                                                                                                       i          

Certification                                                                                                  ii

Approval                                                                                                       iii

Dedication                                                                                                     iv

Acknowledgement                                                                                       v

Abstract                                                                                                         vi

Organization of work                                                                                  vii

Table of content                                                                                           viii

CHAPTER ONE

1.0       Introduction                                                                                                  1

1.1       Statement of problem                                                                                  2

1.2       Aims and objectives                                                                                    2

1.3       Purpose of study                                                                                          3

1.4       Significant of study                                                                                     3

1.5       Scope/Delimitations                                                                        4

1.6       Limitations/Constraints                                                                              4

1.7       Assumption of study                                                                                   5

1.8       Definition of terms                                                              5                     

CHAPTER TWO

2.0       Literature review                                                                                          6

CHAPTER THREE

3.0       Description and analysis of the existing system                                     9

3.1       Fact-finding method/ methodology                                                           9

3.2       Organisational Structure/Organogram                                                      10

3.3       Objectives of the existing system                                                             10

3.4       Input, Process, and Output Analysis                                                         11

            3.4.1   Input Analysis                                                                                  11

            3.4.2   Process Analysis                                                                              11

            3,4.3   Output Analysis                                                                               11

3.5       Information Flow diagram                                                                          12

3.6       Problems of the existing system                                                                12

3.7       Justification of the new system                                                                 13

CHAPTER FOUR

4.0       Design of the new system                                                                           14

4.1       Design Standard                                                                                           14

4.2       Output specification and design                                                                14

4.3       Input specification and design                                                                   14

4.3.1   file design                                                                                          15

4.4       Procedure chart                                                                                            16

4.5       Systems flowchart                                                                                        17

4.6       System requirements                                                                                   18

            4.6.1   Hardware Requirements                                                                 18

            4.6.2   Software Requirements                                                                   18

            4.6.3   Operational Requirements                                                              18

            4.6.4   Personnel Requirements                                                                 18

CHAPTER FIVE

5.0       Implementation                                                                                            19

5.1       Design Standard                                                                                           19

5.2       Program design                                                                                             20

5.2.1   Program Flowchart                                                                           20

5.2.2   Pseudo code                                                                                      24

5.3       Coding                                                                                                           25

5.4       Test Data/Test Run                                                                                      31

5.5       User Training – An overview                                                                     31

5.6       Cutover Process                                                                                           31

CHAPTER SIX

6.0       Documentation                                                                                             32

6.1       The user documentation                                                                             32

6.2       The programmer documentation                                                               32

CHAPTER SEVEN

7.0       Recommendations, Summary and Conclusion                      33

7.1       Recommendation                                                                                         33

7.2       Summary                                                                                                       34

7.3       Conclusion                                                                                                    34

REFERENCES                                                                                                          35

CHAPTER ONE

1.0     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 Online vehicle registration system, it is necessary to mention here that information technology have a lot to play in achieving this. Implementing Online vehicle registration system entails having access to internet, having a website and the place of strong and reliable database can not be over emphasized.

Online 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.

1.1     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 Online vehicle registration system to alleviate these problems.

1.2             AIMS AND OBJECTIVES

The aims and objectives of this project is listed below:

v                 To develop a software that replaces manual filling and submission of registration form.

v                 To stop or solve the problems vehicles owners face during payment of various fee.

v                 To help the management in the effective distribution of vehicle licensing information.

v                 To help the management to ensure the effective collection of vehicles data.

v                 To help the management effectively manage vehicles data

All these contribute to make sure that vehicles’ data are well processed at right time.

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