VISVESVARAYA TECHNOLOGICAL UNIVERSITY
BELAGAVI - 560010
A DBMS MINI PROJECT REPORT ON
“RAILWAY MANAGEMENT SYSTEM”
Submitted in partial fulfilment of the requirements for the Vth semester DBMS lab
BACHELOR OF ENGINEERING IN
COMPUTER SCIENCE AND ENGINEERING
by
ABHINAYA V
(1SP21CS032)
Under the guidance
Of
Mrs. SUSHMA B.A
Assistant Professor
Dept. of CSE
Department of Computer Science and Engineering
S.E.A COLLEGE OF ENGINEERNIG AND TECHNOLOGY
BENGALURU-560049
2023-2024
S.E.A COLLEGE OF ENGINEERING AND
TECHNOLOGY
Bangalore, Karnataka 560049
(Affiliated to Visvesvaraya Technological University, Belagavi)
Department of Computer Science and Engineering
CERTIFICATE
This is to certify the project work entitled “RAILWAY MANAGEMENT SYSTEM” has
been successfully carried out by Ms. ABHINAYA V, bearing USN 1SP21CS003, of Vth
sem in partial fulfilment for the award of Bachelor of Engineering in the Computer
Science and Technology of the Visvesvaraya Technological University, Belgaum during
the year 2023. The project report has been approved as it satisfied the academic
requirements in respect of the mini project work prescribed for Bachelor of Engineering.
Signature of Co-ordinator Signature of HOD
Mrs. SUSHMA B.A Mr. Sukesh
Signature of Internal Examiner Signature of External
Examiner
ACKNOWLEDGEMENT
Firstly, I thank the Management late Shri A. Krishnappa, Chairman SEA College of
Engineering and Technology for providing necessary infrastructure and creating good
environment.
I would like to express my profound thanks to our respected principal Dr. B Venkata Narayan
for the encouragement and support given by him.
I would like to express my sincere thanks to our respected Mr..Sukesh HOD of Computer
Science and Engineering and my project guide for her assistance and guidance.
I have got an opportunity to develop project, while undertaking the project entitled
“RAILWAY MANAGEMENT SYSTEM”.
I give my sincere thanks to my project guide Mrs. SUSHMA B.A who have always been a
guiding, encouraging and motivating force. She has provided us with valuable guidance and
motivating force. She also drew my attention towards various other processes that were
being followed in the organization under the framework of software development. It has
been fascinating learning experience, which I will always cherish in my heart.
I also extend our thanks to all faculty members of COMPUTER SCIENCE Dept. who all give us
valuable guidance and help when we need it since we started development of the project.
My obligations remain due to all those people who have directly or indirectly helped me in
successful completion of my project. No amount of words written here will suffice for my
sense of gratitude towards them all.
ABHINAYA V
(1SP21CS003)
ABSTRACT
The railway network of our country is one of the most complex public establishments. You
can design a database solution for this network and make the management of the same more
natural. Your system should have the following pieces of information:
Station names
Tracks that connect those stations (to keep things simple, you can assume that only one track
runs between two stations) Train IDs with names
Schedules of the trains
The train schedules should have information on the stations from where the train starts and by
when it reaches the destination. It should also include information on which stations it passes
through during its journey.
To keep things simple, you can assume that every train completes its journey within a day,
and they run daily. However, you’ll also need to store information on the sequence of the
stations a train passes through. For example, if a train starts from Delhi and goes to Kolkata
through Lucknow, then you’ll need to add the arrival and departure times of the train fo rall
these stations. Keeping the stations in sequence will allow easy management of trains and
their data.
Till here, the project is rather easy. You can make it more challenging by adding the
passenger information of every train such as its coaches, seat numbers, types of coaches,
passenger names, and so on. This project might take some time to complete, but it’ll help you
showcase your knowledge of database management solutions while solving a significant issue
of a public authority.
Table of Contents
1. Introduction ...................................................................Page No. 6
2. Design ........................................................................... Page No. 7
3. Hardware and Software Requirements .........................Page No. 8
4. Implementation ............................................................Page No. 09
5. Objective and scope…....................................................Page No. 10
6.Connectivity code ...........................................................Page No. 11
7.ER Diagram…...................................................................Page No. 13
8.Shema diagram ..............................................................Page No.14
9.Results and Screenshots……………………………………………...Page No.15
10.Conclusion…………………………………………………………………Page No.17
11.References…………………………………………………………………Page No.18
RAILWAY MANAGEMENT SYSTEM
Introduction
RAILWAY RESERVATION SYSTEM should be able to manage all the reservation related
functions. The system should be distributed in nature. This system is divided into five zones.
Each zone should have same functionalities. Each zone will stores the information about
train name, train schedules, availability. The administrator should be able to enter any
change related to the train information like change in train name, number etc. The system
should be able to reserve seat in a train for a passenger. First the clerk will check for
availability for the seats in a particular train on a specified date of journey. If it is available
the clerk will reserve seats. The passenger will be given a unique PNR no. The system should
be able to cancel a reservation. The clerk will delete the entries in the system. The passenger
can check their reservation status online by entering their PNR no. The system will display
his current status like confirmed, RAC or waiting list. They are also able to see information
related to the train schedules.
The system should be able to print the report like it should be able to generate reservation
chart, train report, reservation ticket which will have train no and name, date of journey,
boarding station, destination station, person name, age, [censored], total fare and a unique
PNR no. The system should be able to print the cancellation ticket which will have total fare
and the amount deducted.
The main aim of the project was to develop a website which would facilitate the reservation
of online air tickets through an effective and yet simple GUI for a normal passenger
intending to travel in airways. Apart from reserving tickets, through our system a passenger
can compare online fares ‘from’ various cities ‘to’ various cities.
Database is an organized collection of data. The data is typically organized
tomodel aspects of reality in a way that supports processes requiring information.A DBMS
makes it possible for users and the end-users to create, read, update and delete database.
These three foundational elements help provide concurrency,security, data
integrity and uniform administration procedures. The DBMS canoffer both logical and
physical data independence Which means it can protect users and applications
from needing to know where data is stored or having to be concerned about
changes to the physical structure of data
DEPT OF CSE,SEACT 6 2023-24
RAILWAY MANAGEMENT SYSTEM
Design
Brief overview of the technology:
Front end: HTML, CSS, JavaScript
1. HTML: HTML is used to create and save web document. E.g. Notepad/Notepad++
2. CSS : (Cascading Style Sheets) Create attractive Layout
3. Bootstrap : responsive design mobile freindly site
4. JavaScript: it is a programming language, commonly use with web browsers.
Back end: PHP, MySQL
1. PHP: Hypertext Preprocessor (PHP) is a technology that allows software developers to create
dynamically generated web pages, in HTML, XML, or other document types, as per client
request. PHP is open source software.
2. MySQL: MySql is a database, widely used for accessing querying, updating, and managing
data in databases.
DEPT OF CSE,SEACT 7 2023-24
RAILWAY MANAGEMENT SYSTEM
Software Requirement(any one)
WAMP Server
XAMPP Server
MAMP Server
LAMP Server
Installation Steps
1.Download zip file and Unzip file on your local server.
2. Put this file inside "c:/wamp/www/" .
3. Database Configuration
Open phpmyadmin
Create Database named railres.
Import database railres.sql from downloaded folder(inside database)
4. Open Your browser put inside "http://localhost/railway reservation system in php/
DEPT OF CES,SEACET 5
2023-24
RAILWAY MANAGEMENT SYSTEM
Implementation
• main.py code connects the database and the frontend (UI)
• XAMPP sever is needed to be initialized, then both Apache and MySQL Module has to
started hms database
MySQL Server – Admin Page
Result
The application runs successfully.
DEPT OF CSE,SEACET 9 2023-24
RAILWAY MANAGEMENT SYSTEM
Objective and Scope of the project:
Database is an organised collection of data. The data is typically organised to model
aspects of reality in a way that supports processes requiring information.
A DBMS makes it possible for end users to create read update and delete data in a
database
The main purpose of maintaining a database for railway reservation systems is to
reduce the manual errors involved in the booking and cancellation of tickets and
make it convenient for the customers and providers to maintain the data about their
customers and also the seats available to them.
This project is about creating a database for the railway reservation system.
The aim is to design and develop a database maintaining the records of different
trains, passengers, tracks, stations, schedule and routes.
The project also consists of station names, the tracks that connect those stations,
schedules of the train and the information of the station.
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
Sample Connectivity Code
1) try {
Class.forName("com.mysql.jdbc.Driver"); con1 =
DriverManager.getConnection("jdbc:mysql://localhost/railway system", "root", "");
insert = con1.prepareStatement("select * from passengers");
ResultSet rs = insert.executeQuery();
ResultSetMetaData Rss =
rs.getMetaData(); c =
Rss.getColumnCount();
DefaultTableModel Df = (DefaultTableModel)jTable1.getModel();
Df.setRowCount(0);
while(rs.next()){
Vector v2 = new Vector();
for(int i=1;i<=c; i++)
{ v2.add(rs.getString("P_NAME"));
v2.add(rs.getString("AGE"));
v2.add(rs.getString("GENDER"));
v2.add(rs.getString("MOBILE"));
v2.add(rs.getString("COACH"));
}
Df.addRow(v2);
}
} catch (ClassNotFoundException | SQLException ex) {
Logger.getLogger(book.class.getName()).log(Level.SEVERE, null, ex);
}
2) try {
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
Class.forName("com.mysql.jdbc.Driver"); con1 =
DriverManager.getConnection("jdbc:mysql://localhost/railway system", "root", "");
insert = con1.prepareStatement("Select * from details where SRC=? and DST=? ");
insert.setString(1, from); insert.setString(2, to);
ResultSet rs = insert.executeQuery();
ResultSetMetaData rsm =
rs.getMetaData(); int c;
c = rsm.getColumnCount();
DefaultTableModel df = (DefaultTableModel)jTable1.getModel();
df.setRowCount(0);
while(rs.next()){
Vector v2 = new Vector();
for(int i=1;i<=c;i++)
{ v2.add(rs.getString("TID"));
v2.add(rs.getString("TNAME")
); v2.add(rs.getString("SID"));
}
df.addRow(v2);
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(main.class.getName()).log(Level.SEVERE, null, ex); }
catch (SQLException ex) {
Logger.getLogger(main.class.getName()).log(Level.SEVERE, null, ex);
}
ER Diagram
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
Schema Diagram
Results Screenshots
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
CONCLUSION
In our project railway system we have all the information saved regarding the train,
passengers, tracks, where and how The Train moves, station, schedules, routes and what it
consists of. We have only considered the most important requirements, many more features
and details can be added to our project in order to obtain even more user-friendly applications.
These applications are already in progress and in future they can be upgraded and may
become part of Amazing Technology.
DEPT OF CSE,SEACET 10 2023-24
RAILWAY MANAGEMENT SYSTEM
REFERENCES
1.http://msdn.microsoft.com
2.http://www.microsoft.com
3.http://www.goggle.com
5.https://www.w3schools.com/sql/sql_create_db.asp
6.https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in
7.https://creately.com/diagram/example/hwk8yyfs1/ER%20diagram%20of%20Railway%2
0reservation%20System
BOOKS
1.developing window based application with microsoft
2.Software engineering-pressman
3.Data base system concept.
4.Fundamentals_of_Database_Systems,_6th_Edition
DEPT OF CSE,SEACET 10 2023-24
