Relations in Designer ERD
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.