Notation and Cardinality
IE Notation
Cardinality
One-to-many relationship is represented by this symbol:
One-to-one relationship is represented by this symbol:
Parent: mandatory Child: mandatory
Parent: mandatory Child: optional
Parent: optional Child: mandatory
Parent: optional Child: optional
IDF1X Notation
Cardinality
, , zero, one or more
one or more
zero or one
Parent: mandatory Child: mandatory
Parent: mandatory Child: optional
Parent: optional Child: mandatory
Parent: optional Child: optional
See Synchronization of Not Null and Mandatory Parent for more information.
Relationship Types
Identifying Relationship
Non-identifying Relationship
Non-identifying Self-relationship
M:N Relationship
Mandatory/Optional Parent/Child
To set Parent/Child entity as Mandatory/Optional
- Double-click a relationship on workspace to open Relationship Properties.
- Switch to the General tab and check/uncheck Mandatory Parent/Child checkbox in the Cardinality section.
Parent: Mandatory
Child: Mandatory
A teacher MUST teach a lecture (the record related to lecture is mandatory), a lecture MUST be taught by a teacher (the record related to teacher is also mandatory. Teacher is Mandatory.)
Parent: Mandatory
Child: Optional
A teacher MAY teach a lecture (the record related to lecture is Optional), a lecture MUST be taught by a teacher (Teacher is Mandatory.)
Parent: Optional
Child: Mandatory
A teacher MUST teach a lecture (lecture is Mandatory), a lecture MAY be taught by a teacher (teacher is Optional).
Parent: Optional
Child: Optional
A teacher MAY teach a lecture (lecture is Optional), a lecture MAY be taught by a teacher (teacher is Optional).
The information can be found on Relationship Properties form, see graphical representation at bottom of the form.
Set up Referential Integrity Rules
To set up referential integrity rules for Parent entities
Open the Relationship Properties form and see the Referential Integrity group box.
Here, you can change the None rule to:
- Restrict
- Cascade
- Set Null
- Set Default
The default rule can be re-configured.
|
Note: Some databases do not support Referential Integrity (RI) rules. |
Connect Parent and Child Entities
Toad Data Modeler allows you to connect Parent and Child entities through the following unique values:
- Key (Primary or Alternate Key) of parent entity
- Unique Index of parent entity
To change the linking method
- Open the Relationship Properties form and see the Relationship Type group box.
- From the Parent Key box, select the method. If neither Unique item, nor Alternate Key exists, only the Primary key is available.
|
Note: Some databases do not support Alternate Keys. |