How to set relationship between custom tables in Drupal views

Here we are discussing how to implement an explicit relationship between two custom tables in views.

Here we are exposing two custom tables into views UI and using relationship,  display all data of both tables in a view using relationship feature of view system.

We have below two custom tables in our Drupal database.