Frustration, entanglement, and correlations in quantum many-body systems