Propagated composite keys or one surrogate key?
From: <adizon_at_mail.us.net>
Date: 1996/09/10
Message-ID: <94164.adizon_at_mail.us.net>#1/1
Date: 1996/09/10
Message-ID: <94164.adizon_at_mail.us.net>#1/1
In normalizing tables, the primary key of a parent table is usually
propagated to the child table. In a multi-level parent-child arrangement,
the lowest-level child table could have a composite primary key
consisting of several columns. What are the advantages and disadvantages
of substituting a single column as the surrogate primary key in place of
the inherited composite key?
Thanks,
Lito Dizon
Lito
adizon_at_us.net
Received on Tue Sep 10 1996 - 00:00:00 CEST