Nodes and Relationships

Introduction

You are going to extend your graph data model to including customer’s order.

You task is to:

Create Order nodes.
Connect Customer nodes to Order nodes with a PURCHASED relationship.
Run the import and view the results.

mermaid

Customer PURCHASED Order

graph TD
    Customer -->|PURCHASED| Order
    
    Order(("<b>Order</b>"))
    
    Customer(("<b>Customer</b>"))

Continue with the lesson to add Order nodes and PURCHASED relationships

Order nodes

Create the Order nodes:

Create a new Node label - Order
Add the Order as the Label
Select orders.csv as the Table
Use the Map from table function to create the properties:
Select all the columns, except the customerId and employeeId.

When you confirm the mapping, the properties, their data types, and column will be automatically mapped.
The orderId property should be selected as the unique ID.
Run the import to create the Order nodes.

View the orders in the graph:

cypher

Order nodes

MATCH (o:Order)
RETURN o
LIMIT 100

PURCHASED

You can now create the (Customer)-[:PURCHASED]→(Order) relationship.

Drag a relationship from the Customer node to the Order node.
Set the Relationship Type to PURCHASED
Select orders.csv as the Table
The Node ID mapping tells Import how to connect the nodes.
- Select customerID from the the Customer node
- Select orderID from the Order node
Run the import

Need a working solution?

To update the graph data model with the solution, you can:

Open Query and delete all the data from your instance:
cypher
```
MATCH (n) DETACH DELETE n
```
Download the Customer-PURCHASED-Order data model - northwind-customer-order.zip.
Use the … menu, select Open Model (with data), and select the northwind-customer-order.zip file you downloaded.
Run the import.

View customers and their orders

When you have added the Order nodes and PURCHASED relationships you can view the customer’s orders:

cypher

Customer orders

MATCH (c:Customer)-[p:PURCHASED]->(o:Order)
RETURN c,p,o
LIMIT 100

Result of the query showing customers, their purchased relationships and the orders

Products

Your task is to add the Product nodes and ORDERS relationship to Order nodes.

mermaid

Order ORDERS Product

graph TD
    Order -->|ORDERS<br/>unitPrice<br/>quantity<br/>discount| Product
        
    Product(("<b>Product</b>"))    

    Order(("<b>Order</b>"))

To include the product nodes you will need to:

Add a new Product node label importing from products.csv
Map the properties from the table
Set the productId as the unique ID.

To create the relationship from Order to Product:

Drag a new relationship from Order to Product with type ORDERS
Use order-details.csv as the source table.
Use the orderID and productID for the node ID mapping.
Map the unitPrice, quantity and discount as relationship properties.

Need a working solution?

To update the graph data model with the solution, you can:

Open Query and delete all the data from your instance:
cypher
```
MATCH (n) DETACH DELETE n
```
Download the Customer-Order-Product data model - northwind-customer-order-product.zip.
Use the … menu, select Open Model (with data), and select the northwind-customer-order-product.zip file you downloaded.
Run the import.

View customers, their orders, and products

View the customer’s purchased orders:

cypher

Customer orders

MATCH (c:Customer)-[p:PURCHASED]->(o:Order)-[or:ORDERS]->(pr:Product)
RETURN c,p,o,or,pr
LIMIT 100

Result of the query showing customers, their purchased relationships, the orders and products

Lesson Summary

In this lesson, you learned extend your graph data model by adding new nodes and relationships

In the next challenge, you will review the data set, identify new nodes and relationships and add them to the graph.

Zero to Production Hands-On Workshop

Graph Databases

Get Neo4j

Importing Data

Access your data

Nodes and Relationships

Introduction

Order nodes

PURCHASED

View customers and their orders

Products

View customers, their orders, and products

Lesson Summary

Chatbot

Data Model