Dussehra

⬡A four-hop traversal. The trailing variable-length step is what lets “Chennai” match a florist registered in T. Nagar without you having to know that.Occasion → NEEDS → Product → AVAILABLE_AT → Florist → LOCATED_IN → Location → PART_OF*0..3

• 🍃

  Banana LeavesEssential6 pieces

  Indiranagar Blooms· Indiranagar · ₹14 / piece · Next day9 shops

  ₹81

  for 6 pieces
• 🌾

  AkshataEssential1 packet

  Gandhipuram Pooja Stores· Gandhipuram · ₹26 / packet · Next day3 shops

  ₹26

  for 1 packet
• 🔴

  KumkumEssential1 packet

  Adyar Pooja Mart· Adyar · ₹35 / packet · Next day3 shops

  ₹35

  for 1 packet
• 🟡

  Turmeric PowderEssential1 packet

  Matunga Pooja Bhandar· Matunga · ₹41 / packet · Next day2 shops

  ₹41

  for 1 packet
• 🥥

  CoconutEssential2 pieces

  Matunga Pooja Bhandar· Matunga · ₹42 / piece · Next day2 shops

  ₹85

  for 2 pieces
• 🔥

  CamphorEssential1 packet

  Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day

  ₹101

  for 1 packet
• 🌼

  Marigold (Loose)Essential1 kg

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

  Madurai Mala Kadai· Meenakshi Nagar · ₹106 / kg · Next day12 shops

  ₹106

  for 1 kg
• 🍃

  Betel Leaves & NutsRecommended2 sets

  Dadar Phool Galli· Dadar · ₹34 / set · Next day12 shops

  ₹69

  for 2 sets
• 🟫

  JaggeryRecommended0.5 kg

  Malleshwaram Pooja Samagri· Malleshwaram · ₹85 / kg · Next day3 shops

  ₹85

  for 0.5 kg
• 📿

  God Garland (Small)Recommended1 piece

  Madurai Mala Kadai· Meenakshi Nagar · ₹129 / piece · Same day5 shops

  ₹129

  for 1 piece
• 🖼️

  Photo Frame GarlandOptional1 piece

  Jayanagar Hoovina Angadi· Jayanagar · ₹158 / piece · Same day9 shops

  ₹158

  for 1 piece

⬡Traverse out to every vendor, then aggregate back per vendor while remembering which items were never covered. In SQL this needs a four-table join, a GROUP BY, and a correlated NOT EXISTS per checklist item.aggregate back over the traversal

⬡The quantity, the unit, the importance and the note all live on the NEEDS relationship — not on the flower and not on the occasion. That is the clearest single argument for modelling this as a graph.Occasion → NEEDS → Product → BELONGS_TO → Category

⬡Three hops through the purchase history: what does this occasion need, who bought those things, and what else did those people buy.Occasion → NEEDS → Product ← BOOKS ← Customer → BOOKS → Product

⬡Occasions are sequenced in the graph, so the app can suggest buying once for two events instead of twice.Occasion → PRECEDES → Occasion