Automated Data Modeling Tools



I am in search of a tool that identifies relationship between the data. A small example would be…if given 2 tables in a db as input, this tool should be able to parse the data and tell me how these 2 tables are linked. It could be master detail or fact dimension. We are trying to find if we can create automated data models on the fly when given a set of tables as input.thank you in advance

Sajeed kazi