A humble guide to database schema design
> Never store firstname and lastname in the same field<p>I disagree. Why would you want to force the "firstname lastname" pattern on people? What if someone has three names? Or only one? Just use a "name" field!