Re: CASE (ERD) tool recommendations

Perhaps I'm ignorant, but
I have been using the XTG tool. I find that I cannot have a foreign key with a different name than the primary key -when I change one, the other automatically changes.

I could see why someone would like to use such a naming convention in their modeling, but is it mandatory?

Please Advise.

John.
<argosy22_at_my-deja.com> wrote in message news:8cit66$kkc$1_at_nnrp1.deja.com...
> HI,
>
> Thanks for all your recommendations!
>
> If anyone is interested,
> I found a good product that works well, and is only $99.!
>
> http://www.XTGSystems.com
>
> although you have to know what you're doing to get it to do
> what I was thinking.
>
> Ciao,
>
> Rodger
>
>
> In article <8ca9rq$1pe$1_at_nnrp1.deja.com>,
> argosy22_at_my-deja.com wrote:
> > HI all,
> >
> > We are looking for a new ERD tool.
> > I have used ERWIN before and evaluated others.
> >
> > My main criteria with the database is that:
> > - when a dependent child table relationship is created,
> > the modelling tool will automatically create a
> > compound/concatenated key for you.
> >
> > ie.
> >
> > EMP EMP_CHILDREN
> >
> > EMP_ID EMP_ID
> > CHILD_ID <- PK above here
> >
> > STATE_ID
> >
> > Of course, this does not apply to independent
> > relationships: such as between the STATE table, and EMP.
> >
> > I have seen how this can be a really religious
> > discussion sometimes, but I just want to know the
> > tool that forces things to be done this way.
> >
> > Thanks,
> >
> > Argosy
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Apr 21 2000 - 00:00:00 CEST