Common Errors in Database Design

• Flat file database

• Too much data

• Compound fields

• Missing keys

• Bad keys

• Missing relationships

• Unnecessary relationships

• Incorrect relationships

• Duplicate field names

• Cryptic field or table names

• Referential integrity

• Database Security

• Missing or incorrect business rules

• Missing or incorrect constraints

John Paul Ashenfelter, “Common Database Mistakes”, May 26, 1999, <http://webreview.com/wr/pub/1999/03/26/feature/index3.html> (Oct 10, 1999).

Previous slide

Next slide

Back to first slide

View graphic version