1:N Relation Vs 1:N Relation Identifying

Rajneesh S-Oracle

Hello All,

What is difference between

1 :N Relation Identifying and 1:N Relation as depicted below:

Dave Schleis

Hello Rajneesh

According to the on-board help regarding Relationships:

Identifying: Controls whether this is an identifying relationship. When there is an identifying relationship between a parent entity and a child entity, when the relational model is generated, the following occurs in the child table: the foreign key to the parent becomes part of the primary key of the child. (In non-identifying relationships, the foreign key to the parent table is just another column in the child table and is not part of the primary key.)

Pressing F1 while in a dialog box will display the available Help for that dialog box, as seen in the image below.

hope this helps

--dave

Dave Schleis

Hello Rajneesh

According to the on-board help regarding Relationships:

Identifying: Controls whether this is an identifying relationship. When there is an identifying relationship between a parent entity and a child entity, when the relational model is generated, the following occurs in the child table: the foreign key to the parent becomes part of the primary key of the child. (In non-identifying relationships, the foreign key to the parent table is just another column in the child table and is not part of the primary key.)

Pressing F1 while in a dialog box will display the available Help for that dialog box, as seen in the image below.

hope this helps

--dave

Rajneesh S-Oracle

Thank you Dave !!!