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.
First read the answer fully, then try to explain it in your own words. After that, open a few related questions and compare the concepts. This method helps you remember the topic for a longer time and improves exam preparation.