Marigold (Loose)

⬡Price, stock and lead time are properties of the AVAILABLE_AT relationship — the same product costs different amounts at different shops, and that fact belongs to the pairing.Product → AVAILABLE_AT → Florist → LOCATED_IN → Location

12 of 12 shops have it in stock right now.

⬡Closeness is multiplied along the chain, so a substitute reached in two hops automatically scores lower than a direct one — no rule had to say so.Product → SUBSTITUTE_FOR*1..3 → Product

⬡Exactly the same relationship as the checklist, traversed in the other direction and at the same cost. A relational schema would need a second index for this.Occasion → NEEDS → Product (read backwards)

• DiwaliEssential
  3 kg

  Prices roughly double in the week before Diwali. Order early.

• Ganesh ChaturthiEssential
  2 kg
• Wedding (Kalyanam)Essential
  15 kg

  Toranas, aisle borders and the mandap surround.

• NavratriEssential
  2 kg

  Refreshed every second day across the nine.

• DussehraEssential
  1 kg

  Tools, books and instruments are garlanded before being taken up again.

• OnamEssential
  5 kg

  The pookalam is laid fresh each of the ten mornings and grows daily.

• New Vehicle PoojaEssential
  0.5 kg
• Daily PoojaRecommended
  0.25 kg
• PongalRecommended
  1 kg
• Karthigai DeepamRecommended
  1 kg

⬡This is the query with no relational equivalent. A join returns rows; the joins that connected them are gone by the time the result exists. Only a graph can hand back the path itself.shortestPath, up to 6 hops