From the Geeks Not Nerds blog there's the first part of a new series of tutorials looking to help you create your own blogging backend from scratch (PHP5, SQL, HTML and Javascript).
This is the first of a multi part series that will cover designing and building a blog backend from the ground up. The goal of this series is to have a fully functional (albeit simple) blog backend as the final product of the series. We will focus more on good programming technique and design and less on the actual coding of the blog, writing just enough to make a functional example.
They step through the basic design of the application before anything else, laying down the structure for things to come. From there, they move into the database structure for the rest of this part of the series. They even provide the SQL file you'll need to get their structure set up quickly and easily.