Properties of finite nuclei using effective interaction: Structure of drip-line and super-heavy nuclei in effective relativistic and nonrelativistic interactions