When designing a database for a growing organization

When designing a database for a growing organization, what are the key considerations to ensure the database remains both scalable and maintainable over time? Discuss how the initial design decisions, such as choosing the appropriate schema structure, defining relationships, and setting indexing strategies, can impact the database's performance, data integrity, and future adaptability.