Username or EmailPassword
Not this old chestnut again.
Yes many years ago I like many used to suffer from 'RPM Hell'.
In recent years, I hardly ever use 'rpm' directly. Yum and Packagekit makes 'RPM Hell' a thing of the past IMHO.
Also, many package producers have got their act sorted out so that wierd dependencies are included in the package they are supplying.
Sadly, Oracle RDBMS still needs some wierd rpm's to install correctly but this is down to Oracle being a PITA when it comes to any Linux apart from their own.