尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
RAILWAYS RESV & MGMT SYSTEM
A PROJECT ON ORACLE 11G
PROJECT PROFILE
• RAILWAY BOOKING & MGMT SYSTEMPROJECT TITLE
• 1 MONTHPROJECT DURATION
• MOHOSIN SIRPROJECT GUIDE
• CONSOLE PVT LTDSUBMITTED TO
• 6 MEMBERSTEAM STRENGTH
TEAM MEMBERS
ASHUTOSH KUMAR
JAYANT KUMAR
MAYANK MRINAL
NIKHIL RAJ
RAHUL SHARMA
PRAVEEN KUMAR JHA
AGENDA
Introduction
Scope and feasibility
Technical Details
System Requirements
Introduction to Oracle
Terminology
Oracle on Network
AGENDA
DFD Level 0
DFD Level 1
DFD Level 2 : Train Enquiry
DFD Level 2 : Ticket Resv & Payment
DFD Level 2 : Ticket Cancel & Refund
ER Diagram
Conclusion
INTRODUCTION
• Explains online railway reservation system of
Indian Railways, from scratch.
• Need of such system arose from the fact that
India has 2nd largest rail network in the world.
• To overcome many limitations, more efficient,
easy handling of data and records .
• Consumer satisfaction.
SCOPE AND FESIBILITY
• Implementations of this project idea are in
industrial use in the form of ‘www.irctc.co.in’.
• Hence, this can be used for suggesting
improvements in design, performance and
greater usability.
• Apart from the industrial applications, it is a
research oriented project as well, the task of
performance evaluation of different database
designs, for efficiency, is in this spirit.
TECHNICAL DETAILS
BACKEND
DATABASE
ORACLE 11 G
OS
PLATFORM
WINOWS 7
OTHER
PLATFORM
RED HAT LINUX
ENTERPRISE
EDITION 5
SOFTWARES
CHROME
SCREEN CASTER
TEXT PAD
SYSTEM REQUIREMENTS
Oracle binary installation requires :
• MEMORY REQUIREMENTS
• DISK SPACE REQUIREMENTS :
• PROCESSER REQUIREMENTS : Intel core processors (32 bit or 64 bit)
Available RAM SWAP Space Requirement
Between 1 GB and 2 GB 1.5 times the size of the RAM
Between 2 GB and 16 GB Equal to the size of the RAM
More than 16 GB 16 GB
Installation Type
Minimum Requirement for
Software Files (GB)
Enterprise Edition 4.35
Standard Edition 4.22
INTRODUCTION TO ORACLE
Oracle Binary Installation
Refers to installation of binary executable i.e full
server software that supports :
– Configuring listener
– Creating customized databases
– Configuring & monitoring tablespace
– Create users , grant or revoke permissions from
the user
– and lots more…. 
Terminology
• Organized collection of data in digital form.
• In such a way that a computer program can quickly
select desired pieces of dataDATABASE
• Used to optimize performance.
• Provides a layer of abstraction between physical and logical
data
• Storage location where the actual data underlying database
objects are kept.
TABLESPACE
• Model of vertical columns and horizontal rows, the
intersection is called cell
• Stores logically related data in the se cells
TABLES
ORACLE ON NETWORK
How Oracle connects over a network?
– Listener : An OS object through which
database can be connected in a network
– TNSListener , is a Oracle listener which
by default listens on port no 1521
– It can be configured using listener.ora file
located at C:app<user>product11.1.0db_1NETWORKADMIN
– Stores the server name, port no and database name.
– If it receives any request from the network , it checks the parameter
file , listener.ora whether the database is available or not . if available
it will help to create a session for the request.
DFD - LEVEL 0
DFD - LEVEL 1
TRAIN ENQUIRY
TICKET RESV & PAYMENT
TICKET CANCEL & REFUND
ADMIN LEVEL 1
ADMIN LEVEL 2
ER DIAGRAM
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 learnt so far in different subjects.
• This summer training helped us learn a lot. In this training we
did the project on 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.
REFERENCES
Wikipedia
Google
Blogspot
Smartdraw
Oracle
Indian Railways Redhat
Wikimedia
Railway booking & management system

More Related Content

What's hot

Online railway reservation system
Online railway reservation systemOnline railway reservation system
Online railway reservation system
राजेंद्र कदम
 
Project report RAILWAY TICKET RESERVATION SYSTEM SAD
Project report RAILWAY TICKET RESERVATION SYSTEM SADProject report RAILWAY TICKET RESERVATION SYSTEM SAD
Project report RAILWAY TICKET RESERVATION SYSTEM SAD
Nitesh Singh
 
Ppt on ONLINE BOOK STORE
Ppt on ONLINE BOOK STOREPpt on ONLINE BOOK STORE
Ppt on ONLINE BOOK STORE
Shashank Srivastava
 
Railway Reservation System - Requirement Engineering
Railway Reservation System - Requirement EngineeringRailway Reservation System - Requirement Engineering
Railway Reservation System - Requirement Engineering
Danish Javed
 
Airline Reservation System
Airline Reservation SystemAirline Reservation System
Airline Reservation System
Arohi Khandelwal
 
RAILWAY RESERVATION SYSTEM.pptx
RAILWAY RESERVATION SYSTEM.pptxRAILWAY RESERVATION SYSTEM.pptx
RAILWAY RESERVATION SYSTEM.pptx
ManishBhoir6
 
srs for railway reservation system
 srs for railway reservation system srs for railway reservation system
srs for railway reservation system
khushi kalaria
 
E-TICKETING ON RAILWAY TICKET RESERVATION
E-TICKETING ON RAILWAY TICKET RESERVATIONE-TICKETING ON RAILWAY TICKET RESERVATION
E-TICKETING ON RAILWAY TICKET RESERVATION
Nandana Priyanka Eluri
 
Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...
Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...
Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...
grandhiprasuna
 
Online Railway reservation
Online Railway reservationOnline Railway reservation
Online Railway reservation
Oyindrila Bhattacharya
 
Online Ticket Reservation System-SRS, ERD, DFD, Structured Charts
Online Ticket Reservation System-SRS, ERD, DFD, Structured ChartsOnline Ticket Reservation System-SRS, ERD, DFD, Structured Charts
Online Ticket Reservation System-SRS, ERD, DFD, Structured Charts
grandhiprasuna
 
Railway Reservation system Case study of oracle db by cj date
Railway Reservation system Case study of oracle db by cj dateRailway Reservation system Case study of oracle db by cj date
Railway Reservation system Case study of oracle db by cj date
memonsana
 
Synopsis on railway reservation system
Synopsis on railway reservation systemSynopsis on railway reservation system
Synopsis on railway reservation system
Ankit Verma
 
Online Food Ordering System Presentation
Online Food Ordering System PresentationOnline Food Ordering System Presentation
Online Food Ordering System Presentation
RohanRajMudvari
 
Bus management system
Bus management systemBus management system
Bus management system
Shamim Ahmed
 
Online vehicle service center management system project report
Online vehicle service center management system project reportOnline vehicle service center management system project report
Online vehicle service center management system project report
mehulgundaliya
 
Online Food Ordering System
Online Food Ordering SystemOnline Food Ordering System
Online Food Ordering System
Ankita Jangir
 
ER diagrams for Railway reservation system
ER diagrams for Railway reservation systemER diagrams for Railway reservation system
ER diagrams for Railway reservation system
Soham Nanekar
 
19701759 project-report-on-railway-reservation-system-by-amit-mittal
19701759 project-report-on-railway-reservation-system-by-amit-mittal19701759 project-report-on-railway-reservation-system-by-amit-mittal
19701759 project-report-on-railway-reservation-system-by-amit-mittal
satyaragha786
 
Bus Ticket Management System Documentation
Bus Ticket Management System DocumentationBus Ticket Management System Documentation
Bus Ticket Management System Documentation
muzammil siddiq
 

What's hot (20)

Online railway reservation system
Online railway reservation systemOnline railway reservation system
Online railway reservation system
 
Project report RAILWAY TICKET RESERVATION SYSTEM SAD
Project report RAILWAY TICKET RESERVATION SYSTEM SADProject report RAILWAY TICKET RESERVATION SYSTEM SAD
Project report RAILWAY TICKET RESERVATION SYSTEM SAD
 
Ppt on ONLINE BOOK STORE
Ppt on ONLINE BOOK STOREPpt on ONLINE BOOK STORE
Ppt on ONLINE BOOK STORE
 
Railway Reservation System - Requirement Engineering
Railway Reservation System - Requirement EngineeringRailway Reservation System - Requirement Engineering
Railway Reservation System - Requirement Engineering
 
Airline Reservation System
Airline Reservation SystemAirline Reservation System
Airline Reservation System
 
RAILWAY RESERVATION SYSTEM.pptx
RAILWAY RESERVATION SYSTEM.pptxRAILWAY RESERVATION SYSTEM.pptx
RAILWAY RESERVATION SYSTEM.pptx
 
srs for railway reservation system
 srs for railway reservation system srs for railway reservation system
srs for railway reservation system
 
E-TICKETING ON RAILWAY TICKET RESERVATION
E-TICKETING ON RAILWAY TICKET RESERVATIONE-TICKETING ON RAILWAY TICKET RESERVATION
E-TICKETING ON RAILWAY TICKET RESERVATION
 
Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...
Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...
Student Marks Analyzing System-Problem Statement, SRS, ERD, DFD, Structured C...
 
Online Railway reservation
Online Railway reservationOnline Railway reservation
Online Railway reservation
 
Online Ticket Reservation System-SRS, ERD, DFD, Structured Charts
Online Ticket Reservation System-SRS, ERD, DFD, Structured ChartsOnline Ticket Reservation System-SRS, ERD, DFD, Structured Charts
Online Ticket Reservation System-SRS, ERD, DFD, Structured Charts
 
Railway Reservation system Case study of oracle db by cj date
Railway Reservation system Case study of oracle db by cj dateRailway Reservation system Case study of oracle db by cj date
Railway Reservation system Case study of oracle db by cj date
 
Synopsis on railway reservation system
Synopsis on railway reservation systemSynopsis on railway reservation system
Synopsis on railway reservation system
 
Online Food Ordering System Presentation
Online Food Ordering System PresentationOnline Food Ordering System Presentation
Online Food Ordering System Presentation
 
Bus management system
Bus management systemBus management system
Bus management system
 
Online vehicle service center management system project report
Online vehicle service center management system project reportOnline vehicle service center management system project report
Online vehicle service center management system project report
 
Online Food Ordering System
Online Food Ordering SystemOnline Food Ordering System
Online Food Ordering System
 
ER diagrams for Railway reservation system
ER diagrams for Railway reservation systemER diagrams for Railway reservation system
ER diagrams for Railway reservation system
 
19701759 project-report-on-railway-reservation-system-by-amit-mittal
19701759 project-report-on-railway-reservation-system-by-amit-mittal19701759 project-report-on-railway-reservation-system-by-amit-mittal
19701759 project-report-on-railway-reservation-system-by-amit-mittal
 
Bus Ticket Management System Documentation
Bus Ticket Management System DocumentationBus Ticket Management System Documentation
Bus Ticket Management System Documentation
 

Viewers also liked

enhanced er diagram
enhanced er diagramenhanced er diagram
enhanced er diagram
CHANDRA BHUSHAN
 
DFMA design for manufacturing and assembly
DFMA design for manufacturing and assembly DFMA design for manufacturing and assembly
DFMA design for manufacturing and assembly
Automated Manufacturing Engineering Dept.
 
Airline reservation system db design
Airline reservation system db designAirline reservation system db design
Airline reservation system db design
UC San Diego
 
Railway Reservation System
Railway Reservation SystemRailway Reservation System
Railway Reservation System
Roccers
 
DFM BIT Coursework
DFM BIT CourseworkDFM BIT Coursework
DFM BIT Coursework
Myint Oo ( Jack )
 
Development Framework & Methods
Development Framework & MethodsDevelopment Framework & Methods
Development Framework & Methods
Nay Lynn Aung
 

Viewers also liked (6)

enhanced er diagram
enhanced er diagramenhanced er diagram
enhanced er diagram
 
DFMA design for manufacturing and assembly
DFMA design for manufacturing and assembly DFMA design for manufacturing and assembly
DFMA design for manufacturing and assembly
 
Airline reservation system db design
Airline reservation system db designAirline reservation system db design
Airline reservation system db design
 
Railway Reservation System
Railway Reservation SystemRailway Reservation System
Railway Reservation System
 
DFM BIT Coursework
DFM BIT CourseworkDFM BIT Coursework
DFM BIT Coursework
 
Development Framework & Methods
Development Framework & MethodsDevelopment Framework & Methods
Development Framework & Methods
 

Similar to Railway booking & management system

Opal: Simple Web Services Wrappers for Scientific Applications
Opal: Simple Web Services Wrappers for Scientific ApplicationsOpal: Simple Web Services Wrappers for Scientific Applications
Opal: Simple Web Services Wrappers for Scientific Applications
Sriram Krishnan
 
Best practices for large oracle apps r12 implementations apps14
Best practices for large oracle apps r12 implementations apps14Best practices for large oracle apps r12 implementations apps14
Best practices for large oracle apps r12 implementations apps14
Ajith Narayanan
 
A sdn based application aware and network provisioning
A sdn based application aware and network provisioningA sdn based application aware and network provisioning
A sdn based application aware and network provisioning
Stanley Wang
 
An AMIS overview of database 12c
An AMIS overview of database 12cAn AMIS overview of database 12c
An AMIS Overview of Oracle database 12c (12.1)
An AMIS Overview of Oracle database 12c (12.1)An AMIS Overview of Oracle database 12c (12.1)
An AMIS Overview of Oracle database 12c (12.1)
Marco Gralike
 
The Overview of Discovery and Reconciliation of LTE Network
The Overview of Discovery and Reconciliation of LTE NetworkThe Overview of Discovery and Reconciliation of LTE Network
The Overview of Discovery and Reconciliation of LTE Network
IRJET Journal
 
Sqlnet
SqlnetSqlnet
Sqlnet
maclean007
 
Whats new in Oracle Database 12c release 12.1.0.2
Whats new in Oracle Database 12c release 12.1.0.2Whats new in Oracle Database 12c release 12.1.0.2
Whats new in Oracle Database 12c release 12.1.0.2
Connor McDonald
 
First in Class: Optimizing the Data Lake for Tighter Integration
First in Class: Optimizing the Data Lake for Tighter IntegrationFirst in Class: Optimizing the Data Lake for Tighter Integration
First in Class: Optimizing the Data Lake for Tighter Integration
Inside Analysis
 
System Architecture Exploration Training Class
System Architecture Exploration Training ClassSystem Architecture Exploration Training Class
System Architecture Exploration Training Class
Deepak Shankar
 
Creating a Centralized Consumer Profile Management Service with WebSphere Dat...
Creating a Centralized Consumer Profile Management Service with WebSphere Dat...Creating a Centralized Consumer Profile Management Service with WebSphere Dat...
Creating a Centralized Consumer Profile Management Service with WebSphere Dat...
Prolifics
 
Distributed Clouds and Software Defined Networking
Distributed Clouds and Software Defined NetworkingDistributed Clouds and Software Defined Networking
Distributed Clouds and Software Defined Networking
US-Ignite
 
Best Practices Using RTI Connext DDS
Best Practices Using RTI Connext DDSBest Practices Using RTI Connext DDS
Best Practices Using RTI Connext DDS
Real-Time Innovations (RTI)
 
C19013010 the tutorial to build shared ai services session 2
C19013010 the tutorial to build shared ai services session 2C19013010 the tutorial to build shared ai services session 2
C19013010 the tutorial to build shared ai services session 2
Bill Liu
 
Kafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC Federal
Kafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC FederalKafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC Federal
Kafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC Federal
HostedbyConfluent
 
MOHAMMED VIKHAR AHMED
MOHAMMED VIKHAR AHMEDMOHAMMED VIKHAR AHMED
MOHAMMED VIKHAR AHMED
Mohammed Vaqar
 
5G-USA-Telemetry
5G-USA-Telemetry5G-USA-Telemetry
5G-USA-Telemetry
snrism
 
EC8551 COMMUNICATION NETWORKS
EC8551 COMMUNICATION NETWORKSEC8551 COMMUNICATION NETWORKS
EC8551 COMMUNICATION NETWORKS
GOWTHAMMS6
 
Grid optical network service architecture for data intensive applications
Grid optical network service architecture for data intensive applicationsGrid optical network service architecture for data intensive applications
Grid optical network service architecture for data intensive applications
Tal Lavian Ph.D.
 
Database As A Service: OEM + ODA (OOW 15 Presentation)
Database As A Service: OEM + ODA (OOW 15 Presentation)Database As A Service: OEM + ODA (OOW 15 Presentation)
Database As A Service: OEM + ODA (OOW 15 Presentation)
Bobby Curtis
 

Similar to Railway booking & management system (20)

Opal: Simple Web Services Wrappers for Scientific Applications
Opal: Simple Web Services Wrappers for Scientific ApplicationsOpal: Simple Web Services Wrappers for Scientific Applications
Opal: Simple Web Services Wrappers for Scientific Applications
 
Best practices for large oracle apps r12 implementations apps14
Best practices for large oracle apps r12 implementations apps14Best practices for large oracle apps r12 implementations apps14
Best practices for large oracle apps r12 implementations apps14
 
A sdn based application aware and network provisioning
A sdn based application aware and network provisioningA sdn based application aware and network provisioning
A sdn based application aware and network provisioning
 
An AMIS overview of database 12c
An AMIS overview of database 12cAn AMIS overview of database 12c
An AMIS overview of database 12c
 
An AMIS Overview of Oracle database 12c (12.1)
An AMIS Overview of Oracle database 12c (12.1)An AMIS Overview of Oracle database 12c (12.1)
An AMIS Overview of Oracle database 12c (12.1)
 
The Overview of Discovery and Reconciliation of LTE Network
The Overview of Discovery and Reconciliation of LTE NetworkThe Overview of Discovery and Reconciliation of LTE Network
The Overview of Discovery and Reconciliation of LTE Network
 
Sqlnet
SqlnetSqlnet
Sqlnet
 
Whats new in Oracle Database 12c release 12.1.0.2
Whats new in Oracle Database 12c release 12.1.0.2Whats new in Oracle Database 12c release 12.1.0.2
Whats new in Oracle Database 12c release 12.1.0.2
 
First in Class: Optimizing the Data Lake for Tighter Integration
First in Class: Optimizing the Data Lake for Tighter IntegrationFirst in Class: Optimizing the Data Lake for Tighter Integration
First in Class: Optimizing the Data Lake for Tighter Integration
 
System Architecture Exploration Training Class
System Architecture Exploration Training ClassSystem Architecture Exploration Training Class
System Architecture Exploration Training Class
 
Creating a Centralized Consumer Profile Management Service with WebSphere Dat...
Creating a Centralized Consumer Profile Management Service with WebSphere Dat...Creating a Centralized Consumer Profile Management Service with WebSphere Dat...
Creating a Centralized Consumer Profile Management Service with WebSphere Dat...
 
Distributed Clouds and Software Defined Networking
Distributed Clouds and Software Defined NetworkingDistributed Clouds and Software Defined Networking
Distributed Clouds and Software Defined Networking
 
Best Practices Using RTI Connext DDS
Best Practices Using RTI Connext DDSBest Practices Using RTI Connext DDS
Best Practices Using RTI Connext DDS
 
C19013010 the tutorial to build shared ai services session 2
C19013010 the tutorial to build shared ai services session 2C19013010 the tutorial to build shared ai services session 2
C19013010 the tutorial to build shared ai services session 2
 
Kafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC Federal
Kafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC FederalKafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC Federal
Kafka Migration for Satellite Event Streaming Data | Eric Velte, ASRC Federal
 
MOHAMMED VIKHAR AHMED
MOHAMMED VIKHAR AHMEDMOHAMMED VIKHAR AHMED
MOHAMMED VIKHAR AHMED
 
5G-USA-Telemetry
5G-USA-Telemetry5G-USA-Telemetry
5G-USA-Telemetry
 
EC8551 COMMUNICATION NETWORKS
EC8551 COMMUNICATION NETWORKSEC8551 COMMUNICATION NETWORKS
EC8551 COMMUNICATION NETWORKS
 
Grid optical network service architecture for data intensive applications
Grid optical network service architecture for data intensive applicationsGrid optical network service architecture for data intensive applications
Grid optical network service architecture for data intensive applications
 
Database As A Service: OEM + ODA (OOW 15 Presentation)
Database As A Service: OEM + ODA (OOW 15 Presentation)Database As A Service: OEM + ODA (OOW 15 Presentation)
Database As A Service: OEM + ODA (OOW 15 Presentation)
 

Recently uploaded

Mutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented ChatbotsMutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented Chatbots
Pablo Gómez Abajo
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
UiPathCommunity
 
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
anilsa9823
 
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
dipikamodels1
 
An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
Safe Software
 
Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0
Neeraj Kumar Singh
 
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
manji sharman06
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
Knoldus Inc.
 
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDBScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB
 
Automation Student Developers Session 3: Introduction to UI Automation
Automation Student Developers Session 3: Introduction to UI AutomationAutomation Student Developers Session 3: Introduction to UI Automation
Automation Student Developers Session 3: Introduction to UI Automation
UiPathCommunity
 
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
leebarnesutopia
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
 
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State StoreElasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
ScyllaDB
 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
Tobias Schneck
 
intra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_Enintra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_En
NTTDATA INTRAMART
 
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to SuccessDynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
 
Multivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back againMultivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back again
Kieran Kunhya
 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
Enterprise Knowledge
 
ScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking ReplicationScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking Replication
ScyllaDB
 
ScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDCScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDC
ScyllaDB
 

Recently uploaded (20)

Mutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented ChatbotsMutation Testing for Task-Oriented Chatbots
Mutation Testing for Task-Oriented Chatbots
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
 
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
 
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
Call Girls Kochi 💯Call Us 🔝 7426014248 🔝 Independent Kochi Escorts Service Av...
 
An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
 
Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0Chapter 5 - Managing Test Activities V4.0
Chapter 5 - Managing Test Activities V4.0
 
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
 
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDBScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
 
Automation Student Developers Session 3: Introduction to UI Automation
Automation Student Developers Session 3: Introduction to UI AutomationAutomation Student Developers Session 3: Introduction to UI Automation
Automation Student Developers Session 3: Introduction to UI Automation
 
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
 
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State StoreElasticity vs. State? Exploring Kafka Streams Cassandra State Store
Elasticity vs. State? Exploring Kafka Streams Cassandra State Store
 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
 
intra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_Enintra-mart Accel series 2024 Spring updates_En
intra-mart Accel series 2024 Spring updates_En
 
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to SuccessDynamoDB to ScyllaDB: Technical Comparison and the Path to Success
DynamoDB to ScyllaDB: Technical Comparison and the Path to Success
 
Multivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back againMultivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back again
 
Demystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through StorytellingDemystifying Knowledge Management through Storytelling
Demystifying Knowledge Management through Storytelling
 
ScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking ReplicationScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking Replication
 
ScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDCScyllaDB Real-Time Event Processing with CDC
ScyllaDB Real-Time Event Processing with CDC
 

Railway booking & management system

  • 1. RAILWAYS RESV & MGMT SYSTEM A PROJECT ON ORACLE 11G
  • 2. PROJECT PROFILE • RAILWAY BOOKING & MGMT SYSTEMPROJECT TITLE • 1 MONTHPROJECT DURATION • MOHOSIN SIRPROJECT GUIDE • CONSOLE PVT LTDSUBMITTED TO • 6 MEMBERSTEAM STRENGTH
  • 3. TEAM MEMBERS ASHUTOSH KUMAR JAYANT KUMAR MAYANK MRINAL NIKHIL RAJ RAHUL SHARMA PRAVEEN KUMAR JHA
  • 4. AGENDA Introduction Scope and feasibility Technical Details System Requirements Introduction to Oracle Terminology Oracle on Network
  • 5. AGENDA DFD Level 0 DFD Level 1 DFD Level 2 : Train Enquiry DFD Level 2 : Ticket Resv & Payment DFD Level 2 : Ticket Cancel & Refund ER Diagram Conclusion
  • 6. INTRODUCTION • Explains online railway reservation system of Indian Railways, from scratch. • Need of such system arose from the fact that India has 2nd largest rail network in the world. • To overcome many limitations, more efficient, easy handling of data and records . • Consumer satisfaction.
  • 7. SCOPE AND FESIBILITY • Implementations of this project idea are in industrial use in the form of ‘www.irctc.co.in’. • Hence, this can be used for suggesting improvements in design, performance and greater usability. • Apart from the industrial applications, it is a research oriented project as well, the task of performance evaluation of different database designs, for efficiency, is in this spirit.
  • 8. TECHNICAL DETAILS BACKEND DATABASE ORACLE 11 G OS PLATFORM WINOWS 7 OTHER PLATFORM RED HAT LINUX ENTERPRISE EDITION 5 SOFTWARES CHROME SCREEN CASTER TEXT PAD
  • 9. SYSTEM REQUIREMENTS Oracle binary installation requires : • MEMORY REQUIREMENTS • DISK SPACE REQUIREMENTS : • PROCESSER REQUIREMENTS : Intel core processors (32 bit or 64 bit) Available RAM SWAP Space Requirement Between 1 GB and 2 GB 1.5 times the size of the RAM Between 2 GB and 16 GB Equal to the size of the RAM More than 16 GB 16 GB Installation Type Minimum Requirement for Software Files (GB) Enterprise Edition 4.35 Standard Edition 4.22
  • 10. INTRODUCTION TO ORACLE Oracle Binary Installation Refers to installation of binary executable i.e full server software that supports : – Configuring listener – Creating customized databases – Configuring & monitoring tablespace – Create users , grant or revoke permissions from the user – and lots more…. 
  • 11. Terminology • Organized collection of data in digital form. • In such a way that a computer program can quickly select desired pieces of dataDATABASE • Used to optimize performance. • Provides a layer of abstraction between physical and logical data • Storage location where the actual data underlying database objects are kept. TABLESPACE • Model of vertical columns and horizontal rows, the intersection is called cell • Stores logically related data in the se cells TABLES
  • 12. ORACLE ON NETWORK How Oracle connects over a network? – Listener : An OS object through which database can be connected in a network – TNSListener , is a Oracle listener which by default listens on port no 1521 – It can be configured using listener.ora file located at C:app<user>product11.1.0db_1NETWORKADMIN – Stores the server name, port no and database name. – If it receives any request from the network , it checks the parameter file , listener.ora whether the database is available or not . if available it will help to create a session for the request.
  • 16. TICKET RESV & PAYMENT
  • 17. TICKET CANCEL & REFUND
  • 21. 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 learnt so far in different subjects. • This summer training helped us learn a lot. In this training we did the project on 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.
  翻译: