Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Partial use of foreign key attributes

Robert HuberSep 1 2020 — edited Sep 10 2020

Quite some time ago I asked this in a similar form already. But as it always hinders me in design and implementation (and, in getting 0 differences when synchronising data dictionary with model), I like to discuss/request it again.

In my logical model, there is in an entity b having some foreign key attributes coming from a relationship between entity a and entity b. Let's say entity b has 5 fk attributes from entity a. I only need 2 of them as primary key attributes (together with some more attributes of the entity b).

In this example, I can set the 2 FK attributes as PK attributes and save the design, but as soon as I reopen it, all 5 foreign key attributes are automatically checked as PK attributes again. As entity b has relationships to other entities (entity c, d, ...), it has quite a lot of unwanted impact, i. e. creating unwanted foreign key attributes in these other entities.

And, of course, if I engineer the logical model to the relational model, the unwanted attributes are transferred to unwanted columns.

My request is to allow for exactly the PK attributes I need , independently of being it a FK attribute or another attribute. That would help a lot.

Thanks and regards,

Robert

This post has been answered by Philip Stoyanov-Oracle on Sep 8 2020
Jump to Answer

Comments

Processing

Post Details

Added on Sep 1 2020
2 comments
332 views