Parent entity PK
|
Child entity PK
|
Propagated PK/FK in child entity
|
Data element name: ID Attribute name: ID
|
Data element name: ID Attribute name: ID
|
Rule 1: Role name: Cust_ID ID [PK] Cust_ID.ID [PK][FK]
|
Data element name: ID Attribute name: ID
|
Data element name: ID Attribute name: ID
|
Rule 2: No role names: ID [PK][FK]
|
Data element name: ID Attribute name: ID
|
Data element name: ID Attribute name: Cust_ID
|
Rule 2: Role name: Cust_ID Cust_ID.ID [PK][FK]
|
Data element name: ID Attribute name: ID
|
Data element name: ID Attribute name: Cust_ID
|
Rule 3: No role name Cust_ID [PK] ID [PK] [FK]
|
Data element name: ID Attribute name: ID
|
Data element name: X_ID Attribute name: ID
|
Rule 4: No role names: ID [PK] ID-1.ID [PK][FK]
|