You design databases, but do you know about Normal Forms?
Some things need to be repeated from time to time, again and again: "The data in a record depends on The Key to the record, The Whole Key, and Nothing But The Key, so help me Codd."
Random link about Normal Forms, a subject you absolutely need to know in order to design relational databases correctly.