Term Paper of Database Management System

Only available on StudyMode
  • Download(s) : 322
  • Published : October 2, 2011
Open Document
Text Preview
TERM PAPER

OF

DATABASE MANAGEMENT SYSTEM

Topic: Railway reservation system for Indian railways

Submitted To:- Submitted By:-

Mr. Dinesh Kumar Rohit Kapoor

B.Tech CSE

Section- C1701

Roll No.-41

Regd. No.-1050070080

TABLE OF CONTENTS:

1. INTRODUCTION

2. ABOUT THE DATABASE

3. PHYSICAL DATA MODEL FOR RAILWAY RESERVATION

4. E-R DIAGRAM

5. CREATION OF THE DATABASE

1. TRAIN_INFO

2. STATION_INFO

3. TRAIN_SCHEDULE

4. TRAIN_SEATS

5. RESERVATION

6. PASSENGER

6. INSERTION OF THE VALUES INTO THE DATABASE

1. TRAIN_INFO

2. STATION_INFO

3. TRAIN_SEATS

4. STATION_SCHEDULE

5. RESERVATION

6. PASSENGER

7. ACKNOWLEDGEMENT

8. REFERENCES

1. INTRODUCTION

This concept is basically about the reserving railway tickets for passengers. This method can be used as an online method for reserving tickets as well as canceling of reserved tickets. This system maintains whole of the database in an efficient way as it uses SQL database. This is permanent data storage method and chances of data loss are only if the database crashes. This system is meant for use by Indian Railways for handling reservations only. The system must cater to all passenger services provided by Indian Railways and must minimally provide support for reservation of different classes of seats/berths, onward journeys, wait-listed tickets and RAC tickets. Providing support for reservation will also require that the system records information of the various trains running on various routes as well as information about the routes themselves.

2. ABOUT THE DATABASE

The database already contains the information about the trains. So when the passenger comes for reservation, he directly sees this for enquiry.

• Trains Database
❖ Train Number
❖ Train Name
❖ Start station
❖ Destination Station

This database table contains all the necessary information about the station from where the train starts and where the train ends.

• Station database
❖ Station Id
❖ Station Name
❖ Station type
❖ Station description

The number of seats available in a particular train are stored in the following table:

• Train Seats
❖ Train Number
❖ Seat number

The Train schedule contains the daily routine about the train i.e. the time at which the train starts from the station and the time at which it leaves from the station.

• Train Schedule
❖ Train Number
❖ Station Id
❖ Arrival Time
❖ Departure Time

All the reservation details about the passenger are stored in Reservation table. The information which the passengers fill while entering data for reservation are stored in it.

• Reservation
❖ Reservation Id
❖ Passenger Id
❖ Date of journey
❖ Reservation date
❖ Boarding from
❖ Boarding to

All the information about the passenger who registers himself for reservation is stored in the Passenger Table. Each passenger is given a unique Id and seat number is allotted to him at the time of reservation. No two passengers can have same seat number or passenger id.

• Passenger
❖ Passenger Id
❖ Passenger Name
❖ Address
❖ Phone Number
❖ Gender

All these Database tables are joined together with the help of keys i.e. primary key or...
tracking img