Re: Normalization, Natural Keys, Surrogate Keys

c_cozianu_at_hotmail.com (Costin Cozianu) writes:

[_excellent_ discussion snipped]  

> No, using surrogate keys is terrible for a logical design and the
> flexibility comes only with sacrficing data quality goals. The only
> considerations that justify surrogate keys, is the inability of RDBMS
> to efficiently manipulate at the physical level (dsik layout) keys
> that are multiple columns and big in size. Also, no database that I
> know of has an otpion like ON UPDATE CASCADE for foreign key to
> allow for update propagations.
>
> But feel free to disagree.
>
> Costin

FWIW, MS SQL Server 2000 supports ON UPDATE CASCADE.

-- 

Daryl Richter
Lead Programmer, Exelon Power Team

http://www.exeloncorp.com/powerteam