From oracle-l-bounce@freelists.org Wed Oct 13 08:34:52 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9DDYq917989 for ; Wed, 13 Oct 2004 08:34:52 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9DDYpI17983 for ; Wed, 13 Oct 2004 08:34:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E830D72C69A; Wed, 13 Oct 2004 08:40:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25725-53; Wed, 13 Oct 2004 08:40:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5744B72C68B; Wed, 13 Oct 2004 08:40:58 -0500 (EST) Subject: Re: recommendation of a free ER-Diagram software? From: Carel-Jan Engel To: "oracle-l@freelists.org" In-Reply-To: References: Content-type: text/plain Organization: DBA!ert Message-Id: <1097675137.13863.20.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 Date: Wed, 13 Oct 2004 15:45:37 +0200 Content-Transfer-Encoding: 8bit X-archive-position: 11018 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Guang, In stead of ER modeling I prefer ORM (Object Role Modeling. Nice tool for that was Infomodeler from Asymmetrix, until Visio bought that and Microsoft bought Visio and more or less discontinued Informodeler. Good part of the story that, in stead of an expensive product, Visiomodeler is an 'unsupported product' edition, that can be downloaded for free at http://www.microsoft.com/downloads/details.aspx?FamilyID=27FE6786-A439-4286-B8B6-7A9B84CFA709&displaylang=en ORM takes a little time to learn, but I think it is far better in communcating your idea's about the datamodel with the user. For instance, you don't create the n:m relationship tables in the model, but you simply model the n:m relationship between the objects. Visiomodeler will take care of the connecting tables during the generation process. Just give it a try, it's free. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === * On Wed, 2004-10-13 at 15:28, Guang Mei wrote: > Hi: > > I am looking for a free ER-Diagram software for my own personal use. I > have used ER/Studio (a commercial package) heavily before and I liked it. > But I couldn't afford it now. Is there some kind of freeware there that people like? > My requirements are > > 1. run on Microsoft PC > 2. GUI Interface, so I can draw ER diagram to create tables and > constraints > 3. can "export" the diagram into Image file > 4. can generate DDL script from the ER diagram. > > Thanks. > > Guang > > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l