Dave Stratford wrote:
> Hi folks,

The simple answer to all this "normalisation".

Here's a couple of links to get you on your way:
http://dev.mysql.com/tech-resources/...alization.html
http://www.databasedev.co.uk/databas...n_process.html