I don't really have a direct answer for you, but I wonder whether it might 
be helpful to use either one XSL stylesheet, or perhaps a series of XSL 
stylesheets applied in succession, to extract just the key/keyref 
information from the schema documents.  I'm really not familiar with the 
marketplace for tools that draw ER diagrams, but it seems plausible that 
with some stylesheet work you could transform the key/keyref information 
into a form that would be suitable for input to such a specialized 
drawing/modelling tool.

Noah

--------------------------------------
Noah Mendelsohn 
IBM Corporation
One Rogers Street
Cambridge, MA 02142
1-617-693-4036
--------------------------------------








BANBURY David <David_BANBURY@r...>
Sent by: xmlschema-dev-request@w...
08/22/2008 12:36 AM
 
        To:     xmlschema-dev@w...
        cc:     (bcc: Noah Mendelsohn/Cambridge/IBM)
        Subject:        XSD to ER Diagram



Please excuse me if this query does not directly concern specific XSD
issues but I hope it is related closely enough to XSD development to be
worthy of the group's learned opinion.

We are using XSD to define an XML file format for data interchange. As
such the schema is not directly related to a specific system or
database. The schema relies heavily on key-keyref relationships to
describe the relational structure of the data model. It has proven very
useful throughout development to present the schema as an
Entity-Relationship Diagram but deriving an ER Diagram directly from the
XSD has been problematic.

Are there any tools available which will automatically generate an ER
Diagram from XSD?

Thanks for any information you can provide.

Regards,
David Banbury
 
Traffic Systems Branch
Roads & Traffic Authority of NSW
Australia
 
Tel: +61 2 8396 1417
Fax: +61 2 8396 1600

Before printing, please consider the environment.

IMPORTANT NOTICE: This e-mail and any attachment to it are intended only 
to be read or used by the named addressee. It is confidential and may 
contain legally privileged information. No confidentiality or privilege is 
waived or lost by any mistaken transmission to you. The RTA is not 
responsible for any unauthorised alterations to this e-mail or attachment 
to it. Views expressed in this message are those of the individual sender, 
and are not necessarily the views of the RTA. If you receive this e-mail 
in error, please immediately delete it from your system and notify the 
sender. You must not disclose, copy or use any part of this e-mail if you 
are not the intended recipient.