Basically you need to understand the business requirements and then validate that the data structure will meet them. It's conceptually insanely simple. It's a ton of work in practice.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning