title: How do I design a bus route database?
body: <p>I want to create a bus route DB in such a way that it gives the result as follows :</p>
  
  <p><strong>Input :</strong>
       Source = station-X    ,           Destination = station-Y</p>
  
  <p><strong>Output :</strong> Various bus name/nos. which go through Station-X and Station-Y</p>
  
  <p>So far i have :
  <strong>Bus</strong>(bus_no), <strong>Bus_Route</strong>()</p>
  
  <pre><code>    Bus(bus_name/no.)
  id   |   bus_no
  1    |   33
  2    |   33A
  
    Bus_Route(route_id,bus_no)
  id   |   route_id  |  bus_no
  1    |   route-A   |   33
  2    |   route-B   |   33A
  </code></pre>
  
  <p>How do i proceed to store the station names of the respective routes.
  I am no database expert, so any help would be valuable .
  Thanks in advance.</p>