General Relationships between Species Diversity and Stability in Competitive Systems