Chapter 4, Problem 4.25RQ

Explanation of Solution

Recursive relationship:

An entity which calls by itself more than once in different roles with a relationship are termed as a recursive relationship.

Example:

Consider the “Employee” can be in post of “Manager” and a “Manager” can manage an employee. So, “Manages” is relationship with “Employee” entity in recursive manner.

E-R diagram for the above example:

The following “E-R diagram” demonstrates an employee has a manager and the manager manages many employees.

Explanation:

Employee entity “1:M” relationship with “Manages” relationship which means an employee can be in the post of manager and a manager can manage many employees...