When transforming an extended E-R model into a relational database design,recursive relationships are treated fundamentally the same as other HAS-A relationships.

Question

Quizplus · Accepted Answer

Recursive relationships in an extended E-R model can be transformed into tables in a relational database design by creating a foreign key that references the same table. This is similar to how other HAS-A relationships are handled in the design process.

When Transforming an Extended E-R Model into a Relational Database