how to find out realtions between tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to find out realtions between tables

  1. #1
    Join Date
    Feb 2001
    Location
    Baltimore,MD USA
    Posts
    27

    Cool

    hello DBA friends,
    I have one problem realted to Reversal Database modelling.

    My database is on oracle 7.2 on NT . One application in forms 4.5 is already there and I want to make changes in that.

    For this I don' have a realtional database model or any other documentation realted to design of that db.
    I also don't know how tables are related to each other ?

    I want to find which tables are master tables and/or child tables.I have to make database modelling to be presice.
    And to build up relational-model.

    I have total 345 tables.

    One way to do it is check constraints for all the tables using
    user_constraints and user_cons_columns view.But it is lengthy.

    r there any easy steps in thissolution ? or Is there any other way to do this ?

    Thanks

    kuckoo

  2. #2
    Join Date
    Jan 2001
    Posts
    61

    Thumbs up

    You can use Designer2000 tool to generate the ER Diagram or other small exercise is use SQLServer.Just import all your objects using ODBC Link and let SQLServer built the diagram for you....

  3. #3
    Join Date
    Dec 2000
    Location
    Washington DC
    Posts
    42

    Data Modeling Tool

    Kookoo

    There is a simple solution to this. Look into a tool called ERWin. This tool has a feature which allows you to reverse engineer a number of different databases into a physical picture that will allow you to see the inter-relationships between all of your tables.

    Ken
    Ken Hinerman
    Data Interaction
    DBASupport@datainteraction.com

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Well any CASE tools does what you want, itīs the minimum feature for a CASE tool

    If you want to use trial products you could use Embarcadero ER Studio, ErWin
    If you want o use a *free* one and powerful Oracle Designer, FREE if you dont use it for commercial use and because it does NOT expire

  5. #5
    Join Date
    Feb 2001
    Posts
    51

    what's the different?

    I'm thinking about taking a developer course next semester.

    what is the different between the designer and developer2k?

    are they the same thing?


    thanks

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Desiger is Data modelling tool to design the application.
    Developer is a forms and reports based front end user interface.
    Reddy,Sam

  7. #7
    Join Date
    Sep 2000
    Posts
    362
    I have Oracle Designer Case Dictionary CD and also 2 CD's for Oracle Designer release 6 one of them is a pre configured repository. What is the mail difference between release 6 ,pre configured repository and cas dictionary.

    Also how does oracle designer perform viz a viz other tools available. I have used ER Studio and it seems to be a decent tool.

    Thanks
    Anurag

    [Edited by anuragmin on 03-27-2001 at 11:46 AM]

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