Avoiding Anomalies

The simplest way to avoid update anomalies is to sharpen the concepts of the entities represented by the data sets. In the preceding example, the anomalies are caused by a blending of the concepts of orders and products. The single data set should be split in two data sets, one for orders and one for products. Certain questions and updates can be made to orders independent of products and vice versa.