Re: OT: Entity Relationship

[Frank Caruso]

** Not sure if this is applicable to all databases - familiar with SQL server, Oracle and Sybase - but since Remedy does not incorporate referential integrity in their tables most modeling tools are just going to bring back a whole bunch of tables scattered around a screen. I believe you would still have to do the leg work and relate each.

You did not mention whether you are trying to model the proprietary Remedy tables or ones from your custom application but the Remedy core tables are diagrammed out pretty well in the user docs - I believe it is the Database Reference Guide.

On 7/19/06, Kelly Heikkila <[EMAIL PROTECTED]> wrote:

DBDesigner4 from FabForce (open source) is great if you want to create a new ER diagram from scratch.  It was designed for MySQL, but the diagrams are appropriate for any DB.  However, if you are looking to model (auto-created)an existing DB, this may not be the tool.

More info:
http://www.fabforce.net/dbdesigner4/

Kelly Heikkila
Kinetic Data, Inc.



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]
Sent: Wednesday, July 19, 2006 8:28 AM
To: arslist@ARSLIST.ORG
Cc: T. Dee
Subject: OT: Entity Relationship


We are looking for a software package that can build an Entity Relationship
diagram.

Does anyone have any suggestions?

Thanks!

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___