Results 1 to 4 of 4

Thread: ER Modeling

  1. #1
    Join Date
    Mar 2006
    Posts
    20

    Question ER Modeling

    Hi All:

    Just wondering if someone could give some advice on UML modeling tools. I have looked into Visio, however it would appear that the relational database modeling templates are limited in that they don’t appear to have the links one-to-one and one-to-many! Is there a generic modeling tool, database designers use i.e. tool of preference or do most use Visio?

    Cheers

    Oliver

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    I like dbdesigner. It gets the job down now and the price is right.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    In Visio, set the Database | Options | Document | General | Symbol Set to IDE1FX instead of Relational. The change in Symbol Set will cause the diagram to show Cardinality (one, many, optional, etc) using IDE1FX notation. You can also set Database | Options | Document | Relationship | Show options to use either Crow's feet or explicit cardinality. Visio is good for simple schemas, and is a great tool for reverse engineering specific (very small) parts of a database for project specifications.

    I still prefer ErWin, especially for large or complex jobs.

    -PatP

  4. #4
    Join Date
    Mar 2006
    Posts
    20
    Hi:

    Many thanks for your rapid response and useful information.

    Oliver

Posting Permissions

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