Forum Stats

  • 3,780,918 Users
  • 2,254,456 Discussions
  • 7,879,492 Comments

Discussions

1:N Relation Vs 1:N Relation Identifying

Rajneesh S-Oracle
Rajneesh S-Oracle Posts: 408 Employee

Hello All,

What is difference between

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

pastedImage_0.png

pastedImage_1.png

Rajneesh S-Oracle

Best Answer

  • Dave Schleis
    Dave Schleis Member Posts: 215 Silver Badge
    edited May 29, 2020 8:22AM Accepted Answer

    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.

    Screen Shot 2020-05-29 at 7.17.16 AM.png

    hope this helps

    --dave

    Rajneesh S-OracleRajneesh S-Oracle

Answers

  • Dave Schleis
    Dave Schleis Member Posts: 215 Silver Badge
    edited May 29, 2020 8:22AM Accepted Answer

    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.

    Screen Shot 2020-05-29 at 7.17.16 AM.png

    hope this helps

    --dave

    Rajneesh S-OracleRajneesh S-Oracle
  • Rajneesh S-Oracle
    Rajneesh S-Oracle Posts: 408 Employee
    edited May 29, 2020 9:45AM

    Thank you Dave !!!