Im doing a reverse engineering for an existing DB. Im using ERwin 4.0.
I need to analyze the DB and find out the relations for the tables (the relationships were not created initally).
Currently Im taking a print of one schema from ERwin & by looking at each table, Im trying to find out the relations (new to be created). I think my approach is highly time consuming and probably is not the best.
I highly appreciate any help in this regard.
You should look at wheather the Tables are normalised at all..Ask for the design specification..take up each table at a time and find out wheather they are normalised..There is no other way..if there are no foreign keys.you will have to take each table at a time and do it..
Try it the option of subject area in the left side tool box.
Expand Subject area
select the individual Subject area Right click go
you can find individual subject area and you can find out the relationships.
Dear Hrishy and sudhadba, TX for ur replies.
The tables r normalised and the application was operational previously.
I dont have access to application/DB design specification.
The prb is while extracting tables from DB into ERwin, even if I say "infer" PK's and relationships, this wont happen. I think this is bcoz among the hundreds of tables, less than 10 PK/FK were defined.
I need to identify relationships based on common columns/data, & suggest for any changes in DB structure. Instead of doing thru paper work by looking individually at tables, can anybody suggest the better/faster way.
Click Here to Expand Forum to Full Width