Discuss the concept of design trade-offs and how they influence software design decisions, including performance vs. scalability, flexibility vs. simplicity, and consistency vs. availability.