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!

Relation Properties - Cardinality - "Identifying" vs. "Target Optional"

Jeff KFeb 7 2011 — edited Feb 8 2011
Version 3.0.0 build 653

Using the logical design, within the "Relation Properties" > "Cardinality" dialog,
the "Identifying" and "Target Optional" checkboxes are mutually exclusive.
Can somebody explain that to me?

The help defines "Identifying" as:
"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.)"

and "Target Optional" as:
"Controls whether the *target entity in the relation must contain one or more instances*. If this option is enabled, there can be zero target instances; if this option is disabled, one or more target instances are required."

Just because a target entity's PK includes the source entity's PK,
why would that require an instance of the target entity to exist?

I'm trying to model a parent/child relationship where an instance of the child entity can't exist without the parent instance (no orphans) but that shouldn't make an instance of the child entity required.
I'm far from a data modeling guru so thanks in advance to whomever can explain what I'm missing.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2011
Added on Feb 7 2011
1 comment
571 views