Given a database with no defined foreign key constraints, analyzing schema information is essentially inferring relationships by static analysis. Another approach is looking at join operators within stored procedures or even cached sql execution plans.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho