×
When you want to succeed as bad as you want to breathe, then you’ll be successful.
--Your friends at LectureNotes
Close

railway reservation system

  • Project Report
  • 1110 Views
  • 2 Offline Downloads
  • Uploaded 7 months ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

Database Management Systems Academic Year 2019-2020 Project based on ON RAILWAY RESERVATION SYSTEM Submitted to- Mr. Jay Sarraf Submitted by Student Roll no. Student Name 1705883 Rupam Bose 1705918 KM Sakshi Verma 1705929 Priya 1705942 Raied Razi Group-14

Text from page-2

CONTENTS Objective......................................................................................................................................... 3 Introduction....................................................................................................................................4 List of Entities & Attributes...........................................................................................................5 ER Diagram (Conceptual Model)................................................................................................ ..7 List of Realtional Schema............................................................................................................... ..8 Create & Insert SQL Queries.........................................................................................................9 SQL Queries related to Report Generation.................................................................................. .17 Conclusion.....................................................................................................................................21 Contribution...................................................................................................................................22 Bibliography....................................................................................................................................23 Group-14

Text from page-3

OBJECTIVE The Railway Reservation System facilitates the passengers to enquire about the trains available on the basis of source and destination, Booking and Cancellation of tickets, enquire about the status of the booked ticket, etc. The aim of case study is to design and develop a database maintaining the records of different trains, train status, and passengers. This project contains Introduction to the Railways reservation system .It is the computerized system of reserving the seats of train seats in advanced. It is mainly used for long route. On-line reservation has made the process for the reservation of seats very much easier than ever before. In our country India, there are number of counters for the reservation of the seats and one can easily make reservations and get tickets. Then this project contains entity relationship model diagram based on railway reservation system and introduction to relation model .There is also design of the database of the railway reservation system based on relation model. Example of some SQL queries to retrieves data from rail management database. Group-14

Text from page-4

Group-14

Lecture Notes