Another Database Design Mistake To Avoid. Actually, one of the worst DB design mistakes you can make.
One of the worst things you can do to a database system is to make a generic data model of three tables for the whole system. A variation is to use three tables to combine multiple lookup tables into one.
Instead of standard tables and columns, three tables are used for everything.
One table each for:
entity/table
attribute/column/field
values of the data
Read the rest of this entry »