Re: On Normalisation & the State of Normalisation

On Tuesday, February 3, 2015 at 4:16:26 AM UTC-8, Erwin wrote:
> (which is how the normalization procedure really goes)

Interestingly for this application: An envelope gets to a particular address. Ids do not appear on an envelope. So after joining a correct set of tables and projecting out ids there must be a superkey among the remaining columns. The FKs correspond to FDs in the join. So there is a superkey from among Suburb Name, StreetName Name, StreetType Name and the non-id attributes of Address.

philip Received on Tue Feb 03 2015 - 13:44:50 CET