Krishna Patel wrote:
>> Thanks to all those who answered my novice question yesterday. Cheers!
>> The ftp sites and FAQs make no mention of any entity/relationship
> diagrams for ACEDB or similar.
>> Has someone constructed an ER Diagram of ACEDB? Is such an ERD
> available somewhere? If so could someone please let me know.
I'll take a crack at this. Hopefully I understand the question
Although the usual ACEDB distribution contains a models.wrm which
defines a "schema" for the database, it is really just a starting
point. It can be changed easily; many variations exist. There are
several versions available from the Sanger Centre web site which
support different projects and databases. In other words, the
ER diagram is totally dependent on the models used in the database.
It would be interesting if there were a tool analogous to SilverRun
for Sybase that would generate such a diagram, give a definition
in the form of a models.wrm file. I haven't seen such a tool however.
Maybe someone would like to write one-- I would use it!
Eric E. Snyder, PhD
Associate Director of Genome Analysis
Sequana Therapeutics, Inc.
11099 North Torrey Pines Road, Suite 160
La Jolla, CA 92037, USA N 32 54'32" W 117 14'26"
(619) 646-8279; (619) 452-6653 fax; eesnyder at sequana.comhttp://beagle.colorado.edu/~eesnyder