A humble guide to database schema design
> Never store firstname and lastname in the same fieldI 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!