1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying. The first 2 groups have very biased views of how data should be structured for VERY different reasons, neither of which usually solves the entire problem.