Online Bus Ticket Reservation System

Project Introduction

SRC Travel Agencies is a domestic privatized transportation company that runs the vehicles all over the country. They have several branches at different locations of the country, so that they can provide the transportation facilities between the places. They want and desktop application to be developed, where the details of the bookings done and the customer will be updated from time to time and user can track the details of the available seats immediately.

Functional Requirements:

1. The details of the buses, Price list, and Employee details are to be maintained and controlled solely by the (Manager) Admin alone.

2. The Employer can change alone the password assigned to him.

3. Also first the employer needed to login first in order to perform the booking actions.

4. Calculations of the charges and the reimbursements are to be implemented by the application alone as designated by the Admin

5. The details of the buses and seats available are to be maintained and can be updated regularly (of course only by the admin)

6. Enquiry form, Booking form and the pricing list are to be maintained in separate forms.

7.There should be new, update, cancel and search options available.

Existing Scenario:

SRC Travel Agencies is the agency that provides the transportation facility to the customers based on their requirements. They provide different buses like Express, Luxury, and Volvo (Has two types A/C and Non A/C). The charges are different for different buses. The charges are in the below mentioned format.

Express - Luxury - Volvo (Non A/C) - Volvo (A/C) -

The charges also depend on the distance the customer wants to travel and as well on the age of the customer. The charges also depends on the age, i.e., up to the age of 5 years there will not be any charges, in between 5 12 there will be half charges and for above twelve the charges will be full till the age of 50 and for the age above fifty they will get a discount of 30%. They implement this in order to attract the customers.

Proposed Solution

Now they want incorporate an application where they can maintain the records of the buses along with the details of the customers. The customer can now book the tickets by visiting the booking counters at their place (nearby) to the respective destination as required. They also want to incorporate some feature which performs the tasks that they actually perform, and an application where the user can register a customer and then book the tickets. A database should be maintained where the bus details along with the bus number, route, the places it covers throughout the distance and also the timings are needed to be maintained. Also the details of the customers that are entered at the time of booking the tickets are needed to be gathered in the database. So that they can track the details of the Customer at any time using the search option based on the starting place, age, name, destination place and Date and Time and even based on the bus they had chosen. The database should also maintain the list of the Employers as they alone book the tickets with the username and password. The list that is to be maintained is personal details, contact details; location, qualification, age, etc are needed to be gathered. There should be buttons like New, Update and Cancel are to be included. Based on the button chosen the respective action is needed to be performed. Also if the Employee record is entered (The Employee details will be maintained by the Admin alone), it will ask for the username and the password (the password can be changed by the Employee) through which he can login in to the a/c so as to perform the booking tasks. Also for canceling the ticket, there is a limit like, if cancelled before 2 days then the whole money will be returned, and if done one day before, then 15% is debited from the total amount and the remaining amount is returned and if done on that day 30% is debited from the total amount and the remaining is to be returned back. This action is also to be performed by the application alone.

They want the application to be maintained in different details like the buses and the bookings information. When they try to book a ticket it should ask for the customer details like the name of the customers for whom the tickets are booked, Date and Time, Starting and Destination place and the age ( as the charges depends on the age). Also the Bus no. and the seat no. for which the ticket (s) booked are to be entered so that they can keep track of the bookings done. Whenever a customer enquiries for the availability they can check through the Enquiry form where the details like Destination Place, Starting Place, Date and Time are asked, by entering these details (all fields are not mandatory) the availability details should be displayed. Also there should be a search option through which the records of the customers and the buses can be known easily with the same above options.

After the ticket is booked, user should be able to print the ticket, including the details like age, name, Date and time for which the ticket is booked and as well the destination and Starting locations and the charges for the ticket including the taxes. The application alone should be able to calculate the payments as per the age criteria and the distance. Also it has to be updated in the site.

PROJECT PLAN

Purpose of Plan: - SRC Travel Agencies

Database: bus.sql

The Project Plan defines the following: -

Project Purpose
• Business and Project Goals and Objectives
• Score and Expectations
• Roles and Responsibilities
• Assumptions and Constraints
• Project Management Approach
• Ground Rules for the Project
• Project Budget
• Project Timeline

Snapshots

Login Window:

Main Window:

Add Buses:

Add Route:

Add Routine:

Add Employee:

View and Update Busses:

View and Update Routes:

View and Update Routine:

Booking Window/ Employee Window:

Add Customers:

View Customers:

Add Booking:

Cancel Booking:

View Tickets:

Enquiry:

Price List:

Change Password:

ER-Diagram

Flow Chart

FUTURE SCOPE

Online Bus Ticket Reservation System has as many Future Scope as think of some of the few point have come to light. They are as follows: -

• Launching the software on the Network.
• Using JAVA programming on Higher scale using Hardware
• Programming such as Bus Ticket Reservation

Hardware/Software requirements

Hardware

• A minimum computer system that will help you access all the tools in the courses is a Pentium D 1.2Ghz or better
• 2048 Megabytes of RAM or better
• Windows Xp(or higher if possible)
• Java Virtual Machine

Software

• Notepad/HTML editor/Java editor
• j2sdk1.4.1_02 (or later)
• SQL Server 2005/2008 RTM
• JDBC Driver

User Guide

System Requirements

No.	Items	Description
1	Operating System	Window 98,2000,XP etc
2	Main processor	Minimum 166 or better
3	Ram (Memory)	Minimum 64 or better
4	Software	Net beans/Text pad/Notepad/Sql/Cmd

There is One Admin:

1. Username: Admin
2. Password: admin

There are Many Users:

1. Username: waleed
2. Password: 123
3. Username: ali
4. Password: 123

For Net Beans:

• Open Net Beans and Open Aptitude Test System
• Add Sqljdbc4.jar to the library
• Now run login.java file.

SQL Server Configuration Manager