Superdeformations in Relativistic and Non-Relativistic Mean Field Theories