Planet CakePHP

Relational Database Design is one of the most powerful ways to ensure
data integrity and a great way to kick-off any project. Very often the
first thing developers do when starting a new project, or stub-project,
is to design the database. This way the structure of the application is
already in place and we just have to fill in the pieces with some
server-side code. I've found when adding relational constraints to your
database design you add in a very powerful error reporting tool that
will let you know during the development process that you have allowed
something to happen that shouldn't have. In this article, I go through,
step by step, showing how to set up a simple relational database and
discuss the benefits that are enjoyed.