title: DB Design regarding intersections
body: <p>Of these two designs for a crossroad database</p>
  
  <pre><code>#Street
  street_id | street_nm
  #Crossing
  crossing_id | x | y | street_id_1 | street_id_2
  </code></pre>
  
  <p>VS</p>
  
  <pre><code>#Street
  street_id | street_nm
  #Crossing
  crossing_id | x | y 
  #street crossing relationship
  street_id | crossing_id
  </code></pre>
  
  <p>Assuming every crossing has only exactly two roads, is there a reason why one would use the first solution over the first?</p>
  
  <p><strong>EDIT:</strong> For the second setup, how could I create a view where results look like this</p>
  
  <pre><code>crossing_id| x | y | street_nm_1 | street_nm_1
  </code></pre>
  
  <p>Also I'm not sure how creating a junction with three roads would effect the view.</p>