Designing Databases

[ChrisBat]

Hi,

Does anybody know what the different types of Databases
that you can design in Visio Pro are? The list includes
types like Crowfoot, Bachman, IDEF1X, Object Role
Modeling, Chen ERD, Express-G, and Martin ERD. I'm
looking for documentation or anything else that may help.
THanks,
Chris

 

[Rob]

I'm thinking you are dealing with an apples and oranges
issue here. Visio isn't a database tool per se, it is a
design and/or documentation tool.

The items you listed are means of displaying the layout of
a database, to get a "big picture" understanding of the
database structure. An Entity Relationship Diagram is
kind of like a map of your database design, and just like
there are different kinds of maps, there are different
kinds of ERD's and different flavors of Unified Modeling
Languages.

What database product you actually use (Oracle, SQLServer,
MySQL, Access, or whatever) isn't relevant to the issue of
what the database is shaped like. A lot of database
modeling tools will let you map out the database and then
give you automation tools to create you table structure
for the database product of your choice.

So, you can design any kind of database with Visio. The
options you listed let you pick the language used to
describe the database. With which database products Visio
can perform automated table creation is an entirely
separate matter.

Am I way off base, or was this what you were looking for?

Rob