Quite often we need an approach where we need to Insert record if it is not already present. Sometime to manage relationship. There are few different way of doing it,…