On the structure of the sally module and the second normal Hilbert coefficient