Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Guidelines for using ERwin

Re: Guidelines for using ERwin

From: Jared Still <>
Date: Tue, 27 Jun 2006 11:41:13 -0700
Message-ID: <>

On 6/26/06, <> wrote:
> We are pretty new to modelling tools and we decided to buy Erwin from
> CA. The deal is now that I need to write down some guidelines for the
> developers on how to use the product and what "rules" to obey when using
> it.
> So I was wondering whether anybody out there has a paper on that topic
> that could guide me a bit?

That's a very broad topic you have initiated. Not one easily addressed in an email.

It it made even more broad by the fact that you have purchased one of the more powerful modeling tools available, at least one that does not come with break-the-bank pricing.

Though I have not used Erwin, I've been told it is fairly comprehensive. I have made extensive use of Case 5 and Designer 2000 for database modeling and design, also comprehensive tools.

There is a lot to consider:

Naming standards

One thing I noticed was that developers would be using the tool. Do the developers know anything about data modeling?

Data modeling is not about designing tables, it is about modeling the data that is needed to supply the correct data to an application.

Education in data modeling should be considered mandatory.

Do the developers have interviewing skillls? They will need them, as they will need to interview the folks they are writing the app for, and need to understand what the users really need. Which is not necessarily the same as what they want.

When it comes to designing the database, do the developers know the rules of normalization? And not just the first 3 either, but 4,5 and BCNF.

Normalization is not as difficult as it first appears, but is extremely important for maintaining accurate data, performance and reducing the amount of code written to support the app.

You might like to point your browser at google to find articles at

Two of the best books on DM in my opinion:

I've rambled long enough, time for someone else to give it a shot. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Tue Jun 27 2006 - 13:41:13 CDT

Original text of this message