Double-clicking a relationship on the EER diagram canvas opens the relationship editor. This has two tabs: Relationship, and Foreign Key.
The Relationship Tab
In the Relationship tab, you can set the
caption of a relationship using the Caption
field. This name displays on the canvas and is also the name used
for the constraint itself. The default value for this name is
Use the Model menu, Menu
Options menu item to set a project-specific default
name for foreign keys. To change the global default, see
Section 7.3.5, “The Model Tab”.
You can also add a secondary caption and a caption to a relationship.
The Visibility Settings section is used to
determine how the relationship is displayed on the EER Diagram
Fully Visible is the default but you
can also choose to hide relationship lines or to use split lines.
The split line style is pictured in the following figure.
A broken line connector indicates a nonidentifying relationship. The split line style can be used with either an identifying relationship or a nonidentifying relationship. It is used for display purposes only and does not indicate anything about the nature of a relationship.
To set the notation of a relationship use the Model menu, Relationship Notation menu item. For more information, see Section 188.8.131.52.4, “The Relationship Notation Submenu”.
The Foreign Key Tab
The Foreign Key tab contains several sections: Referencing Table, Cardinality and Referenced Table.
The Mandatory check boxes are used to select
whether the referencing table and the referenced table are
mandatory. By default, both of these constraints are
true (indicated by the check boxes being
The Cardinality section has a set of radio buttons that enable you to choose whether the relationship is one-to-one or one-to-many. There is also a check box that enables you to specify whether the relationship is an identifying relationship.
Copyright © 2006, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices