How to design databases?
Start with "database design" on Wikipedia.

I'd also recommend using Object Role Modelling to capture your conceptual model

Otherwise, your question is far too broad.

What you don't do is start knocking out some CREATE TABLE statements, or design as go along writing client side code