E-Ticketing 1

Shikshan Pasarak Mandal’s

Sahebrao Shankarrao Dhamdhere Arts & Commerce college,

Talegaon Dhamdhere, Tal. Shirur Dist. Pune

Certificate

This is to certify that Project entitled“ Bus Ticket Management System”

has satisfactorily completed by

Miss.Aishwarya Dilip Dhamdhere .( 39930 )

Miss. Sonali Bhagwan Bhujbal. (39929 )

as a requirement of T.Y.B.B.A(CA) (Semester V) Examination for the academic

year 2019-2020 as per syllabus of for Savitribai Phule Pune University .

Date :

Head of Department Principal

Internal Examiner External Examiner

 E-Ticketing 2

INDEX
Contents

1. Introduction
i. Company Profile.
ii. Introduction to System
iii. Existing System
iv. Proposed System

2. Analysis
i. Fact Finding Technique
ii. Feasibility Study
iii. Hardware & Software Requirements

3. System Design
i. E-R-Diagram
ii. Context Level Diagram
iii. Data Flow Diagram

4. Form Design

5. Reports
i. Advantages and Limitations
ii. Future Enhancement
iii. Bibliography
 E-Ticketing 3

OVERVIEW OF THE PROJECT

INTRODUCTION

Electronic Bus Ticketing

The ticket machines would end the use of the hefty 1.5-kg ticket racks carried by

conductors. It would also end the practice of tearing out tickets and marking fare stages. The Conductor

would just have to key in the details about the fare stage and the ticket machine would print out the

ticket. The machine weighs only 800 grams and is convenient to carry. The parameters are almost like

that of a railway ticket, the only difference being that the machine is portable. The machine can print

out 2,300 tickets, including the journey report in order to facilitate inspection by the corporation's

checking inspectors. The ticket machines would help prevent loss on account of malpractice. It would

also help in providing adequate data to the corporation, particularly with regard to the boarding of

passengers from fare stages and important points. This would help the corporation prepare and organize

its schedules more efficiently on the basis of traffic demand. Besides, it would provide data on

concessions given to various sections. Another additional feature is that the data in the ticket machine

could be fed into the computer. More over the depots of the corporation would be fully computerized

so we want to add some other modules in our domain for depot’s verification.

This project is modularized as the following:

 Management of Route

 Trip Details

 Bus Details

 Bus Stops

 Bus Ticketing
 E-Ticketing 4

1. Management of Routes

This module include information about how we can Manage the routes for a

particular bus services so In the case of Route management module we must know the details about

route number, number of stops ,fare stages and running time of the particular bus more over we want

to manipulate and stored these information successfully.

2. Trip information

Each journey is identified as a trip. Each ticket must contain the trip no so that

calculation of passenger can be done easily. Here in this section we want to know start time and route

no of the bus this information can be manipulate and stored successfully.

3. Bus Detail

In this module all bus details are stored and manipulated, in bus detail module

contains minimum charge, type, depot, fare increment, bus number, and passenger’s states (child or

adult) are manipulate and stored.

4. Bus Stops

Bus Stops module includes information about what are the main bus stops of a particular

bus. This module connected to the route of the bus and it is used to store stop number, stop name and

fare stages and Route number

5. Bus Ticketing

Ticketing is the most important module in this Project which uses all the tables together and

calculates fare for the passengers. Venting the tickets is done using the route number, bus type,
 E-Ticketing 5

beginning stop, end stop, ticket number, persons(Adult/child)rate, date and time also we want to

print the all these information. In order to do the calculation data has to be pulled out from stops,

bus, trip and route.Number of passengers & the states are entered by the Venter and to produce the

tickets.
 E-Ticketing 6

SYSTEM STUDY AND ANALYSIS

Fact Finding System

1.Preliminary investigation :-
To design the system or to solve any problem related to the system we must study the
system deeply. To get deeper knowledge about system we should examine the existing
system many times, ask question to different people, note down the important points
studies different papers, registers related to system etc.

2.Interviews:-
Asking about therules of Car Showroom management & how the work is conducted,
what are the requirement to the different teacher &student.

3.On site observation:-

By visiting the Car Showroom , I get the information about Car Showroom details
& transaction details. This system which help me to understand the system, I have
studied different Car Showroom manuals, different reports, different form etc. and get
more knowledge about the system.

4. Questionnaires:-
By questioning to the staff & principal we get the answer for queries in our mind.
The success of collecting data through a questionnaire help to design system. The open
response questionnaires are used to learn about the opinion, feeling.
 E-Ticketing 7

FEASIBILITY STUDY

An important outcome of the preliminary investigation is the determination that

the system requested is feasible. Feasibility study is carried out to select the best system

that meets the performance requirements.

Feasibility study is both necessary and prudent to evaluate the feasibility of the

project at the earliest possible time. It involves preliminary investigation of the project

and examines whether the designed system will be useful to the organization. Months or

years of effort, thousand for millions of money and untold professional embarrassment

can be averted if an in-conceived system is recognized early in the definition phase.

The different types of feasibility are: Technical feasibility, Operational

feasibility, Economical feasibility.

Technical feasibility

Technical Feasibility deals with the hardware as well as software requirements.

Technology is not a constraint to type system development. We have to find out whether

the necessary technology, the proposed equipments have the capacity to hold the data,

which is used in the project, should be checked to carryout this technical feasibility.

The technical feasibility issues usually raised during the feasibility stage of
 E-Ticketing 8

investigation includes these

 This software is running in windows 2000 Operating System, which can be easily

installed.

 The hardware required is Pentium based server.

 The system can be expanded.

Behavioral Feasibility

This feasibility test asks if the system will work when it is developed and

installed.

Operational feasibility in this project:

 The proposed system offers greater level of user-friendliness.

 The proposed system produces best results and gives high performance. It can be

implemented easily .So this project is operationally feasible.

Economical feasibility

Economical Feasibility deals about the economical impact faced by the

organization to implement a new system. Financial benefits must equal or exceed the

costs. The cost of conducting a full system, including software and hardware cost for the

class of application being considered should be evaluated. Economic Feasibility in this

project:

 The cost to conduct a full system investigation is possible.

 There is no additional manpower requirement.

 There is no additional cost involved in maintaining the proposed system.

 E-Ticketing 9

SYSTEM SPECIFICATION

1. Hardware Specification

Processor : Intel Pentium IV 2.4 GHZ or above

Clock speed : 500 MHZ

System bus : 32 bits

RAM : 256MB of RAM

HDD : 40 GB or higher

Monitor : SVGA COLOR

Keyboard : 108 keys

Mouse : 2 button mouse

2.Software Specification

OS : MS WINDOWS XP SP2

Front End : Visual Basic 6.0

Back End : MS ACCESS 2003

 E-Ticketing 10

EXISTING SYSTEM

Existing system refers to the system that is being followed till now. The existing system requires more

computational time, more manual calculations, and the complexity involved in Selection of features is

high. The other disadvantages are lack of security of data, Deficiency of Data accuracy, Time

consuming etc.To avoid all these limitations and make the working more accurately the system needs

to be computerized. Here in the Electronic bus ticketing, a detailed study of existing system is carried

along with all the steps in system analysis.

1Draw backs of existing system.

Here in the Electronic bus ticketing, a detailed study of existing system is carried along with all the

steps in system analysis. An idea for creating a better project was carried and the next steps were

followed.

 Lack of security of data.

 More man power.

 Time consuming.

 Consumes large volume of pare work.

 Needs manual calculations.

 No direct role for the higher officials.

 Damage of machines due to lack of attention.

To avoid all these limitations and make the working more accurately the system needs to be

computerized.
 E-Ticketing 11

PROPOSED SYSTEM
The aim of proposed system is to develop a system of improved facilities. The

proposed system can overcome all the limitations of the existing system. The system provides proper

security and reduces the manual work. The existing system has several disadvantages and many more

difficulties to work well. The proposed system tries to eliminate or reduce these difficulties up to some

extent. The proposed system will help the user to reduce the workload and mental conflict. The

proposed system helps the user to work user friendly and he can easily do his jobs without time

lagging.

1. Advantages of Proposed System

The system is very simple in design and to implement. The system requires very

low system resources and the system will work in almost all configurations. It has got following

features

 Ensure data accuracy.

 Minimize manual data entry.

 Minimum time needed for the various processing

 Greater efficiency

 Better Service

 Minimum time required

 The ticket machines would help prevent loss on account of malpractice

 E-Ticketing 12

 It would also help in providing adequate data to the corporation, particularly with regard

to boarding of passengers from fare stages and important points

 This would help the corporation prepare and organize its schedules more efficiently on

the basis of traffic demand.

 It would provide data on concessions given to various sections.

 Another additional feature is that the data in the ticket machine could be fed into the

computer.
 E-Ticketing 13

Data Flow Diagram

Context Diagram

Passenger Details
details
Administrator E- Ticketing Administrator

Level 1 DFD Administrator

Route management

Administrator E- Ticketing View Bus Details

Admin id, Bus details

password

Admin
Login details Bus Ticketing

Verify Trip information

Validate Login

Bus Stop
 E-Ticketing 14

CONTEXT LEVEL DIAGRAM

ENTER USER ID
& PASSWORD GETS ACCESS

ADMIN ADMIN
ENTER DETAILS E-TICKETINGGETS TICKET
(ELECTRONIC
TICKET
MACHINE)
USER USER
 E-Ticketing 15

ERD
 E-Ticketing 16

START END
CHILD BUS
PLACE PLACE
NUMBER

ADULT DEPENDS
TICKETING ON
BUS
DET

TOTAL
FARE LAST STO

DEPENDS
ON

NUMBER
OF STOPS
STARTING
STOP
ROUTE
NUMBER ROUTE
DETAILS
LAST STOP

FARE
STAGES

HAS

STOP NAME
BUS STOP
DETAILS

FARE STAGE
ROUTE
NUMBER STOP
NUMBER
 E-Ticketing 17

Table Name: - Login

Primary key: User Name

Table Name: - Route management

Primary Key: Routenumber

Table Name: - Busdetails

Primary Key: Busnumber

 E-Ticketing 18

Table Name: - Busstop

Table Name: - Trip

Primary Key: Routenumber

Table Name: - Ticketing

Primary Key: Bus number

E-Ticketing 19
 E-Ticketing 20

APPENDIX

Sample Screen Shots

Login

Main Form
 E-Ticketing 21

Route Management

Bus Stop

Bus details
 E-Ticketing 22

Trip Information

Ticketing
E-Ticketing 23
 E-Ticketing 24

CONCLUSION&FUTURE ENHANCEMENT

The project E-Ticketing is completed, satisfying the required design specifications. The system

provides a user-friendly interface. The software is developed with modular approach. All modules in

the system have been tested with valid data and invalid data and everything work successfully. Thus

the system has fulfilled all the objectives identified and is able to replace the existing system. The

constraints are met and overcome successfully. The system is designed as like it was decided in the

design phase. This software has a user-friendly screen that enables the user to use without any

inconvenience. The ticket machines would end the use of the hefty 1.5-kg ticket racks carried by

conductors. Instead, the conductor would just have to key in the details about the fare stage and the

ticket machine would print out the ticket. The machine weighs only 800 grams and is convenient to

carry. The parameters are almost like that of a railway ticket, the only difference being that the machine

is portable. It would also help in providing adequate data to the corporation, particularly with regard to

the boarding of passengers from fare stages and important points. This would help the corporation

prepare and organize its schedules more efficiently on the basis of traffic demand. Besides, it would

provide data on concessions given to various sections. Another additional feature is that the data in the

ticket machine could be fed into the computer.

The application has been tested with live data and has provided a successful result.

Hence the software has proved to work efficiently.

 E-Ticketing 25

BIBLIOGRAPHY

BOOKS:

1. Charles Hampfed (2000) ‘Visual Basic’ University of

Toronto

2. Herbert Schildt (2000) ‘Visual Basic 6.0’ Tata McGraw Hill

3. John Zukowski (2000) ‘Visual Basic 6.0’ ‘BPB Publications

4. Jamie Jaworsky ‘Visual Basic 6.0’Techmedia

5. StefenDenninger ‘Visual Basic 6.0’Author’s Press

6. Ian Somerville ‘Software engineering’

7. Rajeev mall ‘Software engineering’

8. ElmasriNavathe ‘Fundamentals of database systems’

ONLINE REFERENCE:

www.w3schools.com

www.theserverside.com

www.visual.com
 E-Ticketing 26

ADVANTAGES OF ONLINE BUS TICKET BOOKING

 Online bus ticket booking is the easiest way to book tickets

online.

 Can easily book the bus tickets with the options like

Ac,Non-Ac,Sleeper,Semi Sleeper and Luxury Buses at best

rates .

 Minimum time required .

 Minumum time needed for the various processing .

 Timeless efforts .

 Saves money with discounts .

 E-Ticketing 27

DISADVANTAGES OF ONLINE BUS TICKET BOOKING

 You need internet access .

 If may not always be the right choice, especially if you

have special needs .

 Many online travel sites advertise low rates for attention .

 Many travel websites cant handle complicated

itineraries .

 Some small inns and tour guides may not have an

online presence .
 E-Ticketing 28

THANK YOU

!!!