First, the rule type that prevents the addition of duplicate records will be dis-
cussed.
Prevention of Duplicate Records
There are two ways in which a table can end up with duplicate records. The first is
when a new record is added to the table. The primary key columns of this record
may contain values that are found in another record in the same table. The second
way is that after a record is successfully added to a table it may be updated so that
the values in its primary key columns change. These values may now duplicate what
is found in another record in the same table. For instance, one new record may be
added to the Investment table with a value of Investment ID (the primary key column)
equal to “DOGFOOD”, and another record may be added with ...