Seemantham (Baby Shower)
Held in the seventh or ninth month. Bangles, a floral swing and a great deal of jasmine.
Where to buy each item
Every item on the list, resolved to a shop that has it in stock.
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
- ₹26for 1 packet
- ₹206for 6 sets
- ₹35for 1 packet
- ₹41for 1 packet
- ₹85for 2 pieces
- ₹206for 4 mozham
- ₹126for 2 dozen
The single largest jasmine requirement outside a wedding.
₹589for 8 mozham- ₹334for 4 bunches
- ₹314for 1 packet
The floral swing is the centrepiece; confirm ceiling fixings with the decorator.
₹8,730for 1 service- ₹158for 1 piece
Fewest stops
Which single shop covers the most of this list — because visiting four shops on a festival morning is not realistic.
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
Still needed elsewhere: Pink Rose, Jasmine (Malli), Jasmine Strand, Photo Frame Garland +1 more
Still needed elsewhere: Kumkum, Turmeric Powder, Coconut, Bananas +3 more
Still needed elsewhere: Kumkum, Turmeric Powder, Coconut, Bananas +3 more
Still needed elsewhere: Pink Rose, Jasmine (Malli), Jasmine Strand, Photo Frame Garland +3 more
Still needed elsewhere: Photo Frame Garland, Kumkum, Turmeric Powder, Coconut +4 more
Still needed elsewhere: Jasmine (Malli), Kumkum, Turmeric Powder, Coconut +4 more
The full checklist
Grouped by category, essentials first. Quantities and notes come from the relationship between this occasion and each item.
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
Loose Flowers(1)
- Pink RoseEssential4 bunches₹380est.
Occasion Garlands(2)
- ₹640est.
- Photo Frame GarlandOptional1 piece₹180est.
Offerings & Prasad(5)
- Betel Leaves & NutsEssential6 sets₹240est.
- CoconutEssential2 pieces₹90est.
- BananasEssential2 dozen₹140est.
- AkshataEssential1 packet₹30est.
- Dry FruitsRecommended1 packet₹320est.
Sacred Powders(2)
- KumkumEssential1 packet₹40est.
- Turmeric PowderEssential1 packet₹45est.
Seasonal Flowers(1)
- Jasmine (Malli)Essential4 mozham₹240est.
Home Decoration(1)
- Baby Shower DecorationRecommended1 service
The floral swing is the centrepiece; confirm ceiling fixings with the decorator.
₹16,000est.
Others also bought
Discovered from real purchase history, not from anything an editor curated.
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
Camphor
Bought by 22 people who also picked up Pink Rose and Jasmine (Malli)
Agarbathi
Bought by 21 people who also picked up Pink Rose and Jasmine (Malli)
Cotton Wicks
Bought by 21 people who also picked up Pink Rose and Jasmine (Malli)
Jaggery
Bought by 21 people who also picked up Pink Rose and Jasmine (Malli)
Banana Leaves
Bought by 19 people who also picked up Pink Rose and Jasmine (Malli)
Rangoli Powder
Bought by 19 people who also picked up Pink Rose and Jasmine (Malli)
Mango Leaves
Bought by 18 people who also picked up Pink Rose and Jasmine (Malli)
Marigold (Loose)
Bought by 17 people who also picked up Pink Rose and Jasmine (Malli)
Coming up next
What this occasion usually precedes — worth buying for at the same time.
Occasions are sequenced in the graph, so the app can suggest buying once for two events instead of twice.Occasion → PRECEDES → Occasion