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!

Q: Data Modeler - Logical Model - 0 or 1 to....relationships...

User642074-OracleNov 29 2011 — edited Nov 30 2011
Hi,

I’m currently at a client where we’re using Oracle SQL Developer Data Modeler to design our Logical Data Models (as part of an overall deliverable).

When in the Oracle SQL Developer Data Modeler (in the logical view), I’m trying to figure out if the tool has the ability to create a “zero or one to” relationship between entities.

According to the relationship options available, it only seems to show:
One to One,
One to Many (*),
Many (*) to One, or
Many (*) to Many (*)


In the preferences – Data Modeler – Diagram – Logical Model, the notation type is set to “Barker”.

I don’t see anywhere else where configuration can affect the variation of these options…


Is there a way to show either a “Zero or One to…” relationship between entities?


I’ve also loaded version 3.1 (beta) and it appears to be behaving the same as 3.0…


Any insights are greatly appreciated…



Thanks,

Patrick
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2011
Added on Nov 29 2011
3 comments
2,046 views