At this point, there is another source of redundant data, namely, the HORSE, DAM, and SIRE entities. A horse could appear in two of these three entities since a horse could both compete in races and also be a Dam or Sire. This situation can be resolved by combining these three entities into just one: HORSE. This process is called entity generalization.
The entity relationship diagram now looks like this:
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|