DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ERwin

  1. #1
    Join Date
    Feb 2003
    Location
    Mumbai, India
    Posts
    10

    ERwin

    Hi all,

    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.


    TX,
    Kiran

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Kiran

    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..

    regards
    Hrishy

  3. #3
    Join Date
    May 2003
    Posts
    1
    Kiran,

    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.


    Thanks
    sudhadba

  4. #4
    Join Date
    Feb 2003
    Location
    Mumbai, India
    Posts
    10
    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.

    REgards,

    Kiran

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width