WEB BASED VEHICLE BOOKING SYSTEM FOR TRANSPORT COMPANY A CASE STUDY OF GOSHEN TRANSPORT COMPANY, IKOT EKPENE

0
1286

ABSTRACT

This research work focused on the development of a web based vehicle booking system using Goshen Transport Company in Ikot Ekpene as case study. The problems identified in the existing system that necessitated the developemt of the web based vehicle booking system include: passengers cannot book for transportation online because of the absence of a web based vehicle booking system, it is difficult to retrieve passengers booking information reports when needed, manual recording of booking and ticket information is tedious, time consuming and easily misplaced and long queues at the park. The objectives of the study include to: create a system that will aid passenger transit booking online, develop a system that will submit booking information to an online database and to implement a system that can be used to verify booking information of passengers. The significance of the study is that it will enable passengers to easily book for transit online. The software development methodology used is waterfall development methodology and the programming language used for the development of the study is Hypertext-preprocessor (pHp) and MySql database. It was concluded that a web based vehicle booking system is very useful as it enables organizations to be more efficient in their keeping transportation record operations. It is recommended that more research should be encouraged on the development of web based vehicle booking systems.

TABLE OF CONTENTS

Title Page             –        –        –        –        –        –        –        –        i

Certification         –        –        –        –        –        –        –        –        –          ii

Approval Page     –        –        –        –        –        –        –        –        iii

Dedication            –        –        –        –        –        –        –        –        iv

Acknowledgment –        –        –        –        –        –        –        –        v

Abstract               –        –        –        –        –        –        –        –        vi

Table of Contents –        –        –        –        –        –        –        –          vii

List of Figures      –        –        –        –        –        –        –        –        viii

List of Tables       –        –        –        –        –        –                  –        ix

CHAPTER ONE: INTRODUCTION

1.0     Introduction         –        –        –        –        –        –        –        1       

1.1     Background of the Study        –        –        –        –        –        –        1

1.2     Statement of Problem              –        –        –        –        –        2

1.3     Aim and Objectives of the Study      –        –        –        –        2

1.4     Significance of the Study         –        –        –        –        –        –        2-3

1.5     Scope of the Study        –        –        –        –        –        –        –        3

1.6     Organization of Research        –        –        –        –        –        –        3

1.7     Definition of Terms       –        –        –        –        –        –        4

CHAPTER TWO: LITERATURE REVIEW

  •      Introduction         –        –        –        –        –        –        –        –        5

2.1     Theoretical Background –        –        –        –        –        –        5-8

2.2     Background of the Nigerian Road Passenger

Transport Service –        –        –        –        –        –        –        9

2.3     Strategic Planning and its Impact on Transport Companies9-11

2.4     Transportation Planning         –        –        –        –        –        –        11

2.4.1  Vehicle Operators          –        –        –        –        –        –        –        12-13

2.4.2  The Transport Officer’s Role  –        –        –        –        –        14

2.4.3  Vehicle Planning: the Main Steps     –        –        –        –        14-15

2.4.4  Vehicle Planning: Other Procedures  –        –        –        –        15-16

2.4.5  Monitoring Results        –        –        –        –        `-       –        16

2.5     Web-based Information System Overview –        –        –        16-17

CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN

3.0     Introduction         –        –        –        –        –        –        –        –        18     

3.1     Description of the Existing System   –        –        –        –        18

3.2     Analysis of the Proposed System     –        –        –        –        18-19

3.2.1  Advantages of the Existing System  –        –        –        –        19

3.2.2  Disadvantages of the Existing System        –        –        –        –        19

3.3     Analysis of the Proposed System     –        –        –        –        19-20

3.4     System Design     –        –        –        –        –        –        –        20

3.4.1  Input Layout        –        –        –        –        –        –        –        –        21

3.4.2 Output Layout      –        –        –        –        –        –        –        25

3.4.3  Algorithm   –        –        –        –        –        –        –        –        23     

3.4.4  Program Flowchart       –        –        –        –        –        –        –        24-27

3.4.5  Database Design  –        –        –        –        –        –        –        28

3.4.6  System Architecture      –        –        –        –        –        –        29

3.4.7  Use Case Diagram         –        –        –        –        –        –        –        29

CHAPTER FOUR: SYSTEM IMPLEMENTATION

4.0     Introduction                  –        –        –        –        –        –        –        30     

4.1     System Design Diagram –        –        –        –        –        –        30     

4.2     Choice of Programming Language              –        –        –        30

4.3     Analysis of Modules               –        –        –        –        –        30-31

4.4     Programming Environment     –        –        –        –        –        31

4.4.1  Hardware Requirements          –        –        –        –        –        31

4.4.2  Software Requirements  –                  –        –        –        31

4.5     Implementation              —       –        –        –        –        –        32

4.6     Software Testing  –        –        –        –        –        –        –        32

CHAPTER FIVE: SUMMARY, RECOMMENDATION AND CONCLUSION

5.0     Introduction                   –        –        –        –        –        –        –        33

5.1     Constraints of the Study         –        –        –        –        –        –        33

5.2     Summary                       –        –        –        –        –        –        33     

5.3     Conclusion                     –        –        –        –        –        –        34

5.4     Recommendations                   –        –        –        –        –        –        34

References                      –        –        –        –        –        –        35

          Appendix A         (Source Code)     –        –        –        –        –        36-44

          Appendix B         (Output)     –        –        –        –        –        –        45-50

LIST OF FIGURES

                                                                             Page Number

Fig.  2.1 Booking registration form layout –        –        –        8

Fig.  3.1: Vehicle Booking Input Layout    –        –        –        21

Fig   3.2: Main Menu flowchart        –        –        –        –        –        24

Fig.  3.3: Booking Record flowchart –        –        –        –        25

Fig.  3.4: Verify booking record flowchart –        –        –        26

Fig 3.5: View database  record flowchart   –        –        –        27

Fig 3.6: System Architecture   –        –        –        –        –        29

Fig 3.7: Use case Diagram       –        –        –        –        –        29

Figure 4.1: System design diagram   –        –        –        –        30

LIST OF TABLES                                                           Page Number

Table 3.1:Booking Database Design –        –        –        –        28

Table 3.2: Booking record output layout   –        –        –        22

CHAPTER ONE

INTRODUCTION

1.0 Introduction

This chapter presents the introduction to web-based vehicle booking system. It presents the introduction, background of the study, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.

1.1 Background of the Study

Transportation is concerned with the movement of passengers, goods and services, from one place to the other. To effectively carry out their duties, they keep record of transportation information such as booking information, manifest records and vehicle movement records. This information needs of transportation companies, captured on a daily basis, enables the management of the transport companies to effectively monitor operations and helps in the confirmation of relevant details as it pertains to passengers and the movement of transporting vehicles. Many transportation companies have implemented automated transit information systems to aid in proper record and information management. The overall objective is to provide a web based vehicle booking system to help meet the transportation needs of the customers.

A web based vehicle booking system enables passengers to book for seats online to avoid waiting on long queues before they can travel. Without a web-based vehicle booking system, it will be difficult to obtain needed reports related to transit details such as, booking reports for different destinations, financial information of amount of tickets sold for different destinations, etc. Transportation companies therefore need to implement a web based vehicle booking system to properly manage transportation information. 

1.2 Statement of Problem

The following problems were identified in the existing system:

  1. Passengers cannot book for transportation online because of the absence of a web based vehicle booking system.
  2. It is difficult to retrieve passengers booking information reports when needed.
  3. Manual recording of booking and ticket information is tedious, time consuming and easily misplaced.
  4. Long queues at the park

1.3 Aim and Objectives of the study

The aim of the study is to develop a web based vehicle booking system. The following are the objectives of the study:

  1. To create a system that will aid passenger transit booking online.
  2. To develop a system that will submit booking information to an online database.
  3. To implement a system that can be used to verify booking information of passengers.
  4. To create a system that can be used to obtain vehicle transit reports when needed.
WEB BASED VEHICLE BOOKING SYSTEM FOR TRANSPORT COMPANY A CASE STUDY OF GOSHEN TRANSPORT COMPANY, IKOT EKPENE