organized
organized
SR NO CHAPTER PAGE NO
1 INTRODUCTION 1- 3
1.1 Survey
1.2 Objectives
1.3 Analysis
1.4 Methodology
2 INITIAL INVESTIGATION 4
2.1 Existing system study
3 FEASIBILITY STUDY 5-6
3.1 Types of Feasibility
4 SOFTWARE REQUIREMENT SPECIFICATION 7
4.1 Advantages
4.2 Characteristics of an SRS
5 FLOWCHART 7-8
5.1 System flow chart
6 WORKING ENVIRONMENT 9-10
6.1 Introduction
6.2 software requirements for
developing and implementing the
system
6.3 Definition of Software Requirement
7 SYSTEAM ANALYSIS 11-15
7.1 Data flow Diagram
7.2 Entity Relation Diagram
8 SYSTEM DESIGN 16-21
8.1 User interface-Screenshot
8.2 Database Tables
9 SOURCE CODE 22-29
9.1 Registration train management system
9.2 User login
9.3 User train booking
10 CONCLUSION 30
11 REFERENCE 31
12 WEBSITES 32
CHAPTER - 1 INTRODUCTION
1. INTRODUCTION
Rail transport is one of the important modes of transport in India. Now a days
we see that there are railways that are present for the long as well as short
distance travelling which makes the life of the people easier. When compared to
other means of transport, a railway is the cheapest means of transport. The
maintenance of the railway database also plays a major role in the smooth
running of this system. The Online Train Ticket Management System will help
in reserving the tickets of the railways to travel from a particular source to the
destination.
This website has various kinds of information that helps regarding booking of
tickets via railways. Users will be able to search the train availability, the exact
fare, the arrival and departure time of the train and they can also book the ticket
by using the debit, credit or master card and after booking the ticket if the user
wants to cancel it then they can easily do it also.
This system is designed to provide the facility where the customer can
easily book tickets online. The main advantage of this project is here
customer don’t have to stand in long queues for buying a ticket. Customer can
purchase ticket through online anytime. This Train Ticket Booking System is
the mini project developed using java and MySQL.
The customer needs to register to the website before booking train ticket.
Customer can book the ticket, view previous transaction, print ticket receipt
after the login. The passenger can select source location and destination
location to book the train ticket. While booking ticket the system asked
payment card details for transaction.
1.1 SURVEY
Railway passengers frequently need to know about their ticket
reservation status, ticket availability on a particular train or for a place, train
arrival or departure details, special trains etc. Customer information centers at
the railway stations are unable to serve such queries at peak periods.
The number of the reservation counters available to the passengers and
customers are very less.
2|Page
On most of the reservation systems there are long queues, so it takes a long time
for any individual to book the ticket.
As now there are no call centers facilities available to solve the queries of the
passengers.
The online railway ticket reservation system aims to develop a web application
which aims at providing trains details, trains availability, as well as the facility to
book ticket in online for customers.
So, we thought of developing a web-based application which would provide the
users all these facilities from his terminal only as well as help them in booking
their tickets.
We decided to give the name of the website “ONLINE TRAIN TICKET
MANAGEMENT SYSTEM”. The online railway ticket reservation system is
developed using JSP.NET with Eclipse JEE 2018-2009 as the backend in the
.NET Framework.
1.2 OBJECTIVES
1. To search the trains it’s arrival and departure time, distance between source and
destination.
3. To check the availability of the ticket.
4. To calculate fare.
5. To book the ticket.
6. To cancel the ticket if necessary.
7. Passenger can check the history of booking by using their username and
Password.
8. A modern approach of booking.
9. Greater sales and marketing.
10. It will save time of the passengers as it is an online
application.
3|Page
1.3 ANALYSIS
1.4 METHODOLOGY:
An important aspect of modeling is its role as a communication tool in
determining requirements. For users what they require, and whether the current
system satisfying their requirements. As we go through the project, we found out
train details, train timing, seat availability, booking history of the user. We visit
them in different time to book train tickets and check their availability, timing as
per requirements. Though all of the requirements are not same but we tried out to
make an interface among their requirements.
CHAPTER - 2 INITIAL INVESTIGATION
2. INITIAL INVESTIGATION
• On most of the reservation systems there are long queues, so it takes a long
time for any individual to book the ticket.
• As now there are no call centers facilities available to solve the queries of
the passengers.
4|Page
CHAPTER - 3 FEASIBILITY STUDY
3. FEASIBILITY STUDY
1. Technical Feasibility.
Technical feasibility assesses the current resources (such as hardware and
software) and technology, which are required to accomplish user requirements in
the software within the allocated time and budget. Technical feasibility also
performs the following tasks.
Analyzes the technical skills and capabilities of the software development team
members.
Determines whether the relevant technology is stable and established.
5|Page
Ascertains that the technology chosen for software development has a large
number of users so that they can be consulted when problems arise or
improvements are required.
2. Operational Feasibility.
Operational feasibility assesses the extent to which the required software performs
a series of steps to solve business problems and user requirements. Operational
feasibility also performs the following tasks.
3.Economic Feasibility.
Economic feasibility determines whether the required software is capable of
generating financial gains for an organization. Software is said to be economically
feasible if it focuses on the issues listed below.
6|Page
CHAPTER – 4 SOFTWARE REQUIREMENT SPECIFICATION
The Software Requirements Specification section will deal with the technical
details of the proposed system. It will contain information regarding the
developmental and operational environments, user interfaces, functional and
requirements specifications and the exception and error handling features of the
system.
4.1 Advantages
Software SRS establishes the basic for agreement between the client and the
supplier on what the software product will do.
•ASRS provides a reference for validation of the final product.
• A high-quality SRS is a prerequisite to high-quality software.
• A high-quality SRS reduces the development cost.
4.2 Characteristics of an SRS
•Correct.
•Complete.
•Unambiguous.
•Verifiable.
•Consistent.
•stability.
•Modifiable.
• Traceable.
CHAPTER - 5 FLOWCHART
5. Flowchart
7|Page
SYSTEM FLOW CHART
Start
User
If registered Registered
Yes
Login
No Yes
Is valid
user
Logout
Stop
8 |Page
CHAPTER – 6 WORKING ENVIRONMENT
6. WORKING ENVIRONMENT
6.1 Introduction
Project environment represents a connection, where the project is processed.
It impacts the project and is, therefore, conditioned. Such an interaction is provided
by numerous factors as operational, physical, ecological, social, cultural,
economic, psychological, financial, organizational etc. The environment not only
formulates the project but also estimates it.
The project environment analysis is held at the beginning of the project. This
method identifies the lobbies and integrates the project stakeholders into project
group. All impact factors are analyzed in this analysis: project risks and chances,
stakeholders and their interests, measures for the control. The stakeholder type is
thereby analyzed. It distinguishes between active and passive type. The first group
represents project team and project manager, principal and customer. The second
group contains authorities, works council, competitors, persons affected by the
project indirectly.
Operating System: -
Software Requirements
Operating system: WINDOWS 7, 8
User interface: HTML, CSS
Programming language: JSP
Database: MY SQL
Server: TOMCATE
Working Environment: ECLIPSE JEE
9|Page
Hardware Requirements
Prosser: any
Hard Disk: 10 GB minimum
RAM: 256 MB
Any screen
JSP
• JSP technology is used to create web application.
• Java Server Pages (JSP) is a server-side programming technology.
• Enables the creation of dynamic, platform-independent method for building
Web-based applications.
• A JSP page consists of HTML tags and JSP tags.
• It provides some additional features such as Expression Language, Custom
Tags, etc.
• The JSP pages are easier to maintain because we can separate designing and
development.
MYSQL
• Standard query language.
• Open Source Relational SQL Database Management System.
10 | P a g e
• MySQL is one of the best RDBMS being used for developing various web-
based software applications.
• It is very commonly used in conjunction with PHP scripts to create
powerful and dynamic server-side applications.
• MySQL is quicker than other databases so it can work well even with the
large data set.
• MySQL uses a standard form of the well-known SQL data language.
HTML
• Hyper Text Markup Language.
• Most widely used web language.
• HTML was created by Berners-Lee in 1991 .
• "HTML 2.0" was the first standard HTML specification which was
published in 1995.
• HTML was developed with the intent of defining the structure of documents
like headings, paragraphs, lists.
CSS
• CSS is used to design HTML tags.
• CSS is used to control the style of a web document in a simple and easy
way.
• CSS is the acronym for "Cascading Style Sheet”
CHAPTER – 7 SYSTEM ANALYSIS
7.SYSTEM ANALYSIS
Introduction
It is a process of collecting and interpreting facts, identifying the problems,
and decomposition of a system into its components.
System analysis is conducted for the purpose of studying a system or its parts in
order to identify its objectives. It is a problem-solving technique that improves the
system and ensures that all the components of the system work efficiently to
accomplish their purpose.
7.1 DATA FLOW DIAGRAM
A data flow diagram is a way of representing a flow of data of a process or a
system. It provides information about the outputs of each entity and the process
itself.
11 | P a g e
Data flow diagram (LEVEL 0)
DFD Level 0 is also called a Context Diagram. It’s a basic overview of the whole
system or process being analyzed or modeled.
USER
ONLINE TRAIN
TICKET
MANAGEMENT
SYSTEM
ADMIN
12 | P a g e
Data flow diagram (LEVEL 1)
The Level 0 DFD is broken down into more specific, Level 1 DFD. Level 1 DFD
depicts basic modules in the system and flow of data among various modules.
Level 1 DFD also mentions basic processes and sources of information.
Enter PNR
User Details
Cancel
ticket
13 | P a g e
7.2 ENTITY RELATIONSHIP DIAGRAM
Entity relationship diagram displays the relationships of entity set stored in a
database. In other words, we can say that ER diagrams helps to explain the logical
structure of databases. This model is based on three basic concepts:
Entities
Entities are represented by means of rectangles. Rectangles are named with the
entity set they represent.
Attributes
Attributes are the properties of entities. Attributes are represented by means of
ellipses. Every ellipse represents one attribute and is directly connected to its entity
(rectangle).
Relationship
Relationships are represented by diamond-shaped box. Name of the
relationship is written inside the diamond-box. All the entities (rectangles)
participating in a relationship, are connected to it by a line.
14 | P a g e
ENTITY RELATIONSHIP DIAGRAM
HAS
User name Password
User Name
Password
Meritorial
status Registration login
Manage
Email Station Sat_
name Sta_dist
Gender
Source
Destination Train name
Date
Cancel
Class Information of train
ticket
pnr Source
Gender
Arrival
PNR
Name
Distance Date of
Berth Transaction
journey
Fare id
Seat availability
15 | P a g e
CHAPTER – 8 SYSTEM DESIGN
8. SYSTEM DESIGN
8.1 User interface-Screenshot
LOG IN PAGE.
For a new user there is a hyperlink by which user can create a new account
REGISTRATION PAGE
After login registration page is open and in this page details PERSONAL
DETAILS which is filled by user.
16 | P a g e
They have to give a user id and password to login.
18 | P a g e
option for logout the page.
19 | P a g e
8.2 Database Tables
Table 1: userinfo
Table 2: traininfo
20 | P a g e
Class Varchar 20 not null
Departure Varchar 40 not null
Arrival Varchar 40 not null
Distance Varchar 40 not null
Travel_time Varchar 40 not null
No_of_seat_available Int not null
Table 3:bookinfo
21 P a g e
CHAPTER – 9 SOURCE CODE
9.1 Registration train management system
<%@pagecontentType="text/html"pageEncoding="UTF-8"%>
<!DOCTYPEhtml>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">
<title>Registration</title>
</head>
<bodybgcolor="#E3E2DE">
<center>
<h1>Train Reservation System</h1>
<formmethod="post"action="registration.jsp">
<tablebgcolor="#FCA014"border="1"width="30%"cellpadding="5">
<thead>
<tr>
<thcolspan="2">Enter Information Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>First Name :</td>
<td><inputtype="text"name="fname"/></td>
</tr>
<tr>
<td>Last Name :</td>
<td><inputtype="text"name="lname"/></td>
</tr>
<tr>
<td>Email ID :</td>
<td><inputtype="text"name="email"/></td>
</tr>
<tr>
<td>Gender :</td>
<td><inputtype="text"name="gender"/></td>
</tr>
<tr>
<td>Marital Status :</td>
<td><inputtype="text"name="status"/></td>
</tr>
22 | P a g e
<td>Contact :</td>
<td><inputtype="text"name="phone"value=""/></td>
</tr>
<tr>
<td>Username :</td>
<td><inputtype="text"name="uname"/></td>
</tr>
<tr>
<td>Password :</td>
<td><inputtype="password"name="pword" "/></td>
</tr>
<tr>
<td><inputtype="submit"value="Submit"/></td>
<td><inputtype="reset"value="Reset"/></td>
</tr>
<tr>
<tdcolspan="2">Already registered!! <ahref="index.jsp">Login
Here</a></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
9.2 Userlogin
<%@pagecontentType="text/html"pageEncoding="UTF-8"%>
<!DOCTYPEhtml>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">
<title>JSP Example</title>
</head>
<bodybgcolor="#E3E2DE">
<center>
<h1>Train Reservation System</h1>
<formmethod="post"action="login.jsp">
<center>
<tablebgcolor="#FCA014"border="1"width="30%"cellpadding="3">
23 | P a g e
<thead>
<thcolspan="2">Login Here</th>
</tr>
</thead>
<tbody>
<tr>
<td>User Name</td>
<td><inputtype="text"name="uname"value=""/></td>
</tr>
<tr>
<td>Password</td>
<td><inputtype="password"name="pass"value=""/></td>
</tr>
<tr>
<td><inputtype="submit"value="Login"/></td>
<td><inputtype="reset"value="Reset"/></td>
</tr>
<tr>
<tdcolspan="2">Yet Not Registered!! <ahref="reg.jsp">Register</a></td>
</tr>
</tbody>
</table>
</center>
</form>
</body>
</html>
24 | P a g e
9.3 User train booking
<%@pagecontentType="text/html"pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
<!DOCTYPEhtml>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html; charset=UTF-8">
<title>Book Ticket</title>
</head>
<bodybgcolor="#E3E2DE">
Train
Number: <%=session.getAttribute("tno")%>
Train Name: <%=session.getAttribute("tname")%><br>
Source: <%=session.getAttribute("s1")%>
Destination: <%=session.getAttribute("d1")%><br>
Date Of
Journey: <%=session.getAttribute("date1")%>
Class: <%=session.getAttribute("c1")%>
<center>
<tableborder="1"width="30%"height="30%">
<tr><th><fontcolor='#D18603'>S. No.</font></th>
<th><fontcolor='#D18603'>Name</font></th>
<th><fontcolor='#D18603'>Age</font></th>
<th><fontcolor='#D18603'>Gender</font></th>
<th><fontcolor='#D18603'>Berth Preference</font></th>
<th><fontcolor='#D18603'>Senior Citizen</font></th>
<th><fontcolor='#D18603'>AADHAAR No.(Optional)</font></th>
</tr>
<formmethod="post"action="bookconfirm.jsp">
<tr>
<td><b><fontcolor='#663300'>1</font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="name1"/></font></b>
</td>
<td><b><fontcolor='#663300'><inputtype="text"name="age1"/></font></b><
/td>
<td><b><fontcolor='#663300'><selectname="gender1">
<optionvalue="select">Select</option>
<optionvalue="male">Male</option>
<optionvalue="female">Female</option>
</select></font></b></td>
25 | P a g e
<td><b><fontcolor='#663300'><selectname="berth1">
<optionvalue="no_preference">No Preference</option>
<optionvalue="lower">Lower</option>
<optionvalue="middle">Middle</option>
<optionvalue="upper">Upper</option>
<optionvalue="side_lower">Side Lower</option>
<optionvalue="side_upper">Side Upper</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><inputtype="checkbox"name="senior1"value="
senior"/></font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="aadhaar1"/></font><
/b></td>
</tr>
<tr>
<td><b><fontcolor='#663300'>2</font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="name2"/></font></b>
</td>
<td><b><fontcolor='#663300'><inputtype="text"name="age2"/></font></b><
/td>
<td><b><fontcolor='#663300'><selectname="gender2">
<optionvalue="select">Select</option>
<optionvalue="male">Male</option>
<optionvalue="female">Female</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><selectname="berth2">
<optionvalue="no_preference">No Preference</option>
<optionvalue="lower">Lower</option>
<optionvalue="middle">Middle</option>
<optionvalue="upper">Upper</option>
<optionvalue="side_lower">Side Lower</option>
<optionvalue="side_upper">Side Upper</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><inputtype="checkbox"name="senior2"value="
senior"/></font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="aadhaar2"/></font><
/b></td>
</tr>
<tr>
<td><b><fontcolor='#663300'>3</font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="name3"/></font></b>
</td>
<td><b><fontcolor='#663300'><inputtype="text"name="age3"/></font></b><
/td>
<td><b><fontcolor='#663300'><selectname="gender3">
<optionvalue="select">Select</option>
<optionvalue="male">Male</option>
<optionvalue="female">Female</option>
</select></font></b></td>
26 | P a g e
<td><b><fontcolor='#663300'><selectname="berth3">
<optionvalue="no_preference">No Preference</option>
<optionvalue="lower">Lower</option>
<optionvalue="middle">Middle</option>
<optionvalue="upper">Upper</option>
<optionvalue="side_lower">Side Lower</option>
<optionvalue="side_upper">Side Upper</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><inputtype="checkbox"name="senior3"value="
senior"/></font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="aadhaar3"/></font><
/b></td>
</tr>
<tr>
<td><b><fontcolor='#663300'>4</font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="name4"/></font></b>
</td>
<td><b><fontcolor='#663300'><inputtype="text"name="age4"/></font></b><
/td>
<td><b><fontcolor='#663300'><selectname="gender4">
<optionvalue="select">Select</option>
<optionvalue="male">Male</option>
<optionvalue="female">Female</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><selectname="berth4">
<optionvalue="no_preference">No Preference</option>
<optionvalue="lower">Lower</option>
<optionvalue="middle">Middle</option>
<optionvalue="upper">Upper</option>
<optionvalue="side_lower">Side Lower</option>
<optionvalue="side_upper">Side Upper</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><inputtype="checkbox"name="senior4"value="
senior"/></font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="aadhaar4"/></font><
/b></td>
</tr>
<tr>
<td><b><fontcolor='#663300'>5</font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="name5"/></font></b>
</td>
<td><b><fontcolor='#663300'><inputtype="text"name="age5"/></font></b><
/td>
27 | P a g e
<td><b><fontcolor='#663300'><selectname="gender5">
<optionvalue="select">Select</option>
<optionvalue="male">Male</option>
<optionvalue="female">Female</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><selectname="berth5">
<optionvalue="no_preference">No Preference</option>
<optionvalue="lower">Lower</option>
<optionvalue="middle">Middle</option>
<optionvalue="upper">Upper</option>
<optionvalue="side_lower">Side Lower</option>
<optionvalue="side_upper">Side Upper</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><inputtype="checkbox"name="senior5"value="
senior"/></font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="aadhaar5"/></font><
/b></td>
</tr>
<tr>
<td><b><fontcolor='#663300'>6</font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="name6"/></font></b>
</td>
<td><b><fontcolor='#663300'><inputtype="text"name="age6"/></font></b><
/td>
<td><b><fontcolor='#663300'><selectname="gender6">
<optionvalue="select">Select</option>
<optionvalue="male">Male</option>
<optionvalue="female">Female</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><selectname="berth6">
<optionvalue="no_preference">No Preference</option>
<optionvalue="lower">Lower</option>
<optionvalue="middle">Middle</option>
<optionvalue="upper">Upper</option>
<optionvalue="side_lower">Side Lower</option>
<optionvalue="side_upper">Side Upper</option>
</select></font></b></td>
<td><b><fontcolor='#663300'><inputtype="checkbox"name="senior6"value="
senior"/></font></b></td>
<td><b><fontcolor='#663300'><inputtype="text"name="aadhaar6"/></font><
/b></td>
</tr>
<tr>
28 | P a g e
<tdcolspan="10"><inputtype="submit"value="Submit"/></td>
<td><inputtype="reset"value="Reset"/></td>
</tr>
</form>
</table>
<br><br><ahref='logout.jsp'>Log out</a>
</center>
</body>
</html>
29 | P a g e
CHAPTER – 10 CONCLUSION
10.CONCLUSION
SUMMARY OF ACHIEVEMENTS
30 | P a g e
CHAPTER - 11 REFERENCE
Reference
31 | P a g e
CHAPTER – 12 WEBSITE
Websites:
1. https://www.javatpoint.com/java-tutorial.
2. https://www.slideshare.net/masterpiyush/online-railway-reservation- system-33260680
3. https://www.visual-paradigm.com/guide/data-flow-diagram/what-is- data-flow-diagram/
4. http://www.businessdictionary.com/definition/work-environment.html
5. https://www.javatpoint.com/jsp-tutorial
6. https://www.javatpoint.com/css-tutorial
7. https://www.javatpoint.com/mysql-tutorial
32 | P a g e