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.

Logical Model - Relation Use Existing Attribute Rather Than Create New Attribute

littlecatMay 13 2022

When using logical model if I already FK attribute in entity, can I use this as FK attribute when create relation to parent entity rather than Data Modeler creating new attribute. For example I already have dept_no in employee entity and create 1:M relation from dept to employee, this will create additional attribute of dept_no1 in employee table. I wish to use existing dept_no attribute to employee entity. Or is this philosophy about where FK attributes should only be created by creating relation and entities should only contain attribute about the entity?
I know can achieve similar with relational model where get to select pre-existing column and new generated column will be removed.

Comments

Post Details

Added on May 13 2022
1 comment
119 views