Ten ways to wreck your database

http://it.toolbox.com/blogs/database-soup/ten-ways-to-wreck-your-database-32814

http://www.oreillynet.com/pub/e/1371

Overview from Matt:

His points:

1. One big spreadsheet
2. Random naming
3. No keys
4. No foreign keys
5. No constraints
6. Non-atomic fields: type=user, type=administrator, type=inactive
7. Magic numbers: id=999999, id=0, date=2008-02-30
8. Polymorphic fields: contact_info=555-1212, contact_info=email@example.com
9. EAV - entity-attribute-value:

   ID property setting

   1 height 66in

   2 eyes brown

   2 married? false

   1 age 34

   2 smoker? false

10. Let the ORM do it

Point 9 was the only one new to me... sure looks a lot like Mosuki's cert table.