Some tutorials and resources on designing relational databases.
Practical Database Design, part 1: Keys and datatypes
Practical Database Design, part 2: Normalization, history, and event logging
An Introduction to Database Normalization