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

I like dbdesigner. It gets the job down now and the price is right.

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

Hi:

Many thanks for your rapid response and useful information.

Oliver