Online Transport System
A Dissertation submitted in partial fulfilment of the
requirements for the award of degree of
MASTER OF COMPUTER APPLICATIONS
Of
Visvesvaraya Technological University
By
RESHMA B
Reg. No. 4KV14MCA05
Under the Guidance of
Dr. K. JOTHIMANI
MCA, PhD, MISTE
Assistant Professor
Dept. of MCA
DEPARTMENT OF MASTER OF COMPUTER APPLICATION
K.V.G COLLEGE OF ENGINEERING
(AFFILIATED TO VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELAGAVI)
SU LLIA '574 327
June 2017
Online Transport System
A Dissertation submitted in partial fulfilment of the
requirements for the award of degree of
MASTER OF COMPUTER APPLICATIONS
Of
Visvesvaraya Technological University
By
RESHMA B
Reg. No. 4KV14MCA05
Under the guidance of
Internal Guide External Guide
Dr. K. JOTHIMANI Mrs. JISHA T K
MCA, PhD, MISTE Software Engineer
Assistant Professor NIIT
Dept. of MCA Kannur
jothi1083@yahoo.co.in tkjisha@gmail.com
DEPARTMENT OF MASTER OF COMPUTERAPPLICATIONS
K.V.G COLLEGE OF ENGINEERING
(AFFILIATED TO VISVESVA RAYA TECHNOLOGICAL UNIVERSITY, BELAGAVI)
SULLIA '574 327
June 2017
Declaration
I, RESHMA B, student of 6thsem MCA. K.V.G.College of Engineering, bearing USN
4KV14MCA05 hereby declare that the project entitled ONLINE TRANSPORT SYSTEM
has been carried out by me under the supervision of External Guide Mrs.JISHA T K,
Software Engineer, NIIT, and Internal Guide Dr.JOTHIMANI K,Assistant Professor,
Department of MCA and submitted in partial fulfilment of the requirements for the award of
the Degree of Master of Computer Applications by the Visvesvaraya Technological
University during the academic year 2017. This report has not been submitted to any other
organization/University for any award of degree or certificate.
Name: Reshma B
Signature:
ACKNOWLEDGEMENT
It was a good experience to have undertaken this project for the fulfilment of VI
semester MCA. Whatever I have been able to put forward in terms of work, only due to few
people who have helped me throughout the project. Thus it is great pleasure in mentioning
them.
I am extremely grateful to my external guide Mrs. JISHA T K Software Engineer,
NIIT institution kannur, for providing opportunity to carry out the project with full support,
guidance, encouragement and for providing good facilities.
I express my sincere thanks to my internal guide Dr. K. JOTHIMANI, Assistant
Professor, Department of MCA for her valuable guidance and support in carrying out this
project.
I extend my gratitude towards my project coordinator Mrs. BHAGYAJYOTHI K L,
Associate Professor Department of MCA for spending her precious time for the completion
of this project.
I express my sincere thanks to Dr. SMITHA M.L, Professor and Head of the
department of MCA for her valuable guidance and support in carrying out this project.
I express my sincere gratitude to Dr. N.A JNANESH, Principal, KVGCE, Sullia, for
his constant encouragement during the project.
I would like to express my sincere thanks to Late Dr. KURUNJI
VENKATRAMANAGOWDA, Founder President of A.O.L.E for having anenvironment
with all facilities.
I also thank all teaching and non-teaching staffs of MCA Department for their support
to make the project a success.
Last but not the least I would like to thanks to my parents and friends directly or
indirectly helped me in completing his project.
ABSTRACT
"Online Transport System" is a web based application which is utilized for dealing
with the transportation organization's operations at various levels. This web based platform
aims to resolve the difficulties relating to finding the vehicle according to the need of the
client, getting fare detail and so on, at the customer level. The client can experience the
effortlessness of booking the vehicle, following its status and so on, at a single click away.
Nowadays people use this vehicle services for their transportation needs. This system can
also check which vehicle is free for booking and which vehicle are booked at present time. It
makes the transportation organization individual's life simple by consolidating the office
works required by them.
CONTENTS
CHAPTER NO TITLE PAGE NO
1 INTRODUCTION 01
1.1 Project Description 01
1.2 Company Profile 02
2 LITERATURE SURVEY 03
2.1 Introduction 03
2.2 Existing System and Proposed System 03
2.3 Feasibility Study 04
2.4 Tools and Technology Used 05
2.5 Hardware and Software Requirements 06
3 SOFTWARE REQUIREMENTS SPECIFICATION 07
3.1 Users 07
3.2 Functional Requirements 09
3.3 Non-Functional Requirements 10
4 SYSTEM DESIGN 12
4.1 Introduction 12
4.2 System Perspective 12
4.3 Context Flow Diagram 13
4.4 Data Flow Diagram 14
5 DETAILED DESIGN 17
5.1 Introduction 17
5.2 Use case diagram 17
5.3 Sequence diagram 20
5.4 Activity diagram 26
5.5 Database design 30
6 IMPLEMENTATION 37
6.1 Introduction 37
6.2 Screen Shots 37
7 SOFTWARE TESTING 61
7.1 Introduction 61
7.2 Test cases 62
8 CONCLUSION 68
9 FUTURE ENHANCEMENTS 69
Appendix A BIBLIOGRAPHY 70
Appendix B USER MANUAL 71
LIST OF FIGURES
Chapter Title Page No
4.3 Context Flow Diagram 13
4.4 DFD Level1 14
4.4 DFD Level2 15
4.4 DFD Level3 16
5.2 Use Case Diagram 19
5.3 Sequence Diagram for admin 21
5.3 Sequence Diagram for Manager 23
5.3 Sequence Diagram for User 25
5.4 Activity Diagram 28
5.5 ER-Diagram 31
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 1
CHAPTER 1
INTRODUCTION
1.1 Project description
Online Transport System is a web based application that allows the customers to book the
vehicle like cabs, travelers and bus at any time and also from any place. The system provides
reliable online booking facility to customers in free of cost. It acts like a bridge between the
vehicle operator and users who book the cab, traveler or bus.
This system mainly consists of 3 modules: admin, manager and user module. Admin
have overall control of the system. Admin can add manager for different branches, can add and
update fare details of the vehicles, approve the vehicle and can view the trip details of all the
branches or particular branch.
Manager can add vehicle which is approved by the admin, he can also view the vehicle of
his branch, fare details, he also add the trip detail of his branch and also can view the same.
Manager allocates the vehicle for a trip based on the user request and also vehicle availability.
Manager can also add and view the driver details of each branch.
User can view the vehicle, book for a vehicle, view fare details. User can also register
with the site and registered user can view previous booking details. Users can make the payment
online through credit card or debit card or internet banking. The user needs to pay thirty
percentage of fare at the time of booking. User are able to view the route map of the place they
want to travel.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 2
1.2 Company profile
NIIT is a famous computer training institute in Kerala. It started on 5th January 2008
under the control of P.Bhaskaran Nair. It is one of the leading institute located in Kannur. The
dream of NIIT is to bring peoples and computer together, in the way allow the world to reap the
benefit of computer education. It provides various training and education computer course for
individuals, school and colleges are provided here. It emphasis the use of technology in
education. NIIT also provides guidance to academic project. IT offers to wide range of learning
and talent development program in area like soft skills, Banking, Vocational skills, Digital
media, marketing and new age IT. These programs are delivered through a hybrid combination
of the 'cloud campus' online platform, satellite based 'synchronous learning technology' and a
physical network of hundreds of learning centers around the globe. It provide various career
oriented course like GNIIT, Robotics, Big data and data science, Internet of Things, Certification
oriented course in Java and..Net, Php, oracle'etc
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 3
CHAPTER 2
LITERATURE SURVEY
2.1 Introduction
The literature survey develops a model to overcome the limitations of existing system. It
also helps to study the existing system in detail. Many systems are available for transport
purpose which is studied and new things are added to this transport system.
2.2 Existing system
In the existing system when the user needs to book for a trip he needed to visit at the
particular agency and need to enquire about the availability of vehicle on a particular date. He
also doesn't have any knowledge about the different vehicles available in the agency. The
current system is very time consuming. Manual work was mainly used to perform all the task.
Manager of each branch doesn't have any knowledge about the trip details of the branches.
The maintenance of current transport system is also very low and it is also less secure. It
keeps the record of the bill and expenditure as paper record and transport company need more
man power.
2.3 Proposed system
The proposed system overcomes all the problems of the existing system. It is easy to
handle. User get complete detail about the vehicle availability, fare detail and based on this they
can book for a trip according to their requirement. Proposed system maintenance is easy and
requires less man power and less time for the maintaining records.
Admin has overall control over all the branches and can get complete information about
vehicle and trip detail of every branch without having to visit each branch separately. The
proposed system is user friendly with good look and is accurate.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 4
2.4 Feasibility study
The Feasibility analysis is carried out during the development stage of the system. It
checks whether the system is acceptable or non-acceptable. It include
1.Technical feasibility
2.Economic feasibility
3.Legal feasibility
4.Operational feasibility
2.4.1 Technical feasibility
The system is technically feasible as all the resource required in the development of the
project are easily available in the organization. It is web based application for the vehicle
booking and provide user friendly environment to the user. All the software and hardware
required for the development and maintenance of the system are already available.
System uses java as frontend, SQL Server 2008 as backend and NetBeans is used as IDE.
2.4.2 Economic feasibility
The system development is economically feasible, as no other extra expenses where
required for the development of the system. As the software, hardware requirement of the project
were easily available and no extra cost was incurred for developing the system.
Here the cost involved in development of the system evaluated against benefit obtained
from the proposed system and become economically feasible, if the benefit equal or exceed the
system.
2.4.3 Legal feasibility
The legal feasibility is based on the determination of the conflicts of legal requirements.
It also checks for the legal data protection. In legal feasibility, it evaluates the operational aspects
of proposed system.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 5
2.4.4 Operational feasibility
The system is operationally feasible as it can be operated from any place at any time. It
only requires an internet, because it is a web based system. The system can be accessed any web
browser. The operational feasibility also considers whether the proposed system meets all the
functional requirement of the customer and also overcome the limitation of the existing system.
2.5 Tools and technology used
2.5.1 Java
In this project Java is used as front end. Java is a most commonly used object oriented
programming language nowadays. It has many useful features like platform independence. That
is, we don't need to have any particular operating system to run applications developed using
Java. Some of the main features of Java are: Simple, Robust, Secure, Portability, Platform
Independence, Object oriented, distributed, Multithreaded etc.
2.5.2 HTML
In this project, the user interface is developed using HTML(Hyper Text Markup
Language). HTML is the standard markup language for creating Web pages. It was developed to
create documents for display on World Wide Web. HTML describes the structure of Web pages
using markup. HTML elements are the building blocks of HTML pages. HTML elements are
represented by tags.
2.5.3 SQL Server 2008
SQL Server 2008 is used as the back end in this project. SQL Server 2008 is a relational
database management system developed by Microsoft. As a database server, SQL Server is
a software product which has the primary function of storing and retrieving data as requested by
other software applications which may run either on the same computer or on another computer
across a network including the Internet
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 6
2.5.4 NetBeans
NetBeans is the platform used to develop this project. It is a software
development platform written in Java. The NetBeans Platform allows applications to be
developed from a set of modular software components. These components are called Modules.
Applications based on the NetBeans Platform can be extended by third party developers.
The NetBeans IDE is primarily intended for development in Java, but also supports other
languages, in particular PHP, C/C++ and HTML. NetBeans can be runs on Microsoft
Windows, Mac OS X, Linux, Solaris and other platforms supporting a compatible Java Virtual
Machine. NetBeans can be runs on Microsoft Windows, Mac OS X, Linux, Solaris and other
platforms supporting a compatible Java Virtual Machine.
HARDWARE AND SOFTWARE REQUIREMENTS
2.6.1 Software Requirements
Operating system : Windows 7 or above
Front End : HTML,JSP
Programming language : Java
Database : SQL Server 2008
IDE : NetBeans
2.6.2 Hardware Requirements
Processor : Pentium(IV) or above
Memory : 500 MB or above
Hard Disk Capacity : 500 GB Hard Disk
Speed : 1.1GHz
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 7
CHAPTER 3
SOFTWARE REQUIREMENTS SPECIFICATION
3.1 Introduction
An SRS or software requirement specification is a document that completely describes
the system. The developer studies the user requirement and design in the system so that it meets
the user requirement. Software requirement specification is document that acts like an interface
between developer and user.
All the features of the system are fully mentioned in the software requirement
specification. So it makes the system easily understandable to the customers as well as person
who are developing the system.
3.2 Users
'Online Transport System' mainly consists of three users ; Admin, Manager, and User.
Admin have overall control of the system, Manager can take control over the branches and make
the operation.
3.2.1 Admin: Admin have overall control of the system. Admin can add the manger for
different branches, can add and also update fare details of the vehicles, approves the vehicle and
can view the trip details of all the branches or particular branch.
The admin user should be able to:
' Add manager :
Admin chooses the manager for each branches.
' Vehicle approval:
Admin approve the vehicle that is added by the manager of the branches.
' Fare details:
Admin has control to add and update fare details.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 8
' View trip details:
Admin can view the trip detail of all the branches
' View vehicle:
The admin can check the status of vehicle availability
3.2.2 Manager
Manager can add vehicles which are approved by the admin, he can also view the vehicle
of his branch, fare detail, he can also add the trip detail of his branch and also can view the same.
Manager allocates the vehicle for a trip based on the user request and also vehicle availability.
The manager should able to:
' Add vehicle:
Manager can add vehicle for his branch
' View vehicle:
Manager can view vehicle of his branch
' Add driver:
Manager can add the driver details of his branch
' View driver:
Manager can view the driver details
' View trip details:
Manager can view the trip detail of his branch
' Update trip details:
Manager can update trip information each branch
' Fare details:
The manager can update their fare and can view fare details.
' Booking confirmation:
Confirm the booking based on the availability of the vehicle on a particular date
and time.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 9
3.2.3 User
User can view the vehicle, book for a vehicle, view fare details. User can also register with
the site and registered user can view previous booking details.
' User registration:
User can also register with the site.
' View vehicle:
User can view vehicle availability.
' Booking:
User can check the availability of vehicle for a particular date and make the
booking.
' Fare details:
User can view the fare details of vehicle
3.3 Functional requirements
In software engineering, a functional requirement defines a function of a system or its
component. A function defines a set of inputs, the behavior, and outputs. Functional
requirements may be some calculations, technical details, data manipulation and processing and
other specific functionality that define what a system is supposed to accomplish.
'' 'n login page only authorized user can access the system.
'' Registration is provided for manager and user.
3.3.1 User Interfaces
The system uses a very user-friendly interface which is developed using Hyper Text
Markup Language (HTML). HTML is for which most users are acquainted with and is broadly
used on the world wide web (WWW). The controls are placed on the forms in an easily
accessible manner so that user strain is minimized to the maximum extent.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 10
Whenever a user enters any form, the system also states the action to be performed in an
easily understandable way. The navigation of the user from one area of the system to another is
very easy using properly placed hyperlinks which user can access on the click of a button.
3.4 Non-functional requirements
' Secure access of user's confidential data
' Better component design to get better performance at peak time
3.4.1 Performance requirements
' System need to be reliable
' System need to display error message on failure of a process.
' Systems search mechanism need to be fast.
' System needs to be secure.
3.4.2 Safety requirements
' The details of customer need to be maintained well.
' When a transaction take place, the transaction details should be stored and
information should be passed to the user.
3.4.3 Security requirement
' The information flow from HTML to Server should be made safe by using
framework mechanism.
' HTML forms need to connect to database using methods, not by direct submit.
' The system should be accessed by authorized persons only.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 11
3.4.4 Software quality attribute
' Availability: The system must be available to users when it is needed.
' Reliability: The reliability of data must be guaranteed.
' Usability: The system should be usable without much effort so that the users can
easily use it .So it should have appropriate user interface and document.
' Maintainability: The software has to be designed meet the needs or the requirements
of the user. Maintainability is really important because software change is an
inevitable consequence of changing business environment. System maintainability
needs to adequate documentation.
.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 12
CHAPTER 4
SYSTEM DESIGN
4.1 Introduction
System design deals with the defining of modules and data required by the system. It
specifies the relationship between input and output of the system, which is how data is input,
how it is processed and how it is displayed.
Different types of methods are used for solving these problems such as architectural
design, subsystem design, system decomposition etc.
4.2 System perspective
Online Transport System has three users: Admin, Manager and users. It create new user
and manager and also control the activities of the admin, manager and user.
4.2.1 Input design
Input design is aimed at creating an application free from bugs. It helps the user to enter
correct data by providing all the necessary information about the fields.
Some of the Rules for input design are:
'''''Labels are provided corresponding to each field which helps the user to entire correct
data in the fields.
' The format for fields are representing date is also provided and user can enter date in the
specified format.
' If the user fails to enter any data correspond error message are displayed.
4.2.2 Output design
In a system the results of all the process are passed to the user through output. Output design
decide how the information is displayed to the user. Different output method used in online
transport system is:
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 13
' Forms
' Tables
4.3 Context Flow Diagram (CFD)
Context flow diagram (CFD) is the diagram that shows the relationship between the
system and external entities and also known as Level0 data flow diagram. It shows the
information flow from input to output. It is highest level of data flow diagram.
Fig: CFD (Context Flow Diagram)(level 0)
It shows the entire function of the system, where Online Transport System is represent
how the user (admin, manager, user) interact with the system. Users have to option to update and
view the data. And based on the query given by the user corresponding process provided the
response.
User
Admin
Manager
Online Transport
System
Database
Registration/Login
Book Vehicle
View vehicle/fare details
View details
Login/ add details
View details
Login/add vehicle
Response Request
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 14
4. 4 Data Flow Diagram (DFD)
Data flow diagram represents how the data flow in a system.
LEVEL 1
Username and password checking for authentication
ogintab Logintabl
Invalid Username and password
Successfully Login Logout
Insert Retrieve Insert Retrieve Insert Retrieve Retrieve
manager vehicle fare tripdetails
Fig: DFD level 1
Admin
Add
manager
Approve
vehicle
View trip
details
Add fare
details
Admin Home
Login
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 15
It is the first level data flow diagram. It shows the flow of data from Admin to the system.
Admin enter the correct username and password to login; the system will check the username
and password in database. If invalid username or password occurs that time not proceed with the
next stage. If fields are valid the system will go to admin home page. Admin can perform
different operations are add, approve and view.
LEVEL 2
Manager
Insert Retrieve Update Retrieve Insert Retrieve Retrieve
vehicle tripdetails tripdetails manager fare
Fig: DFD level 2
Manager
Login
Add / view
driver
Update trip
details
Add / View
vehicle
View trip
details
View fare
details
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 16
Manager operations are second level DFD. Manager enter the correct username and
password to login; the system will check the username and password in database. If invalid
username or password that system does not proceed with the next stage. If it is valid the system
will go to manager home page. Manager can perform operations are insert, update, and view
LEVEL 3
userdetails
Vehicle Vehicle fare
Fig: DFD level 3
User operations are third level DFD. User enter the correct username and password to
login; the system will check the username and password in database. If it is invalid the system
does not proceed to next page. If it is valid the system will go to user home page. Manager can
perform the operations such as view and booking.
User
Login
View fare
details
Book
vehicle
View
vehicle
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 17
CHAPTER 5
DETAILED DESIGN
5.1 Introduction
The functionality of the system is explained in detail with the help of following diagram.
Four types of diagrams are used in detail design stage.ie use case diagram, sequence diagram,
activity diagram and ER diagram.
5.2 Use case diagram
The Use case diagram shows the interaction between use case and actor of the systems. It
also refers to as behavior diagram. Use case diagram can identify the different users and use case
associated with the user. There are 3 users are involved here in different use cases. Admin, User,
Manager are the actors of the system.
5.2.1 Actors
The actor gives the description of interaction between entity and the system. An actor can
be a person or an organization.
In online transport system actors are admin, manager and user. Admin can overall control
the system and manager can control his branches only. Admin can add manager, approve the
vehicle, view trip detail and add fare detail. Managers are also provided the same functionality.
Manager can add and view vehicle, add and view driver detail, update and view trip detail and
view the fare detail. User can interact with the system.
.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 18
5.2.2 Use case:
Use case is the description of interaction between entity and the system. Use case is
represented by using horizontal ellipse. Online transport system have several use cases and
actors. The actors are admin, manager and user.
The uses cases in online transport system are.
' Add manager
' Vehicle approval
' View tripdetail
' Add fare detail
' View fare detail
' Add vehicle
' View vehicle
' User registration
' Booking
' Add driver
' View driver
The admin has the supreme rights on the system it includes the privilege like: The
admin can add new manager and admin can control over the all branches. The newly added
vehicle have to be approved by the admin. Admin can have to right to view the added trip detail
for the vehicle. And also can be updated the fare detail.
The manager is another actor in the system who have the privileges like: The manager
can select and add new vehicle to the system, so that the user can view it for booking. And
he/she can view the added vehicle for the user availability. The manager has the privilege to
update the trip detail of the vehicle and updated trip detail can be viewed by the manager. Driver
detail can be added and viewed by the manager. And manager can also view the fare details.
The user have to register into the system in order to access the features of the system, the
user can have the privilege to register into the system ,after registering the user can view the
vehicle to select from different choices. The user can view the fare detail of the vehicle and also
can book it according to their choice.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 19
Fig: Use case diagram
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 20
5.3 Sequence diagram
A sequence diagram shows the order in which the object interact with other. The object
interaction arranged in a time sequence also called as event diagram or event scenarios. They
represent interaction among object in the form of message. Object are arranged across x axis.
The messages sent and received by object are placed along y axis in the increasing order of time.
A sequence diagram consists of user, system and a database. For each user in the system,
separate sequence diagram should be designed. In sequence diagram shows, a parallel vertical
line represent the different process and horizontal arrow represent the message exchange
between them. Solid arrow heads represents synchronous call and open arrow heads represent
asynchronous message, and dashed line represent reply message.
If a caller send synchronous message, system must wait until the message is done or if the
caller send asynchronous message, system doesn't have wait for the response.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 21
5.3.1 Sequence diagram: Admin
Login Username & password
Authorized page Validation
Adding Manager Manager Details
Manager added Validation
Vehicle Approval Vehicle details
New Vehicle approved Validation
View Trip Detail Trip Details
Trip Details is displayed Validation
Add and Update Fare Detail Fare details
Fare Detail added Validation
Fig: Sequence diagram for Admin
Admin System Database
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 22
Sequence diagram represent the interaction between the object. The admin interact with the
system. It enters the valid username and password. If the username and passwords are correct the
admin will go to the admin home page.
The above sequence diagram shows the sequence for the admin. Here the admin will perform the
following operations like,
' Add Manger
' Vehicle Approval
' View Trip detail
' Add Fare detail
Add manager will indicate adding new manager in particular branches. Username is the primary
key and Manager Id, name, branch name, date of joining, address, email are the fields used to be
here. After add the manager details the validation process will perform.
Admin can approve the vehicle details posted by manager based on the vehicles .The validation
process also performed and after that new vehicle approved messages will be displayed.
It can also view the trip details of all the branches. Vehicle name, number, branch id, starting
location, ending location, distance and fare are the fields of view trip details. After entering the
field validation process is also performed.
Admin can add and update fare details of the vehicle based on outstation, local and airport trips.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 23
5.3.2 Sequence diagram: Manager
Registration Username & password
Authorized page Validation
Add Vehicle Vehicle Detail
Vehicle is added Validation
View Vehicle Vehicle Detail
Displayed Vehicle Validation
Update Trip Detail Trip Details
Trip Details is displayed Validation
Add driver driver details
Driver added validation
View fare details fare Detail
Fare details displayed Validation
Fig: Sequence diagram for Manager
Manager System Database
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 24
The manager enters the username and password. If the username and password is valid,
the manager homepage will be displayed.
Manager also performs the same actions like:
' Add and view vehicle
' Update trip detail and view trip details
' Add and view driver
' View fare detail
View vehicle display the details about added vehicle. The manager can also update the trip
details of particular branches and also change the status of the vehicle. Trip details are viewed by
the manager. Vehicle name, manager id, source, destination, fare, distance are the fields of the
trip detail.
The manager can also add and view the driver details. Driver id, branch, license number,
address are the different fields here. After adding driver fields the validation process is
performed and added successfully message is displayed.
The updated fare details for the trip can be viewed by the manager.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 25
5.3.3 Sequence diagram: User
Registration Username & password
Account registered Validation
Login Username & password
Authorized page Validation
View Vehicle Vehicle Detail
Displayed Vehicle Validation
Book a trip Trip Detail
Booking receipt is displayed Validation
View Fare detail Fare detail
Fare detail is displayed Validation
Fig: Sequence diagram for User
User
System Database
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 26
The user can also perform the same operation. The user enters the correct username and
password to login the system. The user performing operations are:
' User registration
' View vehicle
' Booking
' View fare detail
User has to register into the system. After registering the user can view the vehicle of all
the branches and view the fare detail of the vehicle. Name, branch, source, destination are the
booking fields. Validation process also performed in all the modules.
5.4 Activity diagram
Activity diagram is graphical representation of workflow with stepwise activity and
action. It is similar to flowchart and it represents the flow between the operations on the system.
They represent dynamic behavior of the system. Flow between the operations can be sequential
branch or concurrent.
It is composed of four elements
' Activities
' Association
' Condition
' Constraints
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 27
5.4.1 Activity diagram for Admin
No
Yes
Fig: Activity diagram for Admin
Registration
Login
Add
Manager
Vehicle
approval
View trip
detail
Add fare detail
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 28
5.4.2 Activity diagram for Manager
No
Yes
Fig: Activity diagram for Manager
Registration
Login
Add and view
vehicle
Update trip
detail
Add and view
driver
d
view fare
detail
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 29
5.4.3 Activity diagram for User
No
Yes
Fig: Activity diagram for User
Registration
Login
View vehicle Booking View fare details
d
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 30
5.5 Database design
5.5.1 ER-diagram
Entity Relationship is a graphical representation of entities and their relationship. An
entity relationship model is also known an entity relationship diagram. Entity is the piece of data
and that is represented by a rectangular box and relationships are represented in diamond shape
symbol. In the system have three entities Admin, Manager and User.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 31
N N
1 N
1 1 1 N N
1 1 N N
N
N
N 1 N
Fig: ER Diagram
Admin User
Fare details
vtype
seat
vname
bfare efare
e wfare
airfare
Manage
Uses
View
Book
name
mobile
usname
password
dord
address
add
usname
password
approve
Vehicle
rid
branch
hhh
manager
vtype
vno
seat
adddate
type
picture status
add
add
d
add
dd
Manager Driver
Tripinfo
update
e
managerid
city
pin
branchname
address
mobile
e
name
email licenseno
branch
address
mobileno
drivername
driverid
branch
managerid
date
vehicletype
ee
vehicleno
vehiclename
mmmmmm
me
startloc
endloc
date
usname
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 32
5.5.2 Conceptual schema
Table Name: Login
Field Name Data Type Constraints Description
usname varchar(50) Primary Key Username
password varchar(50) Not Null Password
ustype varchar(50) Not Null User type
Table Name :Manager Registration
Field Name Data Type Constraints Description
Manager ID int Not Null Manager Id
First Name varchar(50) Not Null First Name of the Manager
Last Name varchar(50) Not Null Last Name of the Manager
Date of Joining date Not Null Date of joining of the Manager
Branch Name varchar(50) Not Null Branch Name of the Manager
Address varchar(50) Not Null Address of the Manager
City varchar(50) Not Null City of the Manager
Pin int Not Null Manager pin code
Phone varchar(50) Not Null Manager land phone number
Mobile
numeric(18,0)
Not Null Manager mobile number
Email varchar(50) Not Null Email Id of the Manager
usname varchar(50) Primary key Username of the manager
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 33
Table Name: Add Vehicle
Field Name Data Type Constraints Description
Rid int Not Null Request Id
branch varchar(50) Not Null Branch name
manager varchar(50) Not Null Name of the manager
vtype varchar(50) Not Null Vehicle type
vno varchar(50) Not Null Vehicle number
vname varchar(50) Not Null Name of the vehicle
seat int Not Null Number of seat in the vehicle
adddate varchar(50) Not Null Date on which vehicle is added to the
branch
type varchar(50) Not Null Type of the vehicle
status varchar(50) Not Null Status of the vehicle
picture Varchar(50) Not Null Vehicle picture
Table name: Add Fare
Field Name Data Type Constraints Description
vtype varchar(50) Not Null Type of vehicle
vname varchar(50) Primary key Name of vehicle
seat int Not Null Number of seat in the vehicle
bfare varchar(50) Not Null Base fare of local trips
efare numeric(10,2) Not Null Extra fare of local trips
wfare numeric(10,2) Not Null Wait fare of local trips
bfare1 numeric(10,2) Not Null Base fare of outstation trips
exfare numeric(10,2) Not Null Extra fare of outstation trips
da numeric(10,2) Not Null Wait fare of outstation trips
airfare1 numeric(10,2) Not Null Base fare of airport trips
airfare2 numeric(10,2) Not Null Extra fare of airport trips
air numeric(10,2) Not Null Wait fare of airport trips
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 34
Table Name: Add Driver
Field Name Data Type Constraints Description
DriverID int Not Null Driver id
DriverName varchar(50) Not Null Name of the driver
MobileNo numeric(18,0) Not Null Driver Mobile No
Address varchar(50) Not Null Address of the driver
Branch varchar(50) Not Null Branch name of the driver
LicenseNo varchar(50) Primary key Driver License No
Table Name: Booking Details
Field Name Data Type Constraints Description
branch varchar(50) Primary key Branch name of the vehicle
startloc varchar(50) Not Null Starting location of trip
endloc varchar(50) Not Null Ending location of trip
trdt date Not Null Travelling date
trtime time(7) Not Null Travelling time
cabname varchar(50) Not Null Vehicle name
type varchar(50) Not Null Type of vehicle
vno varchar(50) Not Null Vehicle number
seat int Not Null Number of seat in the vehicle
fare float Not Null Fare details of trip
disn int Not Null Distance of the place
fname varchar(50) Not Null First name of the user
lname varchar(50) Not Null Last name of the user
mob numeric(18,0) Not Null User mobile number
email varchar(50) Not Null User Email Id
addr varchar(50) Not Null Address of user
city varchar(50) Not Null User city
card varchar(50) Not Null Payment mode
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 35
cno numeric(18,0) Null Card number
cname varchar(50) Null Card name
exp date Null Expiry date
bnk varchar(50) Null Name of the bank
vtype varchar(50) Not Null Vehicle type
bookdate date Not Null Booking date
bkno int Not Null Booking number
Table name: User Register
Field Name Data Type Constraints Description
Name varchar(50) Not Null Name of the user
MobileNo numeric(18,0) Not Null Mobile number of the user
Email varchar(50) Not Null Email of the user
Address varchar(50) Not Null Address of user
usname varchar(50) Primary key Username
Table name: Place Details
Field Name Data Type Constraints Description
place varchar(50) Primary key place
lacti numeric(10,5) Not null Latitude of the place
longt numeric(10,5) Not null Longtitude of the place
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 36
Table name: Requesttab
Field Name Data Type Constraints Description
rid varchar(50) Primary key Request id
branch varchar(50) Not Null Branch name of the Manager
manager varchar(50) Not Null Name of the manager
vtype varchar(50) Not null Vehicle type
vno varchar(50) Not null Vehicle number
vname varchar(50) Not null Vehicle name
seat varchar(50) Not null Number of seat in the vehicle
adddate varchar(50) Not null Adding date of vehicle
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 37
CHAPTER 6
IMPLEMENTATION
6.1 Introduction
Implementation is the one important part of the software development. In Online Transport
system is a web based application. In this project java is used as front end and many features are
implemented here. Before implementing phase correct all the bugs. The system is also user
friendly and platform independent.
6.2 Screen shots
6.2.1 Start page.
This is the home page for online transport system.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 38
6.2.2 Transport system login page
Using this interface Admin, Manger and User can login with username and password.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 39
6.2.3 Admin home page
This interface is homepage for admin, here admin can add the manager detail, vehicle
approval, display trip detail and add fare detail.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 40
6.2.3 Add Manger page.
This interface used to create the manager account by admin.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 41
6.2.4 Vehicle approval page.
Using this interface admin can approved by the newly added vehicle
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 42
6.2.5 Trip display page.
This page displays the trips, admin can view trip detail
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 43
6.2.6 Add fare detail page.
This is the fare detail page. Admin can add fare detail of the vehicle.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 44
6.2.7 Manager home page.
This is the Manager home page. Here manager can add vehicle , add driver information,
update the trip details and fare details.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 45
6.2.8 Add vehicle page.
Here manager can add vehicle details.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 46
6.2.9 Update trip details page.
This is the update trip detail page and manager can change the status of the vehicle.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 47
6.2.10 Add driver page
Using this interface manager can add the driver details
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 48
6.2.11 Fare detail page.
This is the fare detail page.manager can view the fare detail of cab, traveller and bus.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 49
6.2.13 User home page
This is home page for user and user can view the vehicle and fare detail .
6.2.14 Booking page
Using this interface user can book with vehicle.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 50
6.2.14 Booking page
In this page the user can select the vehicle and find the distance and fare.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 51
6.2.15 Booking page
In this page the user can pay with booking vehicle
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 52
6.2.16 Payment page
Using this interface user can select payment option. credit/debit and internet banking
also used to pay.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 53
6.2.16 Booking receipt page
This page is used print the payment details.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 54
6.2 Coding
Login
/*This is the code for login page of users. */
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css/bootstrap-combined.no-icons.min.css" rel="stylesheet" type="text/css"/>
<script src="js/bootstrap.min.js"></script>
<link href="runnable.css" rel="stylesheet" />
<script src="js/jquery-1.9.1.js"></script>
<script src="js/jquery.validate.min.js"></script>
<link rel="stylesheet" href="css/menu1.css">
<title>LOGIN PAGE</title>
<style>
p.dotted {border-style: dotted;}
body{
background-color:skyblue;
}
</style>
<script>
$(function() {
$("#login-form").validate({
rules: {
username: "required",
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 55
password: {
required: true,
minlength: 6
}
},
messages: {
username: "Please enter user name",
password: {
required: "Please provide a password",
minlength: "Your password must be at least 6 characters long"
}
},
submitHandler: function(form) {
form.submit();
}
});
});
</script>
</head>
<body bgcolor="#0CCCC">
<div style="width:200; background-color:lightblue; height:130px; ">
<table align="center"><tr>
<td>
<a href="index-1.html"><input type="submit" value="About" class="button" /></a>
<a href="index-2.html"> <input type="submit" value="Gallery" class="button" /></a>
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 56
<a href="admin.jsp"><input type="submit" value="Login" class="button" /></a>
<a href="index-41.html"><input type="submit" value="Contacts" class="button" /></a>
<a href="map4.jsp"><input type="submit" value="Routes" class="button" /></a></td>
</tr> <center><h1>YOUR TRAVELS</h1></center></table>
</div>
<div align="center">
<p>LOGIN HERE</p>
</div>
<div align="center">
<form action="logServlet" method="post" id="login-form" novalidate="novalidate">
<img src="images/images.jpg" align="center">
<table border size="1">
<tr><td >
<table><label>
<tr><td><input type="radio" name="emp" value="Admin"
/>Admin</td></tr></br></label>
<tr><td><input type="radio" name="emp" value="Manager"
/>Manager</td></tr></br>
<tr><td><input type="radio" name="emp" value="User"
checked/>User</td></tr></br>
<tr><td>Username</td> <td><input type="text" name="username"></tr></td>
<tr><td>Password</td><td> <input type="password" name="password"> </tr>
<tr><td></td><td><input type="submit"
name="Login"value="Login"></form>
<input type="reset" name="Cancel"value="Reset"></td></tr>
<tr><td><a href="forgotpass.jsp">forgot password</a></td></tr>
</table>
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 57
</tr></td></caption>
</table>
</div>
</body>
</html>
Servlet
/* This is servlet code for login page. */
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
public class logServlet extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
Context ctx=null;
DataSource ds=null;
Connection cn=null;
PreparedStatement ps=null;
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 58
ResultSet rs=null;
try {
String emptype=request.getParameter("emp");out.print(emptype);
String username=request.getParameter("username");out.print(username);
String pword=request.getParameter("password");out.print(pword);
HttpSession session=request.getSession(true);
session.setAttribute("usname", username);
session.setAttribute("ustype", emptype);
ctx=new InitialContext();out.println(ctx);
ds=(DataSource)ctx.lookup("jdbc/transport"); out.println(ds);
cn=ds.getConnection();out.println(ds);
String url="select * from Logintab where usname=? and password=?" ;
ps=cn.prepareStatement(url);out.println(ps);
ps.setString(1,username );
ps.setString(2,pword );
rs=ps.executeQuery();
if(rs.next())
{
if(rs.getString("ustype").equalsIgnoreCase(emptype) &&
emptype.equalsIgnoreCase("admin"))
{
RequestDispatcher rd=request.getRequestDispatcher("/Adminhome.jsp");
rd.forward(request, response);
}
if(rs.getString("ustype").equalsIgnoreCase(emptype) &&
emptype.equalsIgnoreCase("manager"))
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 59
{
RequestDispatcher rd=request.getRequestDispatcher("/Managerhomenew.jsp");
rd.forward(request, response);
}
if(rs.getString("ustype").equalsIgnoreCase(emptype) &&
emptype.equalsIgnoreCase("user"))
{
RequestDispatcher rd=request.getRequestDispatcher("/Userhome.jsp");
rd.forward(request, response);
}
}
} catch (NamingException ex) {
} catch (SQLException ex1) {
out.print(ex1);
}
finally {
try {
out.close();
if(rs!=null)
rs.close();
if(ps!=null)
ps.close();
if(cn!=null)
cn.close();
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 60
} catch (SQLException ex) {
Logger.getLogger(logServlet.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
public String getServletInfo() {
return "Short description";
}}
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 61
CHAPTER 7
SOFTWARE TESTING
7.1 Introduction
The software testing is used to find the bugs on the software and checking the quality of
software. The bugs were corrected by using various test data.
Different testing methods are:
' Unit testing
' Integration testing
' System Testing
' Acceptance testing
7.1.1 Unit testing
Unit testing is the first step in the testing process. Individual unit or component of a
software is tested in unit testing. In this online transport system project there are three module
admin, manager and user. Each module is tested individually. Unit testing helps to find the bugs
in early stages and after changing the code.
7.1.2 Integration testing
Integration testing is the second level of testing process. After unit testing all the modules
are joined together and tested. Top down and bottom up approach are used in integration testing
method. This online transport system project integrates all the modules and is tested.
7.1.3 System testing
System testing of software or hardware is tested on the entire system and all the code are
checked before delivering to the customer. Different type of test are included in system
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 62
testing.ie, graphical user interface, usability, software performance and compatibility testing. The
online transport system is tested completely last.
7.1.4 Acceptance testing
Acceptance testing is the final step of testing process. It is also used to test how user
interacts with the computer. Acceptance testing is also called beta testing,application testing or
user testing. Online transport system is also used to acceptance testing.
7.2 Test cases
7.2.1 Login Page
Sl.No Test Case Expected Result Obtained Result Remark
2 Click on Login
button without
entering
password
Message
displaying 'please
provide your
password'
Message displaying
'please provide your
password'
Successful
3 Click on Login
button with
entering invalid
password
Message
displaying 'check
your password'
Message displaying
'your password must be
6 character long'
Successful
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 63
7.2.2 Registration Page
Sl.No Test Case Expected Result Obtained Result Remark
1 By Clicking
Register button
with fill all the
field
Showing an alert
box with the
message 'added
successfully '
Showing an alert box
with the message
'successfully added'
Successful
2 Click on Register
button without
enter the field
Message
displaying
'please enter the
fields'
Message displaying
'please enter the fields'
Successful
3 Click on
Register
button with
entering invalid
Email id format
display an error
message 'please
enter the valid
Email Id'
display an error message
'please enter the valid
Email Id'
Successful
4 Click on register
button by
entering
alphabets in
phone number
field
Display an error
message 'enter
the valid phone
number'
Display an error
message 'enter the valid
phone number'
Successful
5 Password is
mismatching
with conform
password
Display an error
message
'Password is not
match'
Display an error
message 'Password is
not match'
Successful
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 64
7.2.3 Admin Home Page
Sl.No Test Case Expected Result Obtained Result Remark
1 By clicking
manager info
Redirect to add
manager info
page
Redirect to add
manager info page
Successful
2 By clicking
vehicle approval
Display vehicle
approved page
Display vehicle
approved page
Successful
3 By clicking trip
info
Display the
booked vehicle
detail page
Display the booked
vehicle detail page
Successful
4 By clicking fare
page
Redirect to add
fare detail page
Redirect to add fare
detail page
Successful
7.2.4Adding Manager info
Sl.No Test Case Expected Result Obtained Result Remark
1 By Clicking
submit button
after enter all the
fields
Showing an alert
box with the
message 'added
successfully '
Showing an alert box
with the message 'added
successfully '
Successful
2 Click submit
button without
enter the fields
Displaying
message 'please
enter the field'
Displaying message
'please enter the field'
Successful
3 Click on submit
button by entering
invalid pin
display the
message 'enter
the correct pin'
display the message
'enter the correct pin'
Successful
4 Click on submit
button by entering
invalid date
Display the
message 'please
enter the date on
dd/mm/yyyy
format'
Display the message
'please enter the date
on dd/mm/yyyy format'
Successful
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 65
7.2.5 View Trip detail
Sl.No Test Case Expected Result Obtained Result Remark
1 Select category
and branch from
dropdown list
which the place is
selected
Displays the
selected place
Displays the selected
place
Successful
2 By clicking view
button
Display the trip
detail
Display the trip detail Successful
7.2.6 Manager Home Page
Sl.No Test Case Expected Result Obtained Result Remark
1 By click on
vehicle
Displays the add
and view vehicle
page
Displays the add and
view vehicle page
Successful
2 Click on trip info Display add and
update trip detail
page
Display add and update
trip detail page
Successful
4
Click on driver
menu
Displays add
and view driver
page
Displays add and view
driver page
Successful
5 Click on fare
Details menu
Redirect to fare
Page
Redirect to fare Page Successful
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 66
7.2.7 Add Driver Page
Sl.No Test Case Expected Result Obtained Result Remark
1 By Clicking on
add button after
fill all the entries
Showing an alert
message ' data is
added
successfully'
Showing an alert box
with the message ' data
is added successfully'
Successful
2 Click on add
button without
enter any one of
the field
Displaying
message 'please
enter the field'
Displaying message
'please enter the field'
Successful
3 Click on license
button by
entering character
on field
display an error
message 'only
numbers'
display an error message
'only numbers'
Successful
7.2.8 User Home Page
Sl.No Test Case Expected Result Obtained Result Remark
1 Click on view
vehicle
Display vehicle
detail page
Display vehicle detail
page
Successful
2 Click on booking
menu
Display booking
page
Display booking page Successful
3 Click on fare
detail
Display fare
detail page
Display fare detail page Successful
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 67
7.2.9 Booking Page
Sl.No Test Case Expected Result Obtained Result Remark
1 Select on source,
destination and
enter next button
Redirect view
vehicle page
Redirect view vehicle
page
Successful
2 By entering the
account number
on account
number field
Display card
details
Display card details Successful
4 By entering the
invalid account
number
Displaying the
message 'invalid
account number'
Displaying the message
'invalid account number
Successful
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 68
CHAPTER 8
CONCLUSION
Online transport system is a web based application, it eliminates the disadvantages of the
existing manual system. It is designed for customer to book a vehicle at any time any place. The
pages are designed in a user friendly manner. It is developed in such a way that it is easy to add
vehicle and fare detail, can be updated efficiently and accurately.
Using this website user can interact with the system very easily and view the availability
of vehicle. It provides reliable online booking facility to the customer.
.
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 69
CHAPTER 9
FUTURE ENHANCEMENT
This system is mainly developed in object oriented method. If anything require to the system
easily modify in this system.
' GPRS module can be integrated to get the correct position of the vehicle
' Provide travel option to other states
' Mobile application can be developed for the same project
' The system can also add more feature
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 70
Appendix A
BIBLIOGRAPHY
Books
' Farhan Muhammad and Matt Milner, 'Real World ASP.NET Best Practices', 2nd
edition, Apress, 2003
' Patrick Naughton, Schildt Herbert, 'C# 4.0 The Complete Reference', Tata MC Graw-
Hill, 2008.
' Pankaj Jalote, 'An Integrated Approach to Software Engineering', Third Edition
Websites
' http://stackoverflow.com
' http://www.wikipedia.org
' http://msdn.microsoft.com
' http://www.w3schools.com
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 71
Appendix B
USER MANUAL
The 'Online Transport System' have three users Admin, Manager and User. Admin can
control over all the branches an manager can control their on branches. User can view the
vehicle and register with the site.
Admin
Admin have no separate registration process. he/shewill enter correct user name and
password for Login. If the password is incorrect then display the error message otherwise will go
to the admin home page. Admin can add manager, vehicle approval, view trip detail and add fare
detail.
Add manager:
' While click on the 'Manager info' then will go to manager registration page
' Admin can add the manager details.
Vehicle approval:
' While click on 'Vehicle approval' then it will go to approval page and click on approve
then redirect to next page.
' Newly added vehicle is approved by the admin
' Manager can add the vehicle and admin can approve that one.
View trip detail:
' The link will redirect to view trip detail
' Admin can view the booked trip details and also understand that vehicle is available or
not.
Add fare detail:
' While click on the add fare detail then will go fare table
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 72
' The fare details for the vehicles can also be updated by the admin.
' And admin can add bus and cab fare detail separately based on local, outstation and
airport trips.
' Logout button is used redirect to the admin home page
Manager
Manager also can enter the correct user name and password for login and that will go the
manager home page and it does not have registration process. Manager can add and view vehicle
and driver detail, view and update trip detail and also can view the fare detail.
Add and View Vehicle:
' In this page manager can add new vehicle details
' The user can view it for booking and entering vehicle number is important in validation
process
' While click on view vehicle manager can can view the added vehicle for the user
availability
Update and view trip detail:
' The link will redirect manager to update trip detail of the vehicle
' Manager can change the status of vehicle.
' In this view trip detail page manager can view trip details of vehicle
Add and view driver:
' While click on add driver then it redirects to add driver or view driver
' Manager can add driver detail
' Added driver detail can be viewed by the manager.
View fare detail
' In this page manger can view the fare detail of the vehicle
ONLINE TRANSPORT SYSTEM
KVGCE SULLIA Department of MCA Page 73
User
' User fills the registration form and click register button.
' The user have to register into the system in order to access the feature of the system
' The user can have the privilege to register in to the system
' After registering the user can view the vehicle to select from different choices.
' The user can view the fare detail of the vehicle and also can book it according to their
choice.
' Logout button is used redirect to the admin home page