Re: Erwin? Oracle? or me?

Yes it did help Thank you very much.

My next question is why would there be a need to make the distinction between identifying and non-identifying relationships?

Ralf Todte wrote:

> On Wed, 13 Dec 2000 07:44:00 GMT, Barnel <barnel_at_ottawa.com> wrote:
>
> well it's just you!
>
> in erwin you can mark a relationship as identifying (the default i
> think ) an the foreign key will become part of the primary key.
>
> so you have just to mark the relationship non-identifying.
>
> hope that help's
> ralf
>
> >Using Erwin I've establish a relationship between the following
> >entities.
> >
> >Person >|0---|- Neighborhood >|0----|- City >|0---|- Province
> >
> >I am trying to make the following statement
> >A person is part of a neighborhood
> >A neighborhood is in a city
> >A city is in province (well it is for most Canadians but that's besides
> >the point)
> >
> >After doing that Erwin will take the primary key attribute of
> >neighborhood, city and Province and make them the foreign key of Person
> >which from there will make these foreign key attributes part of the
> >primary key of person.
> >
> >I understand why the the primary keys of all these entities are now in
> >the person entity but I do not understand why they are part of its
> >Primary Key.
> >
> >Does it have to do with the fact that Oracle is my target database? Is
> >Erwin trying to tell me how to uniquely identify a person? Any thoughts?
> >
Received on Wed Dec 13 2000 - 19:31:26 CET