Red Rose
Sold in bunches of twenty stems. Used for garlands, petal offerings and stage work.
Where to buy
Every shop that carries it, cheapest in-stock first.
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
| Shop | Area | Rating | Price | Availability |
|---|---|---|---|---|
| Madurai Mala Kadai | Meenakshi Nagar | 4.6(288) | ₹81 | In stock · Next day |
| Kapali Flower Mart | Mylapore | 4.3(201) | ₹83 | In stock · 2 days |
| Dadar Phool Galli | Dadar | 4.7(891) | ₹85 | In stock · Next day |
| Dadar Mala Corner | Dadar | 4.3(224) | ₹92 | In stock · Next day |
| Kovai Poo Nilayam | R. S. Puram | 4.6(324) | ₹94 | In stock · Next day |
| Mysuru Hoo Mandi | Devaraja Mohalla | 4.6(267) | ₹94 | In stock · Next day |
| Jayanagar Hoovina Angadi | Jayanagar | 4.7(466) | ₹101 | In stock · Next day |
| Meenakshi Flower House | Meenakshi Nagar | 4.9(754) | ₹104 | In stock · Next day |
| Sri Kamakshi Flower Stall | T. Nagar | 4.7(412) | ₹77 | Out of stock |
8 of 9 shops have it in stock right now.
If you can't get it
Alternatives found by walking the substitution chain up to three hops.
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
Needed for
Every occasion that calls for this, and how much each one needs.
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)
- Wedding (Kalyanam)Essential10 bunches
- NavratriEssential3 bunches
- Varalakshmi VrathamEssential2 bunches
- Lakshmi PoojaRecommended1 bunch
- Raksha BandhanOptional1 bunch
How Red Rose connects to Wedding (Kalyanam)
The route the graph took, not just the fact that a route exists.
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
- Red Rose is needed by
- Wedding (Kalyanam)
1 hop through the graph