Skip to Main Content

DevOps, CI/CD and Automation

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!

Relations in Designer ERD

Mohannad HershMar 2 2010 — edited Mar 3 2010
Dears,

i was creating ERD in oracle designer and i faced this issue:
i have 4 tables a,b,c,d
primary key in a is com_no which is a foreign key in b,c
so primary key in b is b_seq, com_no
and primary key in c is c_seq , com_no
both b and c primary keys are referenced from a foriegn key in d so i suppose the primary key in d
is d_seq, b_seq,c_seq, com_no
but when generating ERD i will have the primary key like this
d_seq, b_seq,c_seq, b_com_no,c_com_no
is this correct? if no how to manage?

thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2010
Added on Mar 2 2010
3 comments
3,566 views