Idea of this project was to track a complete production chain for organic products. A Flour bin could be built from several Grain bins, the Grain bin from several Storage bins, etc. After I read a project requirement document I immediately thought about a recursion. However, a database we received had set of tables for each bin with many-to-many relationships. I proposed to replace this chain with one recursive table, similar to this:

As result, I had to write one "Bin" COM instead of four and gave recommendations to web developers how to work with this object where I suggested to built one generic page. Also, this design helped building component for displaying history of a particular bin (tree).

The project was completed one+ month earlier with just few bugs. One of the change orders we received was to add one more bin between existing ones which we completed for two-three days.