✏️ Explanatory Question
Answer with Explanation
A foreign key that refers to its own relation is called self-referencing foreign key. It is also known as recursive foreign key. To understand the concept of self-referencing foreign key, consider the EMPLOYEE relation shown in Figure below. In this relation, EMP_NO is the primary key and the attribute MANAGER refers to EMP_NO and thus, is the self-referencing foreign key.
