Relationships and Domains › Relationships in the Physical Model › Mandatory Non-Identifying Relationships in the Physical Model

Mandatory Non-Identifying Relationships in the Physical Model

In a mandatory non-identifying relationship, the columns that are migrated into the non-key area of the child table are required in the child table. Therefore, the foreign key cannot be null. A mandatory non-identifying relationship is drawn differently depending on the notation for your model:

• IDEF1X notation draws a dashed line with a solid dot on the child end.
• IE notation draws a dashed line with a cross on the parent end. The child end indicates the cardinality with:
  • Crows feet with a cross and a circle, as shown below (Zero, One or more)
  • Crows feet with a cross (One or more)
  • A cross and a circle (Zero or one)
  • A dashed line (Exactly n)
• DM notation draws a dashed line.