[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Documenting entity relationships (AREV Specific) ====
=== At 25 JUL 2001 03:04:32PM Wilhelm Schmit wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
We have to document the Entity-Relationship of a system based on AREV (with extensive use of @vm, @svm, @tm and @stm).

Is there any utility (similar to ERwin) able to create the diagram directly from dictionaries?

Any comments will be appreciated.



Wilhelm
</QUOTE>
----

=== At 25 JUL 2001 05:10PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]  wrote:  ===

<QUOTE>We are not aware of any commercially available utilities to do this. A product called InfoModeler grew out of such an attempt in the early Nineties but it went down another route. It is now just a standard modeling package. We use this to create the ERDs themselves from documentation we create from the system itself. The problem is that dictionaries themselves are not enough to create the ERD as referential integrity rules which impact upon primary/foreign key relationships can also be contained in indexes and/or data entry screens. 



[url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url] 

[i]World Leaders in all things RevSoft[/i] 

[img]http://www.sprezzatura.com/zz.gif[/img] 

 



</QUOTE>

----

=== At 25 JUL 2001 06:45PM Warren wrote:  ===

<QUOTE>Something I've been waving my arms in the air about since ARev 1.0...grumble grumble...

</QUOTE>

----

=== At 26 JUL 2001 05:33PM Wilhelm Schmitt wrote:  ===

<QUOTE>".... We use this to create the ERDs themselves from documentation we create from the system itself ....."



Putting referential integrity aside: How do you tie together the dictionaries and what do you do with files that have no dictionaries?



Or do you just create a text file with the basic items like entities & attributes and import it to the modeling package, where you add relationships, business rules and everything else?



TIA

Wilhelm

</QUOTE>

----

=== At 30 JUL 2001 01:44AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]  wrote:  ===

<QUOTE>We use printed reports to create the table structure manually. Most packages will import an Access table so you could import data definitions into Access then use this to reverse engineer the diagram. Frankly we don't bother as creating the table structures is the least of the work.



[url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url] 

[i]World Leaders in all things RevSoft[/i] 

[img]http://www.sprezzatura.com/zz.gif[/img] 

 

 

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=94D617A60D51F28485256A940068C918|View this thread on the  forum...]]