title: Database design of Railway reservation system
body: <p>I am designing Railway reservation system.
  I am having below tables.</p>
  
  <pre><code>StationTable(Contails all the stations to which i can provide the railway service.)
  &lt;StationID&gt;-&gt;PrimaryKey
  &lt;StationName&gt;
  
  TrainTable
  &lt;TrainNumber&gt;-&gt; PrimaryKey
  &lt;TrainName&gt;
  &lt;SourceStationID&gt;-&gt;FK StationTable(&lt;StationID&gt;)
  &lt;DestinationStationID&gt;-&gt;FK StationTable(&lt;StationID&gt;)
  </code></pre>
  
  <p>Passenger is identified by TicketID</p>
  
  <pre><code>   PassengerTable
      &lt;TicketID&gt;-&gt;Primary key
      &lt;PassengerID&gt;
      &lt;PassengerName&gt;
      &lt;Age&gt;
      &lt;Sex&gt;
      &lt;Status&gt;
  </code></pre>
  
  <p>As one passenger can book ticket for many trains. Their is many to many relation between TicketID and TrainID.</p>
  
  <p>PassengerTrainTable
  -> FK  PassengerTable()
  -> FK TrainTable()</p>
  
  <p>I am unable to relate to No of seats in a train and the status.
  How can i relate those in relation with current table or how can i go with new tables.</p>