What relationship pattern is illustrated in the following schema?
EMPLOYEE (EmployeeID,OfficePhone,Manager)
Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship

Question

Quizplus · Accepted Answer

The schema illustrates a recursive relationship where an Employee can also be a Manager and the Manager column references the EmployeeID column in the same table.

What Relationship Pattern Is Illustrated in the Following Schema