So, a friend of mine and I are tagging up to learn a little with php and mysql. Php is coming along swimmingly, but the mysql is a bit of a challenge right now. Part of what we're working on now is ...

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.

If you’ve worked with relational database systems for any length of time, you’ve probably participated in a discussion (argument?) about the topic of this month’s column, surrogate keys. A great ...