Toad World® Forums

Non-identifying realtionships

Is it possible to create a non-identifying relationship in the physical model where I can select the parent and child? I am working with a DB that was designed w/o FK and I am trying to model it in a way that others can understand how tables relate to one another. I would rather not use the the line option as it does not allow for naming the line. I am using a SQL Server model.
Thanks…Mike

Hi,

yes, this is possible.
In version 3.x it was necessary to manually map the attributes:
http://modeling.inside.quest.com/entry.jspa?externalID=1668&categoryID=158

In version 4.2 automatic foreign keys mapping is available:
http://modeling.inside.quest.com/entry.jspa?externalID=4825&categoryID=158

Regards,

Vaclav

I have updated the setting to ‘always ask’ yet I am still unable to set the parent and child values. Any other options?
Thanks…Mike J

Hi,

the attributes must have the same name and data type. Otherwise you will have to edit the relationship and map the attributes manually. See the first movie.

Regards,

Vaclav

Understood…But that still does not allow for me to change the attribute of the parent - only the PK is allowed. If that is the case, is there another way of displaying a non-identifying relationship in a PM? I am using TDM 4.2

Hi,

if you wish to change parent attribute, edit the parent entity, create new alternate key on tab Keys and add the required attribute to the alternate key. Then edit the relationship and on tab Foreign Keys select the new alternate key from combo box Parent Key.

Regards,

Vaclav

Thanks for the help. Although not elegant, it will work for this situation.

Hi,

thank you for your feedback. Unfortunately I think there won’t be much elegant solutions, due to the fact that there are some rules that should be followed (create relationships only via existing keys and not on columns that do not belong to any key etc.).

Regards,

Vaclav