Diagrammatic Methods for Strongly-Correlated Electrons in Realistic Systems