Re: Erwin? Oracle? or me?

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 - 18:14:58 CET