Creating a trading stock portfolio in Neo4j

Neo4j Graph Platform Modeling
1

Hi everyone,
I am a newbie in Neo4j and trying to learn Neo4j by converting a relational database into a neo4j model.

SQwTR
SQwTR2518×1294 202 KB

I am confused when a table is a node or a relation.

So far I have nodes for

  1. Trader
  2. Country
  3. Currency
  4. Item (Stock, Currency, or fund)
  5. Price(? should this be relation)
  6. Offer(Should trade or offer to be a relation)
  7. Rate (Currency conversion rate)

Relations

  1. CURRENCY_USED
  2. ITEM_PRICE
  3. ITEM_CURRENCY
  4. TRADER_COUNTRY
  5. TRADER_CURRENCY
  6. TRADE

Report and CurrentInventory, no clue whether they belong to either node or relation.

    CREATE (USA:Country)
    CREATE (India:Country)
    
    CREATE (USD:Currency {code: "USD", name: "Dollar", is_active: true, is_base_currency: true})
    CREATE (INR:Currency {code: "INR", name: "Rupee", is_active: true, is_base_currency: true})
    
    CREATE (USD) -[:CURRENCY_USED {date_from: "", date_to: ""}]-> (USA)
    CREATE (INR) -[:CURRENCY_USED {date_from: "", date_to: ""}]-> (India)
    
    CREATE (INR:CurrencyRate {code: "INR", name: "Rupee", is_active: true, is_base_currency: true})
    CREATE (INR:CurrencyRate {code: "INR", name: "Rupee", is_active: true, is_base_currency: true})
    
    CREATE (Tesla:Item {code: "TSLA", name: "Tesla", is_active: true })
    CREATE (TeslaPrice:Price {buy: 400, sell: 399, timestamp: datetime()})
    
    CREATE (Tesla) -[:ITEM_PRICE]-> (TeslaPrice)
    
    CREATE (TeslaPrice) -[:ITEM_CURRENCY]-> (USD)
    
    CREATE (Adam:Trader {first_name: "Adam", last_name: "West", user_name: "adam",  password: "12345"})
    
    CREATE (Adam) -[:TRADER_COUNTRY]-> (USA)
    CREATE (Adam) -[:TRADER_CURRENCY]-> (USD)
    
    CREATE (AdamPortfolio:Portfolio {quantity: 10})
    CREATE (AdamPortfolio:Portfolio) -[:PORTFOLIO_ITEM]-> (Tesla)
    CREATE (AdamPortfolio:Portfolio) -[:TRADER_PORTFOLIO]-> (Adam)
    CREATE (AdamBuyTesla:Trade {qunatity: 10, unit_price: 400})
    CREATE (AdamBuyTeslaOffer:Offer {qunatity: 10, unit_price: 400, buy: true, sell: false, timestamp: datetime()})
    
    CREATE (AdamBuyTesla) -[:TRADE_OFFER]-> (AdamBuyTeslaOffer)