Draw the ERD for a 1:1 self-referential relationship for made-up entity XYZ.  Include PKs and FKs and proper crowsfeet symbols. Make up names for the PK and FK(s), and add at least one more made-up attribute.

Make a reasonable assumption about the mandatory/optional participation and indicate it in your ERD. 

 

Explain the relationship (including the mandatory/optional participation).

Answer rating: 100% (QA)

Solution ERD for 11 SelfReferential Relationship for XYZ Entity Entity XYZ Primary Key PK XYZID inte... View the full answer