RAILWAY RESERVATION 2012
PROJECT REPORT ON
RAILWAY RESERVATION
PREPARED BY:- THUMMAR DHARA
GADHIYA KINARA
Develop by: THUMMAR DHARA & GADHIYA KINARA
1
RAILWAY RESERVATION 2012
1) Preface
2) Acknowledgement
3) project Profile
Title
Documentation Tools
Project Duration
Project Team Size
Project Guide
Develop By
Submitted To
4) Introduction
5) Project Summary
6) System Requirement
7) Technology Study
8) Analysis
Requirement
System Analysis
Feasibility Analysis
9) Design
Data flow Diagram
ER-Diagram
Screen Shots
10) Project Risk
11) Conclusion
12) Bibliography
Develop by: THUMMAR DHARA & GADHIYA KINARA
2
RAILWAY RESERVATION 2012
PREFACE
I am pleased to submit this report on the project developed at Shree M &
N Virani Science College, Rajkot as a part of 5th semester curriculums.
Once you login to the system, you can use all the facilities
provided by this windows application. It reduces the complexity of user
to use such system like forum. The user can also use other facilities of
this site is search engine.
This project report contains overview of the project. The person
with technical knowledge about web development can easily understand
the contents of this project.
Whole implementation of this site is shown with figures, Data
Flow Diagrams, Databases and screen shots. Thats why; it is very easy
to understand for any person.
Develop by: THUMMAR DHARA & GADHIYA KINARA
3
RAILWAY RESERVATION 2012
ACKNOWLEDGEMENT
As per the schedule of the course of B.C.A, The project work is
must for each and every student in different government organization or
private organization. During development period, the student has to
develop software and implement it successfully.
We are the student of B.C.A (Shree M & N Virani Science
College, Rajkot) is affiliated with Saurashtra University.
It is a matter of great pleasure for us to this opportunity expressing
our sincere sense of gratitude to Mr. Pardip Vanpariya & Mr. Keyur
zala for giving us precious guidance, inspiration and great support
throughout the project development. We are especially thankful to him
for their kind co-operatio.
We are thankful to respected Mr. A.U.Patel (Principal of Shree M
& N Virani Science College, Rajkot) for giving us opportunity to do this
project. His Inspiration and generous support gave us sufficient strength
to prepare the project.
We are also thankful to respected Mr. Hitendra Donga & Stavan
Patel (H.O.D of Computer Department) whose energetic support,
guidance and inspiration gave us a vast path to the success of this
project.
Only the expression of Thanks cant appreciate these wonderful
and kindly natured persons who contributed their best efforts to help us.
Thank You to all of you with honors.
Develop by: THUMMAR DHARA & GADHIYA KINARA
4
RAILWAY RESERVATION 2012
PROJECT PROFILE
PROJECT TITLE :-
Railway Reservation
HARDWARE AND SOFTWARE USED :
Software Requirement :-
Operating System :- Windows Xp/7
Front end :- Microsoft Visual Studio 2008
Back end :- Sql Servar2008
Hardware Requirements :-
RAM :- 412 MB or more
Hard disk :- 10 GB or more
Develop by: THUMMAR DHARA & GADHIYA KINARA
5
RAILWAY RESERVATION 2012
DOCUMENTATION TOOLS :-
Microsoft word 2007
Microsoft Visio 2007
PROJECT DURATION:
4 MONTHS
PROJECT TEAM SIZE:
2 Partners
SEM YEAR :
6th SEM 2012
PROJECT GUIDE:
Mr. Pradip Vanpariya
Mr. keyur Zala
DEVELOPED BY:
Ms. Thummar Dhara
Ms. Gadhiya Kinara
SUBMITTED TO:
Shree M & N Virani Science College, Rajkot
Develop by: THUMMAR DHARA & GADHIYA KINARA
6
RAILWAY RESERVATION 2012
Introduction
This project will give us the information about railway reservation .
This system is basically concerned with the reservation and
cancellation of railway tickets to the passengers. To be more specific,
our system is limited in such a way that a
train starting from a particular source will have a single destination .
The basic functions being performed by our system are reservation and
cancellation.
Customers can find the proper and correct information about the railway
and shows the
It reserves and cancels seats for the passenger.
It contains information about the trains.
It contains information about the Seat Availability
Railway time table
Reservation Possibilities.
Train Ticket booking,
Booked Railway Ticket Status,
Train between stations
Develop by: THUMMAR DHARA & GADHIYA KINARA
7
RAILWAY RESERVATION 2012
Technology Study
Introduction to c#:
Microsoft its new, object-oriented language, C#, as the best
language for writing Microsoft .NET applications.
C# provides the rapid application development found in Visual
Basic with the power of C++.
C# syntax is similar to C++ syntax. Some experts also say that C#
is Microsoft's answer to Sun Microsystems' Java and Borland's
Delphi.
C# could theoretically be compiled to machine code, but in real
life, it's always used in combination with the .NET framework.
Therefore, applications written in C#, requires the .NET
framework to be installed on the computer running the
application.
While the .NET framework makes it possible to use a wide range
of languages, C# is sometimes referred to as THE .NET language,
perhaps because it was designed together with the framework.
C# is an Object Oriented language and does not offer global
variables or functions.
Develop by: THUMMAR DHARA & GADHIYA KINARA
8
RAILWAY RESERVATION 2012
Everything is wrapped in classes, even simple types like int and
string, which inherits from the System. Object class.
In .NET, the Object class is the root of all types.
All types are implicitly derived from this class so they have
access to the methods defined in the Object class.
Features of C#:
Reference and output parameters
Objects on the stack (structs)
Rectangular arrays
Enumerations
Unified type system
Goto
Versioning
Component-based programming
Properties
Events
Reflection
Delegates
Smart Array
Indexers
Operator overloading
Develop by: THUMMAR DHARA & GADHIYA KINARA
9
RAILWAY RESERVATION 2012
SQL Server 2008
SQL Server 2008 is a high specification database management system
that replaces SQL Server 2005. In addition to the original version, SQL
Server 2008R and 2008R2 are available with a simple upgrade.
According to Microsoft's brochure the SQL Server 2008 can "manage
any data, any time, any place." With such a strong mission statement the
softwtare system is at the pinnacle of modern and integrative data
management.
SQL Server 2008 Features
Search and query functions are faster by a feature that reduces
storage space through data compression.
Security is paramount with a new data encryption application as
well as a policy management feature that ensures compliance
across the network
Performance System Analysis is another feature enabling a system
wide troubleshoot for specific criteria or problems within the
database. Finally, continuity for applications and hardware
upgrades provide a seamless platform for growth.
SQL Server 2008 Technologies
SQL Server 2008 is available in two main editions and four
specialized editions and caters for all business types.
Develop by: THUMMAR DHARA & GADHIYA KINARA
10
RAILWAY RESERVATION 2012
System Analysis
We have gathered all information by visiting a main office and
analyze the working of the government railway reservation system.
How they maintain details of passengers.
Today all reservation systems in real time are computerized. All
transactions of railway reservation can be done through software
related to railway reservation.
Today user wants to do transactions fastly so they can use software
or system for store information access the information. So we have
developed such a software, they can help them.
According to analysis of many sites and reservation system we put
all the facilities that can help the users to get reservation.
Facilities like reservation, cancellation of tickets, get the distance
between cities and etc.
Develop by: THUMMAR DHARA & GADHIYA KINARA
11
RAILWAY RESERVATION 2012
Feasibility
The feasibility study is the important step in any system development
process. Because it makes analysis of different aspects like cost
required for developing and executing the system, the time required
for each stage of the system.
If these important factors are not analyzed then definitely it would
be a total failure. So for running the application and the organization
successfully this step is a very important step in a software
development lifecycle process.
There are three types of feasibility analysis:
1) Operational feasibility
2) Technical feasibility
3) Economical/financial feasibility
1) Operational Feasibility:-
Operational feasibility measures how well the solution will
work in the organization and how will end-user &
management feels about the system. Proposed system is
helpful for all the users associated with the organization.
It will allow the administrator to have up-to-date
information regarding all the aspects of their users, the
decision-making process will also become faster with the
Develop by: THUMMAR DHARA & GADHIYA KINARA
12
RAILWAY RESERVATION 2012
use of data integration, consolidation. So it is feasible to
implement the system.
2) Technical feasibility:-
This involves questions such as whether the technology
needed for the system exists, how difficult it will be to
build, and whether the firm has enough experience using
that technology.
This system required minimum hardware equipment to
run efficiently.
3) Economical feasibility:-
Economically to find out whether this project is
economically feasible or not for that used feasibility
analyses.
In this stage list direct costs or indirect costs associated
with the project.
Develop by: THUMMAR DHARA & GADHIYA KINARA
13
RAILWAY RESERVATION 2012
User Requirements
To do the reservation transaction user must have the unique user
name and password.
Users should be able to view a train detail according to their
requirements.
For reservation booking user has to fill all the information that is
given in the form.
User can cancel the reservation by giving the unique passenger id
and other necessary details.
User can get the distance between two cities by giving the name of
cities.
Develop by: THUMMAR DHARA & GADHIYA KINARA
14
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
15
RAILWAY RESERVATION 2012
Data flow Diagram
Definition:
Data-Flow design is concerned with designing a sequence of functional
transformations that converts system inputs into the required outputs.
Data-flow diagrams are useful and intuitive way of describing a system.
They are normally understandable without special training, especially if
control information is excluded.
Conventions used in drawing the data-flow diagram, here are given as
below:
Process
Data Storage
Entity
Data Flow
Develop by: THUMMAR DHARA & GADHIYA KINARA
16
RAILWAY RESERVATION 2012
Data Flow Diagram
Develop by: THUMMAR DHARA & GADHIYA KINARA
17
RAILWAY RESERVATION 2012
E R Diagram
cancelation Distance_city Reservation
PK p_id
p_name starting_station
p_age p_id
ending_station p_name
p_sex distance
t_no p_age
t_name p_sex
Avaialable seat Address
s_station
e_station PK t_no city
via pin_code
class_type t_name contact_no
fare s_ac t_no
seat_no t_ac t_name
refund_case as_seat s_station
f_class e_station
Train_detail s_class via
g_seat class_type
s_station fare
train_no e_station seat_no
train_name Dp_time dp_time
not_abv j_date
s_station Train_fare j_month
e_station j_year
via_to
s_ac train_no
t_ac train_name
ac s_station
f_class e_station
s_class distance
gen_seat s_ac
dp_time t_ac
f_class
s_class
genral
Develop by: THUMMAR DHARA & GADHIYA KINARA
18
RAILWAY RESERVATION 2012
Table Name: Cancelation
Table Name: Distance_city
Develop by: THUMMAR DHARA & GADHIYA KINARA
19
RAILWAY RESERVATION 2012
Table Name: Availableseat
Table Name: Login
Develop by: THUMMAR DHARA & GADHIYA KINARA
20
RAILWAY RESERVATION 2012
Table Name: Reservation
Develop by: THUMMAR DHARA & GADHIYA KINARA
21
RAILWAY RESERVATION 2012
Table Name: Train_detail
Table Name: Train_fare
Develop by: THUMMAR DHARA & GADHIYA KINARA
22
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
23
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
24
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
25
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
26
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
27
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
28
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
29
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
30
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
31
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
32
RAILWAY RESERVATION 2012
Project Risk
Project Risks threaten the project plan that is, if project risk become real are
likely project schedule will slip and that costs will increase.
Project risk identify potential budgetary, schedule, personal, resource and
requirement problems and their impact on a software project.
Project complexity, size and degree of structural uncertainly where also defined
as project risk factor.
We have distributed the possible risk the following categories and tried to find
out the possible risk categories:-
1. Size-related risks: Risk related with the size of the project
2 . Process definition: Risk associated with the degree to
which I have defined my software installation process.
3 . Development environment risk: Risk associated with the
availability and quality of the tools to be used to build the
product.
4. Technology risk: Technology availability and usability.
5. Experience: Available experience in me concerned technology.
Develop by: THUMMAR DHARA & GADHIYA KINARA
33
RAILWAY RESERVATION 2012
Conclusion
Practical Training is a very important part of the curriculum as it
strengthens the concepts and enhances knowledge about the practical
implementation of all the theory concepts, we have learn so far in
different subjects.
Our project is railway reservation system. This project is used to keep a
track on reserving the seat to the passenger. It helps managing the
system very efficiently and conveniently.
Although the project work has been done in a complete and detailed
manner but due to the constraint of time, we could not include some
more features we wanted to. We left these features as a part of the
feature development. As soon as well get time well try to add them to
my project.
Develop by: THUMMAR DHARA & GADHIYA KINARA
34
RAILWAY RESERVATION 2012
BiBlioGraphy
1) Book:=
Programming with C#
By Balaguru sami
Programming with c#
By Bharat & Co.
C#.net - Unleashed
2) Websites:=
www.google.com
Develop by: THUMMAR DHARA & GADHIYA KINARA
35
RAILWAY RESERVATION 2012
Develop by: THUMMAR DHARA & GADHIYA KINARA
36
