title: Graph database creation using Neo4j - Airline example
body: <h3>I am trying to create a neo4j graph database from the below csv:</h3>
  <p><a href="https://i.stack.imgur.com/NcOV0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NcOV0.png" alt="enter image description here" /></a></p>
  <p>I am finding it hard to figure out the different nodes and relationships.</p>
  <p>I tried the below code but the database was not connected like it needs to be.</p>
  <pre><code>LOAD CSV WITH HEADERS FROM 'file:///dummy.csv' AS row
  MERGE (a: Airport {depatureId: row.Origin, arrivalId: row.Dest})
  MERGE (f: Flight {flightId: row.Flight_num, distance: row.Distance, Flightdate: row.Date, Flightdelay: row.Total_delay, Airline: row.Carrier_code})
  MERGE (a)-[r1:HAS_FLIGHT]-&gt;(f)
  MERGE (f)-[r2:FLYING_TO]-&gt;(a)
  </code></pre>
  <p>Another attempt</p>
  <pre><code>LOAD CSV WITH HEADERS FROM 'file:///dummy.csv' AS row
  MERGE (o: Origin {origin_airportId: row.Origin})
  MERGE (d: Destination {destination_airportId: row.Dest})
  MERGE (f: Flight {flightId: row.Flight_num, distance: row.Distance, Flightdate: row.Date, Flightdelay: row.Total_delay, Airline: row.Carrier_code})
  MERGE (o)-[r1:FLYING_FROM]-&gt;(f)
  MERGE (f)-[r2:FLYING_TO]-&gt;(d)
  </code></pre>
  <p>Any ideas or suggestions would be much appreciated, thanks.</p>