Database indexing – whose role is it anyway?
vertabelo.com
vertabelo.com
In my opinion, a critical part of creating a schema is designing it to work well with the expected access patterns. If a software architect is just dictating a rough schema without thinking about the queries that will be issued and the expected nature of the data in the database, the architecture simply isn't complete. I'm all for iterative design and whatnot, but that means that the architect needs to stick around and help out throughout the system's lifecycle.
Sounds like the original author is working with some pretty checked-out architects.