Scribd
Upload
1K views12 pages

Railway Reservation System: Data Base Management System Project

The document describes a proposed railway reservation system database project. The objectives are to design a structural database for the railway system and allow passengers to reserve tickets online. An entity relationship diagram is presented showing tables for passengers, trains, tickets, searches and a train authority. The database aims to make the ticket booking process easier and save time over the current manual system.

Uploaded by

Rifat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
1K views12 pages

Railway Reservation System: Data Base Management System Project

The document describes a proposed railway reservation system database project. The objectives are to design a structural database for the railway system and allow passengers to reserve tickets online. An entity relationship diagram is presented showing tables for passengers, trains, tickets, searches and a train authority. The database aims to make the ticket booking process easier and save time over the current manual system.

Uploaded by

Rifat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Railway

Reservation System
DATA BASE MANAGEMENT SYSTEM PROJECT
Railway Reservation System

 Presented By:  Supervised By:

 Md. Monzurul Haque Rifat  Md. Shafiul Alam Forhad


 ID-1704011  Assistant Professor,
Department of CSE,CUET

 Md. Atiqul Islam Rizvi


 Lecturer,Department of CSE, CUET
Contents

 Introduction
 Motivation
 Objectives
 Proposed Methodology(ER Diagram)
 Conclusion
Introduction

 This system is basically concerned with the reservation of railway


tickets to the passengers.
 This is an online based reservation system.
 The need of this system arose because as is the known fact that
Bangladesh has the largest railway network and to control the
system manually is so tough job.
 Passenger can easily book their train ticket, will able to know the
train status , seat availability.
Motivation

 It will save the valuable working time.


 It will Make the booking ticket system easy.
 Provide a comprehensive set of features to enhance their
operational limits.
 Evaluate other management system project performance in
different scenarios.
 Suggest modification for greater efficiency.
Objective

 The objective of this project is to give structural design to railway


system.
 Implementing a basic data structure operations on mysql
 The project provides functionality and flexibility to railway system
such that one can operate that system easily and efficiently.
 To reserve ticket by online.
Proposed Methodology(ER Diagram)
ER-TO-RELATIONAL MAPPING
Passenger
Email Password Pass_Name Gender Pass_id Pauthority_id

Search

Spass_id Strain_id

Train
Train_Name Destination Train_id Tauthority_id

Ticket
Ticket_id class Arrival_time Depart_time Payment Tauthority_ Ttrain_id Tpass_id
id

Train_Authority

Authority_id Apassword
1st Normal Form

There is no multivalued attribute in this schema so it’s in first normal form


2nd Normal Form
There is no partial dependency in this schema so it is in second normal form
3rd Normal form

Passenger
Email Password Pass_Name Gender Pass_id Pauthority_id

Search
Spass_id Strain_id

Train
Train_Name Destination Train_id Tauthority_id

Ticket
Ticket_id class Arrival_time Depart_time Payment Tauthority_ Ttrain_id Tpass_id
id

Train_Authority

Authority_id Apassword
Conclusion

 After implementing this project I hope I can assure a passenger to


book his railway ticket without being physically present , via my
System.
 It will save time and give the security of ticket and money.
 My railway reservation system is safe and easy to use.

You might also like