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

Ashenfelter, J. P. (March 26, 1999). Common Database Mistakes. Found online at <http://webreview.com/wr/pub/1999/03/26/feature/index3.html> (June 5, 2000).

Previous slide

Next slide

Back to first slide

View graphic version