Blog: Giuseppe Maxia on database normalisation and smoking

Views:
6196
Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser.class.php on line 982 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 567 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1210 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1221 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1264 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1281 Deprecated: Assigning the return value of new by reference is deprecated in /var/www/phpfreaks-site/library/StringParser/stringparser_bbcode.class.php on line 1535

New user registers, new set of tables is created in database. We see this database design quite often on phpfreaks forums. And each time we see it, we explain why it is wrong.

No more! From now on we can link to Giuseppe Maxia's blog [http://datacharmer.blogspot.com/], where he gives a very graphic description of what will happen to your database if you implement such design.

Read "Normalization and smoking [http://datacharmer.blogspot.com/2009/03/normalization-and-smoking.html]" and drop your habit.