The situation is this. We’re using PVCS Tracker for tracking fixes and bugs, and this is based on an Oracle database. The database comprises several schemas, one for each project being tracked, and each schema contains many tables which are obviously dependent on one another for the Tracker application. However, when viewed through TOAD or a similar tool, no foreign key constraints are shown among the tables, which tells me that the relationships between the tables are being enforced by the procedural code within Tracker rather than by Oracle objects.
So, does anyone know of a tool which can analyze a database, and describe probable data relationships based on the data itself? For instance, if you have a pair of tables which appear to have a one-to-many relationship based on the attribute values, could the tool tell you that they probably are related, even though there’s no formal Oracle constraint?