A distributed railway reservation system stores the following information
(The following description may lead to un-normalized relations,normalize them wherever required)

Train Description :-
   includes Train number,Station from which the train originate and pass,
   Time of departure and arrival at various destinations,
   Number of seats available,Number of seats reserved etc.

Passenger description :-
  includes Passenger code,Name,Address,ph_no,etc.

Reservation description :-
  includes Passenger code,Train number,Seat reserved etc.

Assume that only following two application exist.

(a) A request about reservation availability :-
    All information about trains from a given source
    to destination is to be displayed on the user terminal.

(b) A reservation request is to be fulfilled which includes:-
    1. whether the passenger's data is already available.
       If not insert passenger data

2. Checking the availability of seats

3.Inserting the reservation description.