By Volume4
via dev.mysql.com
Published: Mar 24 2006 / 18:19
The most challenging of these to maintain and rework suffer from what one author described as the Spreadsheet Syndrome: a tendency for the developer to lump every possible piece of information into as few table as possible, often into a single table.
A schema that suffers from the Spreadsheet Syndrome is subject to data redundancies, data anomalies, and various inefficiencies. The cure for Spreadsheet Syndrome is database normalization.
Comments
bonlebon replied ago:
If your nomalization yields 4 or more tables that's a aberration IMHO.
Voters For This Link (5)
Voters Against This Link (0)