Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Problems that Can Arise from an Improperly Designed Database

The following problems can occur because of an improperly designed database:

• Redundant data

• Limited data tracking

• Inconsistent data

• Update anomalies

• Delete anomalies

• Insert anomalies

Redundant Data

As you can see in the sample table in Figure 17.1, several names and descriptions are continuously repeated. This increases the amount of physical storage required to track training data.

Figure 17.1. Redundant data.

Limited Data Tracking

The table design in Figure 17.2 is limited to tracking three training courses per employee. Additional columns must be added to the table if you want to track ...