What is important to keep in mind when designing a database?

database-design

Solution

"Normalize till it hurts; de-normalize till it works."

Problem

What is important to keep in mind when designing a database? I don't want to limit your answer to my needs as I am sure that others can benefit from your insights as well. But I am planning a content management system for a multi-client community driven site.

Original source