 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Sep 2003 @ 12:52:16 GMT
| Subj: | | Re: Changing PK values |
| |
| From: | | Jose Lora |
About the PK, the rule says that a PK should be stable, minimal, factless, definitive and accessible.
Stable:
"The value of a PK must not change or become null throughout the life of each entity occurrence. If a PK value changes, then
it's another occurrence, it's not the same object"
(Brooks, 1992)
"A stable PK will help the model maintain referential integrity and guarantee update rules will not produce anomalies"
(Whitener, 1989)
Jose Lora
Senior Systems Engineer
Meredith Corporation
| |
