One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an…