Re: database normalization

"corey lawson" <corey.lawson_at_worldnet.att.net> wrote in message news:38703A34.7F1EFF38_at_worldnet.att.net...
> I don't know for sure, but I think InfoModeler has been rolled into
> Visio 5 Enterprise. One of the things that InfoModeler lets you do is
> refresh and manipulate database schema from within it. Visio 5 Pro will
> only take a "snapshot" of a DB schema for you. Any changes you make to
> its database diagramming objects for table attributes don't get pushed
> back to the DB, but allegedly InfoModeler/V5E will do this...

Yes, VisioModeler (nee InfoModeler) has always been able to do this; quite well, in fact. Staring with version 5.0, Visio Enterprise can as well, although since it uses ER modeling, many of the constraints (and thus rules that could be generated by VisioModeler) get lost in the translation. BTW, VisioModeler is still a separate product but is sold along with VisioEnterprise 5.0.

VE also supports views and SP authoring, as well as the other features of Visio as a drawing tool (automation, layouts, etc.).

Visio has just released Visio Enterprise 6.0, which is a lot like VE 5.0 from an ER standpoint, but now has better support for ORM (VisioModeler's preferred notation) and a few other perks.

> I think other tools, like ERWin, Oracle Designer/2000, etc. do this, too
> (but none of them are all that cheap...), nor is Visio 5 Enterprise...

Compared to ER Win and D2K, VE is very cheap. Considering you get a UML tool, the network autolayout, and complete Visio drawing package, and VisioModeler (which used to sell for over 3 grand by itself) for a grand....

HTH,
Scot.

Principal Consultant, InConcept, Inc.

     http://www.inconcept.com

Editor, The Journal of Conceptual Modeling

     http://www.inconcept.com/JCM Received on Wed Jan 05 2000 - 00:00:00 CET