Re: Database model/design/implementation tool?

Paul Mailman wrote: > > We are looking for software to assist in database design. The package would > allow interactive development of a database model, entity relationships, etc.; > ideally generate required SQL code for implementation; provide database model > documentation (e.g. ER diagrams). > > Our immediate need is for something that works with Informix SE under Unix, > although a program that has the flexibility to support a variety of back-end > platforms would be a plus. Win95-compatible front end preferred. > > Suggestions from users and information from vendors are welcome. Email to > pamailman@qed.com appreciated. The best tool that I have seen is ERwin. It comes in versions for different front end tools, but the vanilla version works just fine. At about $3k per seat, it's the best value for the money. (I do NOT work for the company the makes it {Logic Works}, nor do I have any interest in the sale of the product.) I can tell you that Intel, where I used to work, uses it very widely. I think that you'll find it easy to learn, but still powerful enough to do what you want. I now work for a consulting company. I introduced the tool a few weeks ago, and now the folks here just think it's the best thing since integrated processors. Tom "Everything's a Database" Abraham